Quick Ratio (Historical)

Returns the quick ratio (also known as acid-test ratio) for a company. This measures the ability to pay short-term obligations with liquid assets (excluding inventory).

Formula

Quick Ratio = (Current Assets - Inventory) / Current Liabilities

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

Interpretation

Value Meaning
> 1.0 Company can cover short-term liabilities with liquid assets
= 1.0 Liquid assets exactly cover current liabilities
< 1.0 May have difficulty meeting short-term obligations

Syntax

=hf_Quick_ratio(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

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

Quick ratio as a decimal

Examples

=hf_Quick_ratio("AAPL", 2023, 4)
Q4 2023 quick ratio
=hf_Quick_ratio("MSFT", 2022, , "TTM")
2022 TTM quick ratio
=hf_Quick_ratio("GOOGL", "ly")
Last year quick ratio

When to Use

  • Analyzing short-term liquidity trends
  • Comparing liquidity across companies
  • Assessing ability to pay short-term debts
  • Credit analysis and financial health assessment

When NOT to Use

Scenario Use Instead
Need current quick ratio Quick_Ratio()
Need current ratio (includes inventory) hf_Current_ratio()
Need cash ratio hf_Cash_ratio()

Common Issues & FAQ

Why is quick ratio different from current ratio?

Quick ratio excludes inventory, providing a stricter liquidity measure.

What is a good quick ratio?

Generally, > 1.0 is considered healthy, but varies by industry.

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
MarketXLS Excel Add-in Tutorial - How to Use Quick Ratio (Historical) and Other Financial Formulas
▶
How does MarketXLS work?