Wall Street Prep

Quick Ratio

Learn the Steps to Calculate the Quick Ratio

Learn Online Now

Quick Ratio

Key Learning Objectives
  • What is the quick ratio used to measure?
  • How is the quick ratio different from the current ratio?
  • For companies, what would the “target” quick ratio be?
  • Which types of companies tend to have lower (and higher) quick ratios?

Quick Ratio Formula

The quick ratio compares the short-term assets of a company to its short-term liabilities to evaluate if the company would have adequate cash to pay off its short-term liabilities.

The formula used to calculate the quick ratio consists of dividing a company’s current cash & equivalents (e.g. marketable securities) and accounts receivable by its current liabilities.

Quick Ratio Formula

Conceptually, the quick ratio answers the question of, “Does the company have enough cash to pay off its short-term liabilities, such as debt obligations soon coming due?

The core components of the quick ratio include the following line items:

  • Current Assets: Cash & Equivalents, Marketable Securities, Accounts Receivable (A/R)
  • Current Liabilities: Accounts Payable (A/P), Short-Term Debt

In the calculation of the quick ratio, the items that are considered as part of current assets are under more stringent rules — which is based on the notion that certain assets are more difficult to liquidate quickly, such as inventory, or may be difficult to sell at the same or relatively similar value (i.e. in a scenario where no substantial discount is required to sell the asset).

The inclusion of illiquid current assets within the calculation can potentially cause a misleading portrayal of the company’s financial condition, as it may misleadingly portray a company as being better able to meet its short-term obligations than in reality.

Quick Ratio vs Current Ratio

Similar to the current ratio, which also compares current assets to current liabilities, the quick ratio is categorized as a liquidity ratio.

Both the current ratio and quick ratio are calculated under a hypothetical scenario in which a company must pay off all existing current liabilities that have come due using its current assets.

However, one major difference between the two is that the quick ratio includes only the current assets that can be converted into cash within 90 days or less, whereas the current ratio includes all current assets that can be converted into cash within one year.

The quick ratio is thus considered to be more conservative than the current ratio since its calculation intentionally ignores more illiquid items like inventory.

Quick Ratio Example Calculation

Let’s say a company has the following balance sheet data:

Current Assets

  • Cash = $20 million
  • Marketable Securities = $10 million
  • Accounts Receivable (A/R) = $20 million
  • Inventory = $40 million

Current Liabilities

  • Accounts Payables = $30 million
  • Short-Term Debt = $10 million

Next, the required inputs can be calculated using the following formulas.

  • Current Assets = $20 million + $10 million + $20 million = $50 million
  • Current Liabilities = $30 million + $10 million = $40 million

As mentioned earlier, illiquid assets are excluded in the calculation of the quick ratio, which is why inventory is not included.

Lastly, we’ll divide the current assets by the current liabilities to arrive at the quick ratio:

  • Quick Ratio = $50 million ÷ $40 million = 1.25x

Interpreting the Quick Ratio

While dependent on the specific industry, the quick ratio should exceed >1.0x for the vast majority of industries.

The two general rules of thumb in  interpreting the quick ratio are:

  • Higher Quick Ratios → Sufficient Coverage of Current Liabilities
  • Lower Quick Ratios → Insufficient Coverage of Current Liabilities

The quick ratio measures if a company, post-liquidation of its liquid current assets, would have enough cash to pay off its immediate liabilities — so, the higher the ratio, the better off the company is from a liquidity standpoint.

If the ratio is low, the company should likely proceed with some degree of caution and the next step would be to determine how and how quickly more capital could be obtained.

For example, a company with a low quick ratio might not be at too much of a risk if it has non-core fixed assets on standby that could be sold relatively quickly.

In fact, such a company may be viewed favorably by the equity or debt capital markets and be able to raise capital easily.

A high quick ratio should NOT automatically be interpreted as a positive sign without further research into the company’s drivers – e.g. a company can have a healthy quick ratio of 2.0x yet the majority of its current assets are A/R where the collection of payment from customers is not always guaranteed.

While a higher amount of asset collateral is perceived positively under a liquidation scenario, most companies focus more on forward-looking performance like free cash flow (FCF) generation and profit margins, although all of these aspects are ultimately interconnected.

Quick Ratio Excel Template

Now that we’ve defined the quick ratio, we’ll move on to a modeling exercise in Excel. For access to the model template, fill out the form below:

dl
Submitting ...

Quick Ratio Example Calculation

For our example calculation of the quick ratio, we’ll be using the following assumptions in our model.

Balance Sheet Assumptions — Year 1

Current Assets

  • Cash & Equivalents: $20m
  • Marketable Securities: $15m
  • Accounts Receivable (A/R): $25m
  • Inventory: $80m

Current Liabilities

  • Accounts Payable: $65m
  • Short-Term Debt: $85m

In Year 1, the quick ratio can be calculated by dividing the sum of the liquid assets ($20m Cash + $15m Marketable Securities + $25m A/R) by the current liabilities ($150m Total Current Liabilities).

  • Quick Ratio — Year 1: $60m ÷ $150m = 0.4x

Quick Ratio Excel Formula

The company appears to not have enough liquid current assets to pay its upcoming liabilities.

From Year 2 to Year 4, we’ll use a step function for each B/S line item with the following assumptions.

B/S Assumptions — Years 2 to 4

Current Assets

  • Cash & Equivalents: +$5m
  • Marketable Securities: +$2m
  • Accounts Receivable (A/R): +$3m
  • Inventory: +$25m

Current Liabilities

  • Accounts Payable: +$5m
  • Short-Term Debt: +$10m

Upon dividing the sum of the cash & equivalents, marketable securities, and accounts receivable balance by the total current liabilities balance, we arrive at the quick ratio for each period.

At the end of the forecast period, Year 4, the quick ratio remains relatively unchanged at 0.5x — which is problematic as the concerns regarding short-term liquidity remain.

Quick Ratio Calculation

However, the current ratio in Year 4 is 1.3x, more than double that of the quick ratio of 0.5x.

While the high inventory balance and growth benefit the current ratio, the quick ratio excludes illiquid current assets such as inventory. The gap between the current ratio and quick ratio stems from the inventory line item, which comprises a significant portion of the total current assets balance.

The inventory balance of our company expands from $80m in Year 1 to $155m in Year 4, reflecting an increase of $75m.

Our company’s current ratio of 1.3x is not necessarily positive, since a range of 1.5x to 3.0x is usually ideal, but it is certainly less alarming than a quick ratio of 0.5x.

On one note, the inventory balance can be helpful when raising debt capital (i.e. collateral), as long as there are no existing liens placed on the inventory or any other contractual restrictions.

Yet, the broader concern here is that the cause of the accumulating inventory balance is due to declining sales or lackluster customer demand for the company’s products/services.

Comments
guest
0 Comments
Inline Feedbacks
View all comments
Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.