Preferred Dividends Income Statement Impact (Historical)
Returns preferred stock dividends for a specific historical period.
Syntax
=hf_Preferred_Dividends_Income_Statement_Impact(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
Stock ticker symbol
yearstringRequired
Fiscal year or period code
quarterstring
Quarter (1-4)
TTMstring
Set to TTM for trailing twelve months
Returns
number
Preferred dividends in dollars
Examples
=hf_Preferred_Dividends_Income_Statement_Impact("BAC", "2023")When to Use
- Calculating income available to common shareholders
- Preferred stock analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need common dividends | hf_Dividends_per_Basic_Common_Share() |
Common Issues & FAQ
Why is this zero for most companies?
Most companies don't have preferred stock outstanding.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Preferred Equity Outside Stock Equity (Historical)
- Preferred Securities Of Subsidiary Trust (Historical)
- Preferred Shares (Historical)
- Preferred Stock Equity (Historical)
- Prepaid Expenses (Historical)
- Price Book Indicator (Historical)
- Price Cash Indicator (Historical)
- Price Free Cash Indicator (Historical)
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?