For our portfolios I created a summary view in Google Sheets that updates automatically. I also “save” performance every month or so (per above) so that you can see performance across time. Note that this performance also includes additional investments and withdrawals so it isn’t “apples to apples” but is still useful. Generally we’ve gone up a lot in total since May along with the total market, and been pretty steady for the last couple of months.
Since moving portfolios to Google Sheets, I also centrally review “all stocks” and update yield (which cannot be determined via a Google Finance formula) manually. At this time I also go through the stock news and review some of the stocks that may be performance outliers, as well as remove information on stocks that we no longer track (like TTM and SAVE).
Some of the stocks noted:
- Dow Dupont (DWDP) – the merger has been completed. The stock is likely to split into three separate companies. I think we will sell now and take our gains and review the companies later that spin out. This also saves us from having just a few fractional shares (Portfolio 3)
- Juniper (JNPR) – there were rumors of a buyout for this network equipment maker. This company is at risk of remaining independent due to the migration to the cloud. It went up with the speculation (and back down when it didn’t occur). Would like to get the sale premium or see it embedded in the stock price. The problem is that if the sale doesn’t happen, the price usually goes back down (Portfolio 5D)
- Siemens (SIEGY) – the European conglomerate has held up better than GE in the face of the power meltdown (companies are not buying turbines as often anymore they are moving to solar and wind). They are likely to spin off their health care business in Europe. May be a time to sell (Portfolios 3, 5D)
Portfolio 3 is 9 1/2 years old. The trustee contributed $5000 and the trustee $10,000 for a total of $15,000. The current value is $17,483 for a gain of $2,483 or 16%, which is about 2.7% / year when adjusted for the timing of cash flows. You can see the detail at the links on the right or go here.
The portfolio is generally doing well. We will consider selling ConocoPhillips (COP) which has been selling off assets to pare down debt and reduced their dividend. Their stock has stabilized but this may not be the best oil play. We are also sticking with ExxonMobil (XOM) which we bought near a high because that company has proven to be well run over the last few decades.
In the new “analytics” tab you can see that this portfolio has a heavy non-US component, with 62% of stocks from non-US countries. We have 2 of the 3 major Chinese internet companies and also 2 large Canadian banks, among others.
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 eight is about 1 1/2 years old. The beneficiary contributed $1000 and the trustee $2000 for a total of $3000. The current value is $3130 for a gain of $130 or 4% which works out to a bit less than 3% / year adjusted for the timing of cash flows. There have been no sales and the portfolio is doing fine. You can see the detailed spreadsheet at the link on the right or download it here.
Portfolio seven is a year and a half old, with the beneficiary contributing $1000 and the trustee $2000 for a total of $3000. The current value is $3448 for a gain of $448 or 15%, which works out to about 10% / year. The portfolio is doing well. You can see the details of the portfolio at the links on the right or download the spreadsheet here. There have been no stock sales to date in this portfolio.
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.