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

Examples

=hf_Cash_as_a_percentage_of_revenue("AAPL", 2023, 4)

Q4 2023 cash/revenue %

=hf_Cash_as_a_percentage_of_revenue("MSFT", 2022, , "TTM")

2022 TTM cash/revenue %

=hf_Cash_as_a_percentage_of_revenue("GOOGL", "ly")

Last year cash/revenue %

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

Q: Why is this percentage high for tech companies? A: Tech companies often hold more cash relative to revenue due to lower capital expenditure needs.

Q: What is a good ratio? A: Varies by industry; compare to sector peers for meaningful analysis.

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 Cash As A Percentage Of Revenue (Historical) and Other Financial Formulas

▶

How does MarketXLS work?