My Dividend Spreadsheet: Making Analyzing Dividend Stocks Simpler
Imagine having a dividend spreadsheet, a comprehensive sortable excel spreadsheet, that cuts your research time by 80%!!!
My Dividend Spreadsheet provides important metrics pertaining to dividends, earnings, growth, valuation, earnings quality, and dividend safety. The very most important metrics are assigned points that produce my Dividend Analyzer valuation, earnings quality, and dividend safety scores.
These three scores make up the Dividend Analyzer total score and are placed prominently in My Dividend Spreadsheet. This format allows easy analysis of over 500 dividend paying stocks; first in analyzing the individual scores and then the individual metrics which provide a greater in-depth view of each company.
You can find a detailed description of the Dividend Analyzer here: Selecting Dividend Stocks With The Dividend Analyzer.
The Dividend Value Builder employs a quantitative approach to discovering, comparing, and evaluating stocks without emotional bias. My Dividend Spreadsheet provides 8 informational cells plus 50+ different quantitative and qualitative metrics; all sortable for over 500 dividend stocks.
These sortable columns are included in My Dividend Spreadsheet:
Symbol
Company Name
Sector
Industry
Dividend Analyzer TOTAL SCORE (0-100 points)
Dividend Analyzer VALUATION SCORE (0-34 points)
Dividend Analyzer EARNINGS QUALITY SCORE (0-33 points)
Dividend Analyzer DIVIDEND SAFETY SCORE (0-33 points)
Ken’s Notes
Dividend Champions
Dividend Aristocrats
Dividend Kings
Price
Dividend Yield (Forward)
Dividend
Dividend Per Share (Annual YoY Growth)
Dividend Per Share (3 Year Growth)
Dividend Per Share (5 Year Growth)
Dividend Per Share (10 Year Growth)
EPS Diluted (TTM)
Normalized Diluted EPS (TTM)
Normalized Diluted EPS (Annual YoY Growth)
Normalized Diluted EPS (3 Year Growth)
Normalized Diluted EPS (5 Year Growth)
Normalized Diluted EPS (10 Year Growth)
CFO Per Share (TTM)
Free Cash Flow Per Share (TTM)
VALUATION SCORE
Free Cash Flow Yield (TTM) (0-17 points)
EV to CFO (TTM)
EV to EBIT (TTM)
EV to EBITDA (TTM) (0/17 points)
Price / Sales Ratio (TTM)
Price to Book Value
P/E Ratio (TTM)
PE10
EARNINGS QUALITY SCORE
Enterprise Value
Operating Income (TTM)
Enterprise Value / Operating Income (TTM)(a.k.a Acquirer’s Multiple): (0-10 points)
Gross Profit (TTM)
Total Assets (Quarterly)
Gross Profitability Ratio (GP / Total Assets) (0-14 points)
Gross Profitability Score (0-14 points)
Cash Return on Capital Invested (CROCI) (TTM)
Return on Invested Capital (TTM)
Profit Margin (TTM)
Piotroski F-Score (TTM) (0-9 points)
DIVIDEND SAFETY SCORE
Net Financial Debt (Quarterly)
Market Capitalization
Net Financial Debt / Market Capitalization (0-18 points)
Financial Debt to EBITDA (TTM)
Payout Ratio (TTM)
Cash Dividend Payout Ratio (TTM) (0-15 points)
Current Ratio (Quarterly)
TOTAL DIVIDEND ANALYZER SCORE
(My Dividend Spreadsheet is included in DVB Full & Premium Memberships.)
Related Reading: Selecting Dividend Stocks With The Dividend Analyzer
Dividend Value Builder Newsletter
(DVB Full & Premium Memberships)