MarketXLS

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

Syntax

=ConsecutivePeriodOfIncreasingDividendPayout(Symbol, Periods)
Excel Desktop (Windows)

Parameters

symbolstringRequired
periodsstringRequired

Returns

boolean

TRUE if dividend has increased for specified consecutive periods, FALSE otherwise

Examples

=ConsecutivePeriodOfIncreasingDividendPayout("JNJ", 25)
Check for Dividend Aristocrat status
=ConsecutivePeriodOfIncreasingDividendPayout("KO", 10)
Check for Dividend Achiever status
=ConsecutivePeriodOfIncreasingDividendPayout("MSFT", 5)
Check 5-year dividend growth
=ConsecutivePeriodOfIncreasingDividendPayout("PG", 50)
Check 50-year growth streak
=ConsecutivePeriodOfIncreasingDividendPayout(A1, B1)
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

Scenario Use Instead
Check for uninterrupted payments ConsecutivePeriodOfUninterruptedDividendPayout()
Get current dividend amount DividendPerShare()
Get dividend yield DividendYield()
Get next dividend date Ex_DividendDate()

Common Issues & FAQ

What's the difference between increasing and uninterrupted?

Increasing = dividend amount grew each period. Uninterrupted = dividend was paid (even if flat or slightly lower).

What counts as an "increase"?

Any positive change in the annual dividend amount, even fractional increases count.

Does this check quarterly or annual increases?

Typically compares year-over-year annual dividend totals.

Excel Templates Using Consecutive Period of Increasing Dividend Payout

These ready-made MarketXLS templates call ConsecutivePeriodOfIncreasingDividendPayout() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Dividends formulas you can use in the same worksheet:

See ConsecutivePeriodOfIncreasingDividendPayout used in a complete workbook: Dividend Kings Screener Excel: 50+ Year Dividend Growth Champions Dashboard (June 2026)

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Consecutive Period of Increasing Dividend Payout and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions