Sales for September, 2017

We are about to re-invest for the 2017 stock season.  Would like to clear out some of the stocks we no longer want to hold.

Portfolios One, Two and Three – no sales (we made some recent sales in Portfolio One).

Portfolio Four (M):

  • Sell Devon (DVN) – hit hard by recent down turn in oil prices
  • Sell Spirit Airlines (SAVE) – in a price war with much larger competitors

Portfolio Five (D):

  • Sell Spirit Airlines (SAVE) – in a price war with much larger competitors
  • Sell Tata Motors (TTM) – value driven mostly from non-India components (Jaguar and Land Rover)

Portfolio Six:

  • Sell Tata Motors (TTM) – value driven mostly from non-India components (Jaguar and Land Rover)

Portfolio Seven (G):

  • Sell Spirit Airlines (SAVE) – in a price war with much larger competitors

Portfolio Eight (K):

  • Sell Tata Motors (TTM) – value driven mostly from non-India components (Jaguar and Land Rover)

 

Advertisements

Portfolio Five Updated August 2017

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

Portfolio Eight is 2 years old.  The trustee contributed $2000 and the beneficiary $1000 for a total of $3000.  The current value is $3411 for a gain of $411 or 13%, which is 8% / year.  See the details here or use the link on the right.

Tata Motors (TTM), the Indian truck maker who also owns Jaguar / Land Rover, is on watch.  We are considering selling this stock which has fallen over the last year.

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 One Re-updated August, 2017

Portfolio One was re-updated as of August 2017 to reflect three sales.  You can see the details here or click on the link on the right.

The portfolio recently sold three stocks (BOX, TTM and KO) and has $6349 in cash.  There is another analytics worksheet which is also linked to the underlying central spreadsheet (calculated).

Portfolio One Updated August 2017

Portfolio One is our longest lived Portfolio.  We opened it right after 9/11… meaning that it is almost 16 years old.  This portfolio has moved from the trustee to the beneficiary’s account, but we also still set it up so that the trustee has agency (can see the portfolio, buy and sell).

The beneficiary contributed $7500 and the trustee $15,500 for a total of $23,000.  The current value of the portfolio is $44,883 for a gain of $21,883 or 95%, or 7% / year adjusted for the timing of cash flows.  Go here or to the link on the right for details.

The portfolio is doing well.  We added some criteria and filtering for stocks “at risk” (BOX, Budweiser Inbev and Exxon) or “on watch” (Tata Motors / TTM).  BOX has doubled recently and is down a bit; BUD just finished a major merger but Exxon is near 5 year lows and a bit controversial due to politics.  Tata (TTM) is one we will look at closely.

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.