Revenue Per Dollar Common Equity (Historical)
Returns how much revenue is generated for each dollar of shareholders' equity. Higher values indicate more efficient use of equity capital.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year or period code |
| Quarter | No | Calendar quarter 1-4 (default: 1) |
| TTM | No | Enter "TTM" for trailing twelve months |
Syntax
=hf_Revenue_per_dollar_common_equity(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
Stock ticker symbol
yearstringRequired
Fiscal year or period code
quarterstring
Calendar quarter (1-4)
TTMstring
Use TTM for trailing twelve months
Returns
number
Revenue generated per dollar of common equity
Examples
=hf_Revenue_per_dollar_common_equity("AAPL", 2023, 4)=hf_Revenue_per_dollar_common_equity("MSFT", 2022, , "TTM")When to Use
- Analyzing equity efficiency
- Comparing capital utilization
- Understanding leverage effects on revenue
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need revenue per invested capital | hf_Revenue_per_dollar_invested_capital() |
| Need ROE | hf_Normalized_return_on_stock_equity() |
Common Issues & FAQ
Why is this high for leveraged companies?
Companies with more debt have less equity, so revenue per equity dollar is higher.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
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?