Preferred Stock Equity (Historical)
Returns preferred stock equity from historical balance sheets.
Syntax
=hf_Preferred_stock_equity(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
yearstringRequired
quarterstring
TTMstring
Returns
number
Preferred stock equity amount
Examples
=hf_Preferred_stock_equity("WFC", 2023, 4)When to Use
- Capital structure analysis
- Dividend analysis for preferreds
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need common equity | hf_Common_stock_equity() |
Common Issues & FAQ
What's the difference from common equity?
Preferred stock has priority over common in dividends and liquidation.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Prepaid Expenses (Historical)
- Price Book Indicator (Historical)
- Price Cash Indicator (Historical)
- Price Free Cash Indicator (Historical)
- Price Indicator (Historical)
- Price Sales Indicator (Historical)
- Price To Book Value (PB Ratio -Historical)
- Price To Earnings Ratio (PE Ratio - Historical)
See hf_Preferred_stock_equity used in a complete workbook: Preferred Stock Symbols: How to Find, Analyze, and Track Preferred Shares in Excel
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?