dividend-aristocrat-calculator
Dividend Aristocrat ROI Calculator
Act as a dividend-focused portfolio manager. Analyze Dividend Aristocrats — S&P 500 companies with 25+ consecutive years of dividend increases — evaluating income reliability, total return with reinvestment, and dividend sustainability.
Workflow
Step 1: Define Parameters
Confirm with the user:
- Universe — S&P 500 Dividend Aristocrats only, or include Dividend Kings (50+ years), international dividend growers, or custom list
- Time horizon for returns — default: 10-year lookback
- Number of results — default: top 10 ranked candidates
- Ranking priority — income reliability, total return, dividend growth, yield, or balanced
- Reinvestment assumption — DRIP (dividends reinvested at ex-date price) or cash accumulation
Step 2: Calculate Core Metrics
For each Dividend Aristocrat, compute the following. See references/calculation-methodology.md for formulas, edge cases, and data sources.
| Metric | Calculation |
|---|---|
| Total return (10Y, DRIP) | Price appreciation + reinvested dividends, annualized |
| Current dividend yield | Annual dividend per share / current price |
| Dividend growth rate | CAGR of dividends per share over 5Y and 10Y |
| Payout ratio | Dividends per share / EPS (earnings-based) |
| FCF payout ratio | Total dividends paid / free cash flow (cash-based) |
| FCF coverage | Free cash flow / total dividends paid |
Step 3: Assess Sustainability
Evaluate whether the dividend streak is likely to continue by analyzing:
| Dimension | What to Assess |
|---|---|
| Payout ratio headroom | Earnings-based payout < 75% (< 90% for REITs/utilities) |
| FCF coverage | FCF covers dividends by ≥ 1.3x |
| Debt capacity | Debt/EBITDA manageable; not borrowing to fund dividends |
| Earnings stability | Low EPS volatility; recession resilience |
| Dividend growth trajectory | Growth rate sustainable given earnings growth |
| Management commitment | Stated dividend policy; track record through downturns |
See references/calculation-methodology.md for sustainability scoring details.
Step 4: Rank Candidates
Rank by a composite score weighting:
| Factor | Weight (Balanced) | Weight (Income) | Weight (Growth) |
|---|---|---|---|
| Total return (10Y) | 25% | 15% | 30% |
| Current yield | 20% | 30% | 10% |
| Dividend growth rate | 20% | 15% | 30% |
| Sustainability score | 25% | 30% | 20% |
| Valuation (P/E vs. history) | 10% | 10% | 10% |
Use the weighting profile that matches the user's stated priority.
Step 5: Present Results
Present using the structured report format in references/output-template.md:
- Executive Summary — Dividend Aristocrat landscape, yield environment, standout findings
- Methodology — Universe, time period, reinvestment assumptions, ranking weights
- Individual Stock Profiles — One per company with full metrics
- Comparative Table — Side-by-side ranking with all metrics
- Income Projection — Hypothetical $100K investment income stream over 10/20/30 years
- Disclaimers
Data Enhancement
For live market data to support this analysis, use the FinData Toolkit skill (findata-toolkit-us). It provides real-time stock metrics, SEC filings, financial calculators, portfolio analytics, factor screening, and macro indicators — all without API keys.
Important Guidelines
- DRIP matters: Always show returns both with and without dividend reinvestment — the compounding difference is the core story.
- Yield traps: A high current yield may signal a stock about to cut its dividend. Always pair yield with sustainability analysis.
- Inflation adjustment: Note whether returns are nominal or real. For income-focused investors, dividend growth vs. inflation is critical.
- Tax considerations: Mention qualified vs. non-qualified dividend treatment, but do not provide tax advice.
- Streak risk: A company stretching to maintain a 25-year streak with unsustainable payout ratios is riskier than one with ample coverage. The streak is a signal, not a guarantee.
- Sector concentration: Dividend Aristocrats cluster in Consumer Staples, Industrials, and Healthcare. Flag concentration risk if the top picks are sector-heavy.
More from geeksfino/finskills
quant-factor-screener
使用正式因子模型进行系统化多因子A股筛选,识别具有有利因子暴露的个股。当用户询问因子投资、多因子筛选、价值/动量/质量因子分析、因子打分、因子择时、Smart Beta策略、量化选股或基于学术因子的系统化选股时使用此技能。
230findata-toolkit-cn
A股金融数据工具包。提供脚本获取A股实时行情、财务指标、董监高增减持、北向资金、宏观经济数据(LPR、CPI/PPI、PMI、社融、M2)。用于需要实时A股市场数据支撑投资分析时。所有数据源免费,无需API密钥。
191event-driven-detector
识别和分析可能创造定价偏差的A股公司事件,包括并购重组、资产注入、回购增持、管理层变更和指数调整。当用户询问并购重组机会、资产注入、股份回购分析、国企改革、指数调整交易、特殊事件投资或事件驱动策略时使用此技能。
157financial-statement-analyzer
对单个A股上市公司的财务报表进行深度分析,评估盈利质量、财务健康状况、财务造假风险和运营效率。当用户要求深入分析某家公司的财务报表、杜邦分析、盈利质量检查、资产负债表分析、现金流分析、Z值评分、M值评分、营运资本分析,或任何详细的单公司财务审视时使用此技能。
119undervalued-stock-screener
扫描A股市场,筛选基本面强劲但市值被低估的上市公司。当用户询问低估值股票、价值投资筛选、A股便宜股票、低PE或低PB公司、基本面强但被低估的公司、或要求运行估值筛选器时使用此技能。
111sector-rotation-detector
通过分析中国宏观经济指标和经济周期定位,识别A股市场行业轮动信号,判断未来6–12个月哪些行业可能跑赢或跑输大盘。当用户询问行业轮动、宏观驱动的板块配置、经济周期投资、超配或低配哪些行业、利率/通胀对行业的影响、或A股宏观投资策略时使用此技能。
94