Average Equity (Historical)
Returns the average shareholders' equity for a company over a specified reporting period. Average equity is commonly used in calculating return on equity (ROE) and other profitability metrics.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Period Parameters
| Parameter | Description | Examples |
|---|---|---|
| Year | Fiscal year or code | 2023, lq, ly |
| Quarter | Calendar quarter | 1, 2, 3, 4 |
| TTM | Trailing 12 months | TTM |
Special Year Codes
| Code | Meaning |
|---|---|
| lq | Last quarter |
| lq-1 | Two quarters ago |
| ly | Last year |
| ly-1 | Two years ago |
| lt | Last trailing twelve months |
Notes
- Average equity is calculated as (Beginning Equity + Ending Equity) / 2
- Values are in the company's reporting currency (usually USD)
- Useful for calculating ROE and other equity-based ratios
Examples
=hf_Average_Equity("AAPL", 2023)=hf_Average_Equity("MSFT", 2023, 2)=hf_Average_Equity("GOOGL", "ly")=hf_Average_Equity("AMZN", "lq", , "TTM")=hf_Average_Equity(A1, B1, C1)When to Use
- Calculating return on equity (ROE)
- Analyzing equity trends over time
- Comparing equity bases across companies
- Building financial models requiring average equity
- Computing equity-based valuation ratios
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current equity snapshot | Equity() |
| Need book value per share | hf_Book_Value_per_Share() |
| Need total assets | hf_Total_Assets() |
| Need retained earnings | hf_Retained_Earnings() |
Common Issues & FAQ
Q: Why am I getting "NA"? A: Check that:
- The symbol is a valid US stock ticker
- The year/quarter combination has available data
- The company was public during that period
Q: What currency is the value in? A: Values are in the company's reporting currency, typically USD for US companies.
Q: How is average equity calculated? A: It's calculated as (Beginning Equity + Ending Equity) / 2 for the period.
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?