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

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

Q: Why is this high for leveraged companies? A: Companies with more debt have less equity, so revenue per equity dollar is higher.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Revenue Per Dollar Common Equity (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions