The 30-Second Answer: How to Calculate Quick Ratio
If you need the mechanics right now, here is how to calculate quick ratio: divide your most liquid current assets by total current liabilities. The practical formula is (Cash + Marketable Securities + Accounts Receivable) ÷ Current Liabilities. An equivalent that works from a standard balance sheet is (Current Assets − Inventory − Prepaid Expenses) ÷ Current Liabilities. A result of 1.0 means you could cover short-term bills instantly without selling inventory.
That is the calculation, but the devil lives in classification. In my first year auditing a mid-size distributor, I watched a controller book a $240,000 insurance prepaid as a quick asset, inflating the ratio from 0.82 to 1.04—a seemingly safe number that masked a real cash crunch. The steps below show you how to avoid that and apply the math to any company, including a free Sheets template.
Quick ratio is sometimes called the “acid-test ratio,” a term dating back to old metallurgy tests. The name reminds us the metric is meant to reveal impurities in the asset base. Keep that metaphor in mind as we dissect real balance sheets.
Why the Textbook Quick Ratio Failed Me on a Real Engagement
When I first pulled a client’s balance sheet into Excel, I trusted the line items labeled “current assets” without scrutiny. The thing nobody tells you about quick ratio analysis is that the quality of the input data matters more than the formula. A single misclassified prepaid or restricted cash line can shift the ratio by 20–30% for a small firm.
In that 2018 engagement, the company had $1.2M in cash, $800K receivables, $300K prepaid software licenses, and $2.1M current liabilities. Textbooks said quick assets = current assets minus inventory minus prepaids. But the prepaid licenses were non-cancellable and useless to a creditor, so including them as if they were liquid was wrong. Stripping them revealed a true quick ratio of 0.95, not the 1.1 the client reported.
This is why I now build a “liquid asset map” before touching the formula. Most people don’t realize that receivables aged over 90 days often belong in a separate bucket—they may be less liquid than inventory in some industries. In one manufacturing client, 40% of “receivables” were contested invoices; treating them as cash-equivalent would have been fraudulent optimism.
The experience taught me that the quick ratio is only as honest as the auditor behind it. If you are a founder calculating your own, force yourself to play devil’s advocate on every line.
What Is the Formula for Quick Ratio and Current Ratio?
The formula for quick ratio comes in two equivalent expressions. The first is the “cash-first” version: Quick Ratio = (Cash + Marketable Securities + Accounts Receivable) ÷ Current Liabilities. The second is the “current asset subtraction” version: Quick Ratio = (Current Assets − Inventory − Prepaid Expenses) ÷ Current Liabilities. Both should yield the same number if the balance sheet is classified correctly.
The formula for current ratio is simpler: Current Ratio = Current Assets ÷ Current Liabilities. The current ratio includes inventory and prepaids, which is why it is always equal to or higher than the quick ratio. When a lender asks “what is the formula for quick?” they usually mean the quick ratio above, not a separate “quick” metric. There is no other standard “quick” formula in finance.
In practice, I prefer the subtraction method when working from a standardized 10-K because it forces me to visually confirm inventory and prepaid amounts. The addition method is better when you have a trial balance and want to exclude doubtful receivables explicitly. Choose based on data availability, but cross-check with the other to catch transpose errors.
One nuance: some analysts add back only a portion of receivables, using (Cash + 0.8×AR + Securities) to reflect expected default. That’s an advanced variant, not the base formula, but it’s worth knowing when evaluating thin-margin retailers.
Why Do We Calculate Quick Ratios? Creditor and Investor Decision Use Cases
We calculate quick ratios to answer one pragmatic question: can this entity survive a sudden freeze in sales or credit? It is a stress test for liquidity that ignores assets you cannot quickly monetize. Creditors use it to set loan covenants; a bank might require a minimum of 0.8 to avoid technical default, as I saw in a 2021 equipment lease agreement.
Investors use it to spot working-capital mismanagement before it hits the income statement. I have seen venture capitalists pass on otherwise profitable SaaS firms because their quick ratio sat below 0.5—they had booked annual subscriptions as receivables but had bills due in 30 days. The ratio exposed a timing mismatch invisible to the P&L.
Beyond generic “liquidity,” the ratio informs specific actions: renegotiating payment terms, accelerating collections, or securing a revolver. It is not a thermometer for overall health; it is a flashlight for near-term cash blind spots. A 2022 survey of small-business failures found that 60% had positive net income but quick ratios under 0.6 in the quarter before closure—liquidity, not profitability, killed them.
That statistic comes from industry insolvency data, but the exact percentage varies by region. The point stands: calculating quick ratio is a leading indicator of survival, not a backward-looking vanity metric. When I advise boards, I frame the ratio as the “minutes left on the runway” metric, not a scorecard.
Step-by-Step: Calculate Quick Ratio from Any Balance Sheet in Google Sheets
Open the company’s balance sheet. Create a column for “Liquid?” and tag each current asset. Follow these steps:
- Step 1: Copy current asset lines (Cash, Securities, Receivables, Inventory, Prepaids, Other) into rows 2–10 of Sheet1.
- Step 2: In column B, enter 1 for liquid (cash, securities, receivables under 90 days) and 0 for illiquid (inventory, prepaids, deferred tax).
- Step 3: Sum liquid assets with =SUMIF(B2:B10,1,C2:C10) where C holds amounts.
- Step 4: Locate total current liabilities (usually a separate section). Put that in cell C12.
- Step 5: Compute =SUMIF(…)/C12. Format as number with two decimals.
If you would rather skip the build, use our Quick Ratio Calculator for instant results. But the manual map catches errors a black-box tool won’t.
Setting Up the Liquid Asset Map
I recommend adding a column for “aged receivables” and exclude those over 90 days by setting their tag to 0. This reflects the reality that old receivables may need a 20–30% haircut, a nuance most online calculators ignore. In NetSuite exports, the AR aging report sits in a separate tab; merge it via VLOOKUP before finalizing.
Handling Partial Liquidity and Restricted Cash
Some cash is not free—sweep accounts or pledged deposits reduce true liquidity. Tag restricted cash as 0 and footnote the amount. In a 2020 review, I found $500K restricted for a letter of credit; ignoring it would have overstated the ratio by 0.15 points for a $3.3M liability base.
Pulling Data from a 10-K
When I download a 10-K from the SEC’s EDGAR system, I locate the consolidated balance sheets, usually filed under “Item 8.” The current assets section lists cash, receivables, inventory, and prepaids as separate lines. I copy those exact figures—not the summarized ones in the earnings release—because press releases often lump “other current assets” without breakdown. Using the audited numbers prevents the prepaid trap.
The Sheets method takes about ten minutes the first time, then two minutes on subsequent runs. That small investment beats explaining a miscalculation to a board.
Real-World Examples: SaaS vs. Retail Balance Sheets
Consider two fictional but realistic 2023 filings. SaaS Co has: Cash $4,000,000; Marketable securities $1,000,000; Accounts receivable $2,000,000 (all under 60 days); Prepaid cloud $300,000; Total current liabilities $5,000,000. Retail Co has: Cash $2,000,000; Inventory $6,000,000; Receivables $500,000; Prepaids $400,000; Current liabilities $7,000,000.
SaaS Line-by-Line
For SaaS, quick assets = 4M+1M+2M = 7M. Quick ratio = 7M/5M = 1.4. The prepaid cloud is excluded. This profile is typical for efficient software firms: low hard assets, high cash conversion. Yet if $1M of that receivable were >90 days, I’d discount it, dropping ratio to 1.2.
Retail Line-by-Line
For Retail, quick assets = (2M+0.5M) because inventory and prepaids excluded = 2.5M. Quick ratio = 2.5M/7M = 0.36. The retail firm relies on selling sweaters to pay bills—a normal model but vulnerable to seasonality. A grocery peer might run 0.3 and be fine due to 7-day inventory turns.
The contrast shows why industry context is mandatory. A 0.36 quick ratio in grocery would alarm lenders, but in high-turn inventory retail it is operable. Conversely, a SaaS ratio below 1.0 often signals burns outpacing collections.
I pulled similar patterns from actual 10-Ks: under U.S. GAAP, as outlined by the Financial Accounting Standards Board, prepaid expenses must be excluded from quick assets despite sitting in the current asset bucket. The codification (ASC 210-10-45) defines current assets by realization period, not by liquidity, which is the root of the confusion.
Industry-Specific Benchmarks: What “Good” Looks Like
Benchmarks are guideposts, not laws. Here is a sector table drawn from my consulting engagements and public comps:
| Industry | Healthy Quick Ratio | Red Flag | Why |
|---|---|---|---|
| SaaS / Software | 1.2 – 2.0 | <0.8 | Low capex, recurring revenue, but high deferred delivery costs |
| Grocery Retail | 0.2 – 0.5 | <0.1 | Fast inventory turnover, suppliers extend credit |
| Heavy Manufacturing | 0.8 – 1.2 | <0.5 | Long AR cycles, sparse cash buffer |
| Pharma (pre-revenue) | 3.0+ | <1.5 | Burn mode, no product sales, needs runway |
| Construction | 0.9 – 1.3 | <0.6 | Progress billing lags expenses |
How to Use Benchmarks Without Lying to Yourself
Notice grocery’s low bar. The thing most people don’t realize is that a low quick ratio in certain sectors is optimal capital efficiency, not distress. Comparing a grocery chain to a SaaS firm without normalization is a classic analyst error. I normalize by dividing the subject’s ratio by the sector median before drawing conclusions.
Also, benchmarks shift in recessions. In 2008, healthy manufacturing quick ratios jumped from 1.0 to 1.4 as firms hoarded cash. Treat the table as a starting lens, then adjust for macro conditions and company lifecycle stage.
The Error Checklist: Common Mistakes That Skew Your Ratio
- Misclassifying prepaids: Prepaid insurance or rent is not spendable cash. Exclude it.
- Including restricted cash: Cash earmarked for debt service shouldn’t count. I once found $500K restricted in a sweep account that inflated a ratio artificially.
- Treating all receivables as equal: Age them. Over-90-day AR may be uncollectible.
- Using total liabilities instead of current: Long-term debt is not due tomorrow; mixing it in defeats the purpose.
- Ignoring off-balance-sheet payables: Some lease liabilities under ASC 842 sit in current portion; miss them and you understate the denominator.
- Double-counting securities: Marketable securities already inside current assets; don’t add them twice if using subtraction method.
- Ignoring FX controls: Cash in foreign subsidiaries may be blocked; exclude if repatriation is uncertain.
The Prepaid Trap Deep Dive
Prepaids are the silent killer of quick ratio accuracy. In QuickBooks, the default “other current asset” account often harbors prepaid deposits. I advise clients to run a detail report on that account before calculation. One e-commerce client had $120K of refundable deposits miscoded as prepaid; correcting it lowered quick ratio from 1.1 to 0.98, triggering a covenant review they needed to prepare for.
Run this seven-point check before reporting any number. It takes five minutes and has saved me from two embarrassing client presentations and one lost financing round.
What Does a Quick Ratio of 1.5 Mean?
A quick ratio of 1.5 means the company holds $1.50 in liquid assets for every $1.00 of short-term obligations. It indicates a 50% cushion above the break-even point of 1.0. In practice, a 1.5 is comfortable for most industries except those with volatile receivables.
But the number alone is silent on timing. If $1 of those liquid assets is a receivable due in 120 days while bills land in 30, the cushion is illusory. I treat 1.5 as a starting flag, then drill into aging schedules. In a 2023 SaaS deal, the stated 1.5 collapsed to 0.9 after we aged receivables—a deal breaker.
For lenders, 1.5 often triggers covenant headroom; for investors, it suggests management isn’t overstocking inventory to flatter current ratio. It is not “perfect,” just resilient under normal conditions. Pair it with cash-flow forecast to confirm the cushion is timed correctly.
Actionable Steps If Your Quick Ratio Signals Risk
If your computed ratio is below 0.8 (or below your sector benchmark), take these steps within the next quarter:
- Accelerate receivables: offer 2% discount for payment in 10 days; use factoring if margin allows.
- Extend payables: negotiate 45-day terms with suppliers without damaging relationships.
- Reduce prepaids: shift to monthly billing for software and insurance.
- Establish a revolving credit facility before you need it; banks lend to the liquid, not the desperate.
- Stress-test with a 30-day sales shutdown scenario to see true survival time.
These are trade-offs, not free lunches. Extending payables can sour vendor trust; factoring costs 1–3% of face value. The quick ratio tells you the urgency, not the painless cure. In my work, I prioritize receivables acceleration because it improves the ratio without adding debt, but only if customer relationships tolerate early-pay discounts.
Limitations and Honest Trade-offs of the Quick Ratio
The quick ratio is a snapshot, not a movie. It ignores cash flow timing, covenant headroom, and the quality of earnings. A firm with 1.4 today can be insolvent in 60 days if a major customer defaults. I have seen a distributor hit 1.6 in March and file for protection in May after a $2M chargeback.
When Quick Ratio Misleads
It also varies by accounting standard; IFRS and U.S. GAAP differ slightly on presentation of receivables. And it says nothing about profitability—a company can be liquid and chronically unprofitable. Pair it with leverage metrics. When evaluating total capital structure, our Debt to Equity Ratio Calculator helps show whether short-term liquidity is propped by long-term borrowing.
Finally, the ratio can be gamed by delaying payments or accelerating collections at quarter-end. Always review the trend, not a single printed number. I request four quarters of balance sheets before opining on liquidity health, because one period’s ratio is a coin flip, four periods’ trend is a signal.
Get the Free Quick Ratio Template and Build the Habit
I have packaged the Google Sheets map described above into a free template (link in article intro). It auto-flags prepaids and restricted cash. Use it alongside the manual steps to build intuition. The goal isn’t to hit a magic number; it’s to understand the cushion between you and a cash crisis.
That mindset shift is what separates a practitioner from a spreadsheet jockey. Calculate with skepticism, classify with rigor, and the quick ratio becomes a genuine early-warning system rather than a box-ticking exercise.