During 2021 the markets had a lot of ups and downs, but overall it was a great year for stocks.
Our portfolios in aggregate returned about 18% (adjusted for contributions in the fall of 2021 and amounts that were essentially un-invested in cash) during 2021. This compares roughly equivalent to the US markets that returned about 25% in aggregate and foreign markets that returned about 8% (by comparing against Vanguards VEU ETF which is large-cap stocks not including the USA), since our portfolios are a mix of them.
These portfolios are tracked in Google Sheets in two ways:
- a single consolidated portfolio tracker in google sheets, which has the shares by stock for each portfolio and the cash associated with each portfolio, to get the total value. I take “snapshots” of value at different types of the year, as you can see in the graph above. This google sheets doc is pretty easy to keep up to date and lets me see the markets at a glance; I notice when it seems odd and often it is a stock split which needs to be reflected in the underlying data. Buys and sells only take a few minutes for me to update in the sheet. I then reconcile the portfolios against the records online from our financial records
- 8 unique google sheets documents, one for each portfolio. These sheets have all the details for each portfolio, including the price of each stock purchase and the sale price for those that have been sold, as well as matching dividends to each stock over time (to get total return). I also have the cash flows over the years to calculate total return (gains / losses) as well as an annual return adjusted for the timing of cash flows
I typically update the individual google sheet documents periodically when we do buys and sells, usually around the fall of each year when we have contributions, but we often sell individual stocks due to unique circumstances throughout the year. All 8 of the google sheets are aligned to the consolidated sheet and the brokerage records as of now.