Dividend Per Share 5 Year CAGR
Returns the five-year Compound Annual Growth Rate (CAGR) of dividend per share for a company. This metric is essential for dividend growth investors.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT, JNJ |
Formula
CAGR = (Ending DPS / Beginning DPS)^(1/5) - 1
Dividend Growth Classifications
| CAGR Level | Classification |
|---|---|
| > 10% | High dividend growth |
| 5-10% | Moderate growth |
| 2-5% | Slow growth |
| < 2% | Stagnant |
Notes
- Returns value as a decimal (0.08 = 8%)
- Non-dividend-paying stocks will show N/A
- Dividend Aristocrats typically have 5%+ CAGR
Examples
=DividendPerShareFiveYearCAGR("AAPL")=DividendPerShareFiveYearCAGR("MSFT")=DividendPerShareFiveYearCAGR("JNJ")Symbol from cell reference
=DividendPerShareFiveYearCAGR("KO")*100When to Use
- Dividend growth investing analysis
- Identify consistent dividend growers
- Screen for Dividend Aristocrats/Kings
- Income portfolio building
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Current dividend amount | DividendPerShare() |
| Dividend yield | DividendYield() |
| One-year dividend growth | DividendOneYearGrowth() |
| Ex-dividend date | Ex_DividendDate() |
Common Issues & FAQ
Q: Why am I getting N/A? A: The company may not pay dividends, or may not have a 5-year dividend history. Growth stocks often don't pay dividends.
Q: Why is the value less than 1? A: CAGR is returned as a decimal. Multiply by 100 to get percentage (e.g., 0.08 = 8% annual growth).
Q: What is a Dividend Aristocrat? A: A company that has increased dividends for 25+ consecutive years. They typically have consistent dividend CAGR above inflation.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?