Revenue Per Dollar Cash (Historical)
Returns how much revenue is generated for each dollar of cash held. Higher values indicate more efficient cash utilization.
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_cash(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 cash
Examples
=hf_Revenue_per_dollar_cash("AAPL", 2023, 4)=hf_Revenue_per_dollar_cash("MSFT", 2022, , "TTM")When to Use
- Analyzing cash efficiency
- Comparing cash utilization across companies
- Understanding how productively cash is deployed
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need cash as % of revenue | hf_Cash_as_a_percentage_of_revenue() |
| Need revenue per equity | hf_Revenue_per_dollar_common_equity() |
Common Issues & FAQ
Higher or lower is better?
Higher values indicate more revenue generated per cash dollar, but optimal levels depend on industry.
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?