Cash As A Percentage Of Revenue (Historical)
Returns the ratio of cash and cash equivalents to total revenue, expressed as a percentage. This metric shows how much cash a company holds relative to its sales.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year (2020, 2021, etc.) or period code (lq, ly) |
| Quarter | No | Calendar quarter 1-4 (default: 1) |
| TTM | No | Enter "TTM" for trailing twelve months |
Syntax
=hf_Cash_as_a_percentage_of_revenue(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
Cash as percentage of revenue
Examples
=hf_Cash_as_a_percentage_of_revenue("AAPL", 2023, 4)=hf_Cash_as_a_percentage_of_revenue("MSFT", 2022, , "TTM")=hf_Cash_as_a_percentage_of_revenue("GOOGL", "ly")When to Use
- Analyzing cash position relative to sales
- Comparing liquidity across companies
- Assessing cash efficiency
- Financial health assessment
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need cash per share | hf_Cash_per_share() |
| Need receivables to revenue | hf_Receivables_as_a_percentage_of_revenue() |
| Need absolute cash value | hf_Cash_and_equivalents() |
Common Issues & FAQ
Why is this percentage high for tech companies?
Tech companies often hold more cash relative to revenue due to lower capital expenditure needs.
What is a good ratio?
Varies by industry; compare to sector peers for meaningful analysis.
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?