Portfolio four is almost 8 years old. The beneficiary contributed $4000 and the trustee $8000 for a total of $12,000. The current value is $15,082 for a gain of $3,082 or a 5% rate of return, adjusted for the timing of cash flows. See detailed PDF here or go to the link on the right side of the page.
The portfolio has some technology stocks that are doing quite well, which include Box and Oracle (you could also call Tesla a partial technology stock, as well). The oil stocks of Devon, Shell and Statoil have generally been hit by the continued fall in oil prices. The stock prices of Shell and Statoil have held up better than Devon because they kept their high dividends; Devon cut their dividend and has continued to fall (there are other factors at play as well).
It is important in all these portfolios not to just look at the current share price when compared with the purchase price; you need to take into account dividends, as well. The oil stocks look bad on stock price alone but when cumulative dividends paid are tracked as well, the situation is much better. That does not mean that we should hold stocks just for the dividends, but it is a very important factor in long run performance. To date this portfolio has earned $1735 in dividends, which makes up more than half of the total return earned to date.
I really enjoy working with Google Sheets and the Google Finance portfolio functions. Recently I moved tracking from excel to Google Sheets and sent links to the beneficiaries so that when they open the file, the stocks update automatically. I made 8 of these sheets and sent them to each individual beneficiary, and learned a lot along the way.
There still is some manual and redundant work done within each spreadsheet and for me to track performance, I had to open each sheet individually. Thus I went to work and built a summary sheet that taps into each of the 8 individual portfolios and shows performance against a 4/30/17 baseline (I just hard coded that baseline).
Recently I expanded that model to take each individual stock in any portfolio and make a consolidated view that included 1) sector information 2) US vs. Foreign 3) Yield 4) description of stock and reason for buying. Now I can update that table in one place and re-do each of the portfolios 1-8 so that these fields are updated and consistent across each portfolio (I still have to do that, but I will in the relatively near future). Here is a link to the data in PDF form.
Continue reading “New Google Sheets Analytics – Sector, US / Foreign, and Dividend Views”
Portfolio Four is 7 1/2 years old. The beneficiary contributed $4000 and the trustee $8000 for a total of $12,000. The current fund value is $14,444 for a gain of $2444 or 20%, which is 4% / year when adjusted for the timing of cash flows. You can see the detail here or go to the links on the right.
We have a couple of stocks on watch. Devon Energy (DVN) got waxed with the downturn of the oil industry a couple of years ago and has recovered a lot of its losses but cut its dividend significantly in the interim. DVN seems to be plateauing and is thus on watch. Oracle (ORCL), the technology company famous for its database software (although they own many other products, including cloud software) is in a long term price and technology war with AWS and other cloud providers (including Microsoft’s Azure). They have been performing well but are on watch as a result.
There are analytics on the “analytics” sheet. A few worth paying attention to is the price as a % of its 52 week high, which shows its relative strength over the last year (obviously anything near 100% means that the stock is moving up and hitting highs regularly). The portfolio is 68% US stocks and 44% of them are “high dividend” (meaning a dividend around 3% and higher).
Portfolio 5 is 7 1/2 years old. The beneficiary contributed $4000 and the trustee $8000 for a total of $12,000. The current value is $14,151 for a gain of $2151 or 18%, which is about 3.6% / year adjusted for the timing of cash flows. You can go here to see the portfolio or go to the links on the right side of the page.
The portfolio is about 50/50 with US and foreign stocks. Almost half the stocks are considered “high dividend” with a dividend of near 3% or greater. Gilead (GILD) is a recent drugmaker purchase and Anheuser Busch InBev (BUD) are both pretty well run companies on or near watch.
On a side note, this is one of the first portfolio to be almost totally run by formulas in Google Sheets. I incorporated vLookups and re-arranged the sheets a bit to have more of the information on buys and sells populate automatically. Due to these changes, it will be much easier to update this portfolio in the future and it will be the template that I will apply to the other portfolios as I migrate them to Google Sheets.
Portfolio 6 is 4 1/2 years old. The beneficiary has contributed $2500 and the trustee $5000 for a total of $7500. The current value of the portfolio is $7806 for a gain of $306 which is about 4% or 1% / year over the life of the fund. You can see a PDF of the details here or on the link to the right.
The portfolio is generally doing well. The stock mix is 55% US stocks and the largest exposure area is oil, at 27% of the total. High dividend stocks (3% yield or greater) make up 44% of the portfolio. We sold off Coca Cola Femsa (KOF) recently. The oil sector has generally been hit by the decline in oil prices per barrel but they have come up significantly from their lows.
Portfolio six has been around for about 4 1/2 years, with the beneficiary depositing $2500 and the trustee $5000, for a total of $7500. The current value is $7917 for a gain of $417, or about 6% or 1.8% / year when adjusted for the timing of cash flows. You can see the detail at the link on the right or download the spreadsheet here.
During the year we had about $136 in dividends for a yield of about 1.7%. We had one sale, of Coca Cola FEMSA with a long term capital loss of ($321). Our sales still look relatively good in hindsight. For the portfolio as a whole, it has mostly recovered from the fall in oil prices.
Portfolio Four is a bit over 7 years old. The beneficiary contributed $4000 and the trustee $8000 for a total of $12,000. The current value is $13,932 for a gain of $1932 or 16%, which is about 3.3% / year when adjusted for the timing of cash flows. You can see the detailed spreadsheet at the link on the right or download it here.
The portfolio is generally doing well. We sold LinkedIn (LNKD) because they were bought by Microsoft and gave up on Coca Cola FEMSA (KOF) which was hurt by the decline in the Mexican Peso and recent election results. We did not sell many of the energy companies which (mostly) held on to their high dividends and have risen recently with the uptick in oil prices. It is important that you look at the “total return” which includes dividends because some stocks look like they have losses just based on price bought vs. today when in fact they’ve been positive due to dividends.
The portfolio had about $240 in dividends for an average yield of about 1.7%. This is a good rate but down a bit from last year because we sold Seaspan (SSW) and Garmin (GRMN) which had high dividends. Most of our sales are still OK in hindsight but Garmin has gone up a bit since we sold it. We had a long term capital loss of $474 due to sales of LNKD and KOF, above.