Consecutive Period of Increasing Dividend Payout
Determines whether a company has increased its dividend payout for a specified number of consecutive periods (typically years). This is a key metric for identifying dividend growth stocks.
Understanding Dividend Growth
- Dividend Aristocrats: 25+ years of consecutive increases
- Dividend Achievers: 10+ years of consecutive increases
- Dividend growth indicates financial stability and shareholder commitment
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Periods | Yes | Number of consecutive periods to verify |
Notes
- Returns TRUE if dividend increased each period
- Returns FALSE if any period had flat or decreased dividend
- Useful for screening dividend growth stocks
- Period typically represents years
Examples
=ConsecutivePeriodOfIncreasingDividendPayout("JNJ", 25)=ConsecutivePeriodOfIncreasingDividendPayout("KO", 10)=ConsecutivePeriodOfIncreasingDividendPayout("MSFT", 5)=ConsecutivePeriodOfIncreasingDividendPayout("PG", 50)Parameters from cells
When to Use
- Screening for dividend growth stocks
- Identifying Dividend Aristocrats (25+ years)
- Identifying Dividend Achievers (10+ years)
- Building income-focused portfolios
- Evaluating dividend sustainability
When NOT to Use
Common Issues & FAQ
Q: What's the difference between increasing and uninterrupted? A: Increasing = dividend amount grew each period. Uninterrupted = dividend was paid (even if flat or slightly lower).
Q: What counts as an "increase"? A: Any positive change in the annual dividend amount, even fractional increases count.
Q: Does this check quarterly or annual increases? A: Typically compares year-over-year annual dividend totals.
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?