Click Pic for a better view
Company Name - This one is obvious. This is pulled from Google Finance via google sheets formula.
Sector - What area of the economy the stock is primarily in. There is some discrepancy (i.e. MasterCard is a tech stock, not a bank stock), but I follow David Fish's (RIP) original sector listings. I try to have two companies in each sector, with the exceptions being:
T-Com (AT&T) - There just aren't enough choices available for dividend investors at the moment.
Utilities - They are slow but solid growth stocks.
Health Care - Everyone needs it.
Consumer Staples - These are recession proof. They should be the largest holding, so if overweight in some other sector (check pie graph at bottom of page) then add more to staples.
Subsector - Not too important, just nice to see the variety.
Wt % - Weight of each stock in my portfolio. If it goes over 5%, it will go orange, and I cannot buy this unless there is the deal of the century and it is a sure thing. The way to make this go down is to buy more of the non-orangestocks, or add new stocks to the portfolio. I colored the ones under 2.5% yellow to see where I need to accumulate more.
Ticker - This is the stock ticker, the whole portfolio is based on this column to retrieve data from Google Finance. This should not be edited.
Shr - How many shares I own of this stock.
Cost Basis - This is how much money I have spent on this stock + trader's fees. This needs to be updated manually, adding how much was spent to the running total.
PPS - Price Per Share. This is calculated from the Cost Basis.
Price - Current price of the stock. Purplish colors mean I am underwater. Green/Gold means above/way above water respectively. I dream of a day when there are no purples and I have to choose between clear and light green for purchases.
MV - What the market value of my shares are worth if they were sold today.
Profit - Green means a profit if we sell, Red means a loss if we sell. We try not to sell :)
Div/Shr - This is how much money we get per share each time the company pays out dividends, whether quarterly or monthly. I usually set it so it will turn green when it increases, then I clear it when I buy some. This is entered manually.
Yield - This one is important. If the yield of a stock is greater than the yield was when I bought it (floor of 4%), it will be green. If the yield has gone down (because price has gone up, ceiling of 3%) it will be red. I try to only buy this if it is green to increase my purchase yield (YOC Yield on Cost).
FRQ - How often this stock pays out each year.
Div Est - Estimated dividends to be paid out each year.
YOC - Yield on Cost. This is how much the stock returns to me as dividends based on when I bought it. The higher this number, the better, but the only way to increase it is to buy stocks that are green in the Yield column.
Now come the indicators to help me buy a stock. It would behoove you to read up on these.
Beta - This is how volatile a stock is, and I tend to avoid anything that is dark red when buying, but I have ignored it if all other indicators look good.
P/E - Price to earnings ratio. This is very subjective to the sector and peers, but typically anything under 20 is a good deal for a stock (green).
PR - Payout ratio. How much of a company's profits are returned to us, the shareholders, in the form of dividends. Typically you want this below 70, but if it is over 100, look out for a dividend freeze or cut! REITs are calculated from AFFO
EC - Equity Cost. This is a new addition. I basically take when I paid for the stock, subtract the current profit if I sold today (in some cases, subtracting a negative number), and then subtract the dividends received thus far. If it is green, then the stock is paying for itself, if it is red, it hasn't yet. If this is 0 or a negative number, then my stock has completely paid for itself. But I doubt this will ever happen as long as I'm still buying it.
DivIncr - I added this 5/31/19 to tell me when to look for the next dividend increase.
DivGrowth - I added this 5/31/19 to tell me the rate the dividend has increased over the past 5 years. Helps me to spot the heavy div growers, which are more attractive.
I'm having fun adding to and adjusting my spreadsheets every couple of weeks. Helps me get a bigger picture and feel the heartbeat of my portfolio.
I have been messing around with Google Docs and was able to make a Tree Map of my holdings. I'm not sure how helpful it is, but it does let me know from a glance which stocks I am overweight/underweight in:
No comments:
Post a Comment