We recently completed our stock buying for the fall of 2017. We do the stock buying and matching in the fall so that beneficiaries can have the summer to make some money in order to do the match.
It is interesting that of the 6 stocks (and one ETF, IAU or gold) on the list, no one took Snapchat (SNAP). This is interesting because while it is popular with many of the beneficiaries (they use it), they can segregate whether something is useful or whether it may be a good investment. I had Snapchat on the list because I felt that it had been beaten down by bad sentiment and poor results and because it was burning cash BUT that this also created the opportunity for a turn upward (may be at the bottom). In the past I’ve been hesitant to put up stocks that are tied to products that the beneficiaries may use day to day because I didn’t want that to bias the selection process but it turns out I was wrong.
With Google Sheets it is much easier to track the portfolio real time. I have a summary sheet set up like the picture in this post and I can just glance at it on my phone from the google sheets app. I take snapshots of the values in each portfolio every month or so in order to see simple trends over time.
You can see our summer bull market in the results, although you need to mentally factor out the impact of $11,700 in contributions and $6000 in withdrawals across the period (net inflows of $5700). Thus based on some simple math above, across the portfolio we saw an increase of $154,073 – $136,791 = $17,282 and then you take out the net inflows of $5700 to get a net increase of $11,582 divided by our base of $136,791 from about 6 months ago which is 8.4% and if you roughly double it (to get annual performance) you see annualized performance of roughly 17% in the portfolio during essentially the summer and most of the fall of 2017.