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

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

Q: How do I calculate dividend coverage? A: 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"))

Q: Why is this different from DividendPerShare x Shares? A: This is actual cash paid. Per-share calculations may differ due to timing, weighted average shares, and preferred dividends.

Q: What about special dividends? A: Special dividends are included in this total. For consistent year-over-year comparison, check for unusual spikes.

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