My Dividend Spreadsheet: Making Analyzing Dividend Stocks Simpler

by | Z- Uncategorized

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

Discover, Compare, and Evaluate Dividend Stocks Without Emotional Bias

(DVB Full & Premium Memberships)

Disclaimer
While Arbor Investment Planner has used reasonable efforts to obtain information from reliable sources, we make no representations or warranties as to the accuracy, reliability, or completeness of third-party information presented herein. The sole purpose of this analysis is information. Nothing presented herein is, or is intended to constitute investment advice. Consult your financial advisor before making investment decisions.

Shares
Share This