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
Syntax
=hf_Average_Equity(Symbol, Year, [Quarter], [TTM])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
Why am I getting "NA"?
Check that:
- The symbol is a valid US stock ticker
- The year/quarter combination has available data
- The company was public during that period
What currency is the value in?
Values are in the company's reporting currency, typically USD for US companies.
How is average equity calculated?
It's calculated as (Beginning Equity + Ending Equity) / 2 for the period.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Basic EPS Accounting Change (Historical)
- Basic EPS Continuing Operations (Historical)
- Basic EPS Discontinued Operations (Historical)
- Basic EPS Extraordinary Items (Historical)
- Basic EPS Other Gains/Losses (Historical)
- Basic EPS Preferred Securities (Historical)
- Basic EPS Tax Loss Carryforward (Historical)
- Basic EPS Total (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?