Portfolio Five Updated July, 2017

Portfolio Five is almost 5 years old.  The beneficiary contributed $4000 and the trustee $8000, for a total of $12,000.  The current value is $14,522, for a gain of $2522 or 21%, which is about 4.3% / year when adjusted for the timing of cash flows.  Go here for details or see the link on the right of the page.

We are looking at several stocks.  ConocoPhillips (COP) has been hit hard by the decline in oil prices, but has kept a modest dividend.  Spirit Airlines (SAVE) has been a great stock but has come down recently.  Tata Motors (TTM) provides some diversity in terms of currency and emerging markets but is down about 20% from highs.  Juniper Networks (JNPR) has been doing well but long term they face risks from Amazon (AMZN) and the cloud.

 

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 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.