MarketXLS

Payment Of Dividends And Other Cash Distributions (Historical)

Returns the total cash spent on dividend payments and other distributions to shareholders during the fiscal period. This is reported in the financing section of the cash flow statement.

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

Included Items

Item Description
Common Dividends Regular dividends to common shareholders
Preferred Dividends Dividends to preferred shareholders
Special Dividends One-time special distributions
Other Distributions Partner distributions, REIT distributions

Notes

  • Usually reported as negative (cash outflow)
  • Total cash paid, not per-share amount
  • For per-share dividend, use hf_Dividends_per_Basic_Common_Share()
  • Zero for non-dividend paying companies

Syntax

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

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code (e.g., 2023, lq, ly)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Total dividend and distribution payments (typically negative)

Examples

=hf_Payment_of_Dividends_and_Other_Cash_Distributions("AAPL", 2023, 4)
Q4 2023 dividends
=hf_Payment_of_Dividends_and_Other_Cash_Distributions("MSFT", "ly")
Last fiscal year
=hf_Payment_of_Dividends_and_Other_Cash_Distributions("JNJ", 2023, , "TTM")
Trailing 12 months
=hf_Payment_of_Dividends_and_Other_Cash_Distributions(A1, B1, C1)
From cell references

When to Use

  • Calculating total shareholder returns
  • Dividend sustainability analysis
  • Cash flow coverage ratios
  • Comparing dividends to free cash flow
  • Income stock analysis

When NOT to Use

Scenario Use Instead
Need per-share dividend hf_Dividends_per_Basic_Common_Share()
Need dividend yield DividendYield()
Need forward dividend rate ForwardAnnualDividendRate()
Need buyback activity hf_Issuance_Purchase_of_Equity_Shares()

Common Issues & FAQ

How do I calculate dividend coverage?

Coverage = Free Cash Flow / Dividends: =ABS(hf_Net_Cash_Flow_from_Operations("AAPL","ly") + hf_Capital_Expenditure("AAPL","ly")) / ABS(hf_Payment_of_Dividends_and_Other_Cash_Distributions("AAPL","ly"))

Why is this different from DividendPerShare x Shares?

This is actual cash paid. Per-share calculations may differ due to timing, weighted average shares, and preferred dividends.

What about special dividends?

Special dividends are included in this total. For consistent year-over-year comparison, check for unusual spikes.

Excel Templates Using Payment Of Dividends And Other Cash Distributions (Historical)

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

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

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 Payment Of Dividends And Other Cash Distributions (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions