Portfolio Five Updated April 2017

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 Five Updated January 2017 – Tax Time

Portfolio five 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 $14,071 for a gain of $2071 or 17%, which is 3.5% / year when adjusted for the timing of cash flows.  The spreadsheet can be found on the link to the right or you can download it here.

During 2016 we had about $223 in dividends for an average yield of about 1.6%.  There was a capital loss of $134 on the sale of LinkedIn (which was bought by Microsoft).  The portfolio is doing well, with Spirit Airlines (SAVE) being a recent winner.  Our sales also seem OK in hindsight.

Portfolio Five Updated October, 2016

Portfolio Five has a value of $13,656. The beneficiary contributed $4000 and the trustee $8000 for a total of $12,000.

portfolio_5_oct_2016

Portfolio Five Updated March 2016 – Tax Time

Portfolios four and five are 6 1/2 years old.  The beneficiary contributed $3500 and the trustee $7000 for a total of $10,500.  The current value is $10,435 for a loss of ($65) or (0.6%) or basically flat performance when adjusted for the timing of cash flows.  The spreadsheet detail can be found here or in the links on the right.

We sold Seaspan (SSW), Yahoo (YHOO) and Sasol (SSL) this year while buying Union Pacific (UNP), Tata Motors ADR (TTM) and ConocoPhillips (COP).  Right now ConocoPhillips (COP) is on watch after cutting their dividend 75%, and LinkedIn was hit hard during their recent earnings guidance, also putting the stock on watch.

We had some gains and losses this year the brokerage account makes it easy to calculate taxes since it includes the original cost basis as well as the sales information.

Portfolio Five After 2015 Purchases and Sales

Screen Shot 2015-11-21 at 9.43.53 AM

Attached is an updated view of Portfolio Five after 2015 purchases and sales.  New stocks include ConocoPhillips (COP), Tata Motors (TTM), and Union Pacific Corporation (UNP).  Returns only include stock price rises and decreases not dividends (so dividend paying stocks are understated).

Portfolio Five Updated October 2015

Portfolio five is six years old.  The beneficiary contributed $3500 and the trustee has contributed $7000 for a total of $10,500.  The current value is $11,297 for a gain of $797 or 7.6%, which is 1.8% / year.  The details can be found here or you can use the links on the right.

Portfolio five has a couple of stocks on watch.  Yahoo (YHOO) has most of its value tied to the Chinese company Alibaba (BABA).  Seaspan (SSW) has a very high dividend at 9% and is on watch to see if that is sustainable.

Portfolio Five Updated March 2015 – And It’s Tax Time

Portfolio’s Four and Five are both 5 1/2 years old. The beneficiary contributed $3000, the trustee $6000 for a total of $9000. The value is $10,840 for a gain of $1840 or 20%, which works out to about 5.3% / year. You can see the details here or go to the link on the right.

We earned $260 in dividends in 2014, or a yield of approximately 2.6%. During 2014 we sold two stocks – Yandex (the Russian search engine) and China Petroleum. Yandex crashed much further after we sold it and China Petroleum is about the same.

In 2015 we sold Sasol (SSL) during the oil price crash – it is about where we sold the stock at ($35). We have over $1000 to invest so we will buy an additional stock in the spring.

The stocks are mostly doing well – we will keep an eye on Seaspan (SSW) the shipping company with the high dividend (over 7%).