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

Overall Possible Sales for August, 2017

We are looking at the portfolios prior to the summer 2017 stock investing.  We are mainly evaluating stocks that have fallen relative to their 2017 52 week high prices.  We are also considering some whose narrative have changed (usually the same stocks).  This is easier now that I have a central consolidated view of stocks and some standard analytics through Google Sheets that use automatic formatting as well.

Portfolio One:

• We did some recent selling here so we are OK

Portfolio Two:

• We moved this portfolio to ETF’s.  The Biotech ETF (IBB) is doing OK now

Portfolio Three:

• ConocoPhillips (COP) – integrated oil and gas producer hit by commodity prices.  Possible sale
• ExxonMobil (XOM) – well run massive integrated oil and gas major also hit by commodity prices and political items.  Less likely sale

Portfolio Four (M):

• Devon Energy (DVN) – smaller oil and gas company hit hard by commodity prices.  Likely sale
• Spirit Airlines (SAVE) – discount airlines facing more competition.  Possible sale
• Nucor (NUE) – US metals producer facing heavy competition from China.  Possible sale

Portfolio Five (D):

• Tata Motors (TTM) – Indian truck maker that owns Jaguar / Land Rover.  Down significantly.  Likely sale
• Spirit Airlines (SAVE) – discount airlines facing more competition.  Possible sale
• ConocoPhillips (COP) – integrated oil and gas producer hit by commodity prices.  Possible sale

Portfolio Six

• Tata Motors (TTM) – Indian truck maker that owns Jaguar / Land Rover.  Down significantly.  Likely sale
•  ConocoPhillips (COP) – integrated oil and gas producer hit by commodity prices.  Possible sale
• ExxonMobil (XOM) – well run massive integrated oil and gas major also hit by commodity prices and political items.  Less likely sale

 Portfolio Seven G:

• Spirit Airlines (SAVE) – discount airlines facing more competition.  Possible sale

Portfolio Eight K:

• Tata Motors (TTM) – Indian truck maker that owns Jaguar / Land Rover.  Down significantly.  Likely sale

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

Portfolio 4 is 8 years old.  The trustee contributed $8000 and the beneficiary $4000 for a total of $12,000.  The current value is $14,957 for a gain of $2,957 or 25% which is about 5% / year adjusted for the timing of cash flows.  Go here or to the link on the right for more details.

We need to make some decisions on stocks prior to investing:

• Devon (DVN) – energy company hit hard by the decline in oil and gas prices.  Likely sell
• Spirit Airlines (SAVE) – discount airlines down recently due to increased competition from major airlines.  May sell
• Nucor (NUE) – metals company under continuous pressure from cheaper overseas imports.  May 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 Seven Updated August 2017

Portfolio Seven is 2 years old.  The trustee invested $2000 and the beneficiary $1000 for a total of $3000.  The current value is $4209 for a gain of $1209 or 40%, which is 24% / year adjusted for the timing of cash flows.  You can see the detail here or in the link to the right.

When you have a portfolio with only 4 stocks like this one, an increase in a single stock can impact your performance (positively or negatively).  In this case Alibaba (BABA) the Chinese e-commerce giant has done very well which has accounted for 2/3 of the total growth in portfolio value.

We have one stock “on watch” which is Spirit Airlines (SAVE).  The stock is down about 40% from its high price.  We are considering selling this or holding on as it competes with other airlines.

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