Portfolio five is 8 years old. The trustee contributed $8000 and the beneficiary $4000 for a total of $12,000. The current value is $14,184 for a gain of $2,184 or 18%, which works out to 4% / year. See detail here or go to a link on the right.
We are evaluating stocks to sell prior to our summer purchases.
- Tata (TTM) – Indian automaker who is down significantly. Likely sell
- Spirit Airlines (SAVE) – US discount airlines that is facing more competition and headwinds. Possible sell
- ConocoPhillips (COP) – integrated oil and gas company hit by falling commodity prices. Possible sell
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 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 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 has a value of $13,656. The beneficiary contributed $4000 and the trustee $8000 for a total of $12,000.
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.
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).