Portfolio Eight Updated Feb 2018, and It’s Tax Time

Portfolio 8 is 3 1/2 years old.  The beneficiary contributed $1500 and the trustee $3000 for a total of $4500.  The current value of the portfolio is $5409 for a gain of $909 or 20%, which is 9.5% / year over the life of the portfolio adjusted for the timing of cash flows.  Go here for portfolio detail or use the link on the right.

We had 2 sales this year, Tata Motors (TTM) and Gilead (GILD).  Total long term gains from sales were $55 and dividends were $50.  The portfolio has done OK recently and bounced back from February market activity.

Portfolio Six Updated August 2017

Portfolio six is 5 years old.  The beneficiary contributed $2500 and the trustee $5000 for a total of $7500.  Current value is $8023 for a gain of $523 or 7%, which is 2% / year.  You can see the details at the link on the right or go here.

We have new analytics on these spreadsheets.  We also centrally track items like “yield” and the current description / status so we only need to updated it one time.

  1. Tata Motors (TTM) – Indian auto company which owns Range Rover.  Sell
  2. ConocoPhillips (COP) – US oil and gas producer hit hard by oil crisis, but up from lows with decent dividend.  Likely sell
  3. Exxon Mobil (XOM)  – large, well run integrated oil and gas company.  A political football.  May want to sell
  4. Gilead (GILD) – Drugmaker.  Keep for now, up from lows

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 Eight Updated April 2017

Portfolio eight is 2 1/2 years old.  The beneficiary contributed $1000 and the trustee $2000 for a total of $3000.  The current value is $3201 for a gain of $201 or 6%, which is 4% / year over the life of the fund.  Go here for a view of the stocks or use the links on the right.

The stocks are 1/2 US and 1/2 foreign and right now we are watching Gilead (GILD), one of the health care stocks that is potentially impacted by various health care proposals.

It’s Stock Picking Time for 2016!

Every year at the end of the summer we select stocks.  Here are the choices for 2016.

US Companies

Spirit Airlines (SAVE) – $40 (52 week high / low $53 / $33), $2.8B market cap, no dividend, $0.6B debt.  Spirit Airlines is a low cost airline that is challenging the oligopoly domestic carriers.

Gilead Sciences (GILD) – $77 (52 week high / low $113 / $77), $101B market cap, 2.4% dividend, $21B debt.  Gilead Sciences is a pharmaceutical company.

General Electric (GE) – $31 (52 week high / low $33 / $23), $281B market cap, 2.9% dividend, $145B debt.  General Electric is a conglomerate that has exited financial services.

International Companies

Unilever ADR UK (UL) – $48 (52 week high / low $38 / $48), $150B market cap, 2.9% dividend, $13B debt.  Unilever is a British consumer goods company with a strong global presence.  This is the ADR that pays out in British Pounds so that there is no tax withholding.

SAP ADR (SAP) – $89 (52 week high / low $62 / $89), $112B market cap, 1.5% dividend, $8B debt.  SAP is a German software company with a strong global presence.

Elbit Systems ADR (ESLT) – $97 (52 week high / low $72 / $103), $4B market cap, 1.6% dividend, $0.4B debt.  Elbit Systems is an Israeli defense contractor.