View-only example look through portfolio
(set to GBP currency - only I can edit this but I think you can select and copy the cells into your own Google Drive spreadsheet):
https://docs.google.com/spreadsheets/d/1Ok3bOO4z_2Itbta6FguKbuFA1HvcQvzisspPBN6IpZY/edit?usp=sharingPublicly editable version of look-through portfolio:
(might get corrupted by someone else's edits, but you can have a play with it and try changing currency and number of shares held):
https://docs.google.com/spreadsheets/d/10gMfyZOFCW1-KrY_P8SGRf3pTstspdAGw_DuKSQxO8s/edit?usp=sharingAt time of posting this is updated to 30th June 2016 holdings as declared in 15th August 2016 13-F and the shares oustanding at the same date from the 10Q.
Commentary:I track our total personal portfolio and Watchlist using Google Sheets in Google Drive (the GOOGLEFINANCE function is very useful for currency conversion and delayed prices and basic financials such as EPS). I also use various tabs to track our investment ledgers and our monthly and annual deposits into our tax-advantaged investment accounts, and to keep an eye on our pension schemes.
I wanted to make a
look-through total portfolio, partly to gauge our total exposure to companies we hold that are also held by Berkshire Hathaway, such as Wells Fargo, where our look-through stake is about half of our direct stake because we're fairly heavily into BRK.
As a by-product, I've created a Google Sheet which you might wish to look at, borrow from or select-All and Copy into your own Google Sheet on Google Drive. If you paste into Excel or LibreOffice Calc you'll probably lose the GoogleFinance functionality.
The link below is my personal version (only I can edit it, but anyone can view it and I believe could copy and paste the cells to another sheet they can edit):
https://docs.google.com/spreadsheets/d/1Ok3bOO4z_2Itbta6FguKbuFA1HvcQvzisspPBN6IpZY/edit?usp=sharingThe link below this is publicly editable by anyone (so you can play with it, collaborate on it or paste the contents of the other sheet into it):
https://docs.google.com/spreadsheets/d/10gMfyZOFCW1-KrY_P8SGRf3pTstspdAGw_DuKSQxO8s/edit?usp=sharingIf you enter in the
blue cells your number of BRK class A shares and class B shares and your native currency (e.g. GBP, EUR, USD, CAD etc.) it converts it into equivalent B shares and it estimates look-through holding values from row 8 down, and in columns way over to the right, it includes the EPS reported by GoogleFinance. Some shares have an Error (N/A) so I set these to zero in totalling EPS per BRK.B, but these are mostly minor holdings, so the overall look-through EPS at the bottom right is about right.
As a crude indication, as for my full portfolio, I also include Low, Typical and High estimates of trading range based on some kind of fundamental and multiples of it. This also sets a colour scale to crudely indicate if the current market price is Low (DARK GREEN), Typical (BRIGHT YELLOW) or High (DARK ORANGE/BROWN). In my full portfolio I sometime use this colour scale to easily whittle down my list of candidates to sell at toppy prices in order to buy something else I think is cheap, and I use the Low/Typ/High idea to project long term retirement portfolio value without so much influence of current market-wide depression/euphoria.
For BRK this fundamental is Book Value Per Share. For most others it's EPS reported by GoogleFinance. Where EPS is negative or N/A I've estimated some other value such as normalised EPS - using very little effort of analysis!!!
Do your own research etc. and don't simply rely on the spreadsheet to make investment decisions!
Soon I expect to summarise the key figures near the top and the left of the sheet and perhaps make the look-through list filtered/sortable.