u/xghtai737

MSFT: Formerly A High Yield Value Stock. History Won't Repeat. It Is Not In The Same Starting Position.

u/xghtai737 — 2 months ago

Dividend CCC Mid-Month Update, With Additional Data

I made a mid-month update to the Dividend CCC list.

https://docs.google.com/spreadsheets/d/1Xg5XijEpPR83dSsrRNS37MzGpWcNPDpCVZtcacX2gxU/edit?gid=0#gid=0

I usually add a lot of additional data to the version created by Justin Law. In this version I added:

Forward PE

P/Cash

P/Free Cash Flow

EV/EBITDA

ROIC

Current Ratio

Quick Ratio

Gross Margins

Operating Margins

Profit Margins

Enterprise Value

Analyst Price Target

% from Analyst Price Target

Shares Outstanding

1, 3, and 5 year change in the diluted share count

And I included my version of the 5 year dividend payback estimate, which, unlike Justin Law's version, my version gives haircuts if the payout ratio is too high, growth estimates are expected to decline, or growth estimates are not available. And it tolerates higher dividend growth estimates than the one by Justin Law, if it is supported by earnings growth estimates. Justin Law's version caps it at 10% while I allow it up to 17.5%.

u/xghtai737 — 2 months ago