MarketXLS

Dividends Per Basic Common Share (Historical)

Returns the historical dividends paid per basic common share during a fiscal period. This helps track dividend growth and consistency over time.

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol (e.g., AAPL, MSFT)
Year Yes Fiscal year (2023) or period code (lq, ly)
Quarter No Quarter number 1-4 (default: 1)
TTM No Set to "TTM" for trailing twelve months

Period Codes

Code Description
lq Last reported quarter
lq-1 One quarter ago
ly Last fiscal year
ly-1 Previous fiscal year
lt Last twelve months (TTM)

Notes

  • Represents cash dividends paid during the period
  • Based on basic (undiluted) share count
  • May include regular and special dividends
  • Zero for companies that don't pay dividends

Syntax

=hf_Dividends_per_Basic_Common_Share(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Examples

=hf_Dividends_per_Basic_Common_Share("AAPL", 2023, 4)
Q4 2023 quarterly dividend
=hf_Dividends_per_Basic_Common_Share("MSFT", "ly")
Last fiscal year total
=hf_Dividends_per_Basic_Common_Share("JNJ", 2023, , "TTM")
Trailing 12 months
=hf_Dividends_per_Basic_Common_Share(A1, B1, C1)
From cell references
=hf_Dividends_per_Basic_Common_Share("KO", "ly-1")
Previous fiscal year

When to Use

  • Analyzing dividend growth rates
  • Building dividend income projections
  • Calculating historical payout ratios
  • Identifying dividend aristocrats
  • Income portfolio analysis

When NOT to Use

Scenario Use Instead
Need current dividend rate DividendPerShare()
Need dividend yield DividendYield()
Need forward annual dividend ForwardAnnualDividendRate()
Need total dividends paid hf_Payment_of_Dividends_and_Other_Cash_Distributions()

Common Issues & FAQ

Why is the value zero?

The company either doesn't pay dividends or didn't pay during that specific period. Many growth companies don't pay dividends.

How do I calculate dividend growth rate?

Compare across years: =(hf_Dividends_per_Basic_Common_Share("AAPL","ly") / hf_Dividends_per_Basic_Common_Share("AAPL","ly-1")) - 1

Is this quarterly or annual dividends?

Depends on parameters. With quarter specified, it's that quarter's dividend. Without quarter (or with TTM), it's the full period.

Excel Templates Using Dividends Per Basic Common Share (Historical)

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

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 Dividends Per Basic Common Share (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions