Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Quick Ratio Formula | Calculator (with Excel Template)

Quick Ratio

Flow of the article

  • Quick Ratio Formula
  • Quick Ratio Calculator
  • Quick Ratio Excel Template

Quick Ratio Formula

Quick Ratio or Acid Test Ratio is one of the most important Liquidity Ratios for determining the company’s ability to pay off its current liabilities in the short term.

It goes by the formula.

Formula of Quick Ratio

OR

In case company is not giving breakup of Quick Assets, then:

Quick Ratio formula

 Explanation of Quick Ratio Formula

The Quick Ratio Formula is a more stringent measure of short-term liquidity as compared to Current Ratio. Quick Assets are the ones which can be converted to cash in short term or in a period of 90 days. The important difference between Current Ratio formula and Acid Test Ratio formula is that we are excluding Inventory & Prepaid Expenses as a part of Current Assets in Quick Ratio formula.

Inventory is excluded because it is assumed that the stock held by the company may not be realized immediately. The inventory could be in the form of Raw materials or W-I-P. Such a situation will make the process of liquidating the inventory all the more tricky and time-consuming.

An acid test ratio of 1 or more indicates that the company can pay off its current liabilities with the help of Quick Assets, and without needing to sale off its long term assets and has sound financial health. Care must be exercised in placing too much reliance on  acid test ratio  without further investigating; For e.g.: Seasonal businesses, which seek to stabilize production, might have a weak Quick ratio formula during its period of slack sales, but a higher one in case of its peak business season. Such situations may prove tricky to know the actual financial position of the company.

Use of Quick Ratio Formula

  • Keeping track of Quick ratio formula helps the management to determine whether they are maintaining optimum levels of Quick assets so as to take care of its short term liabilities in their balance sheets.
  • Quick Ratio formula showcases a well-functioning short term financial cycle of a company.
  • This improves the credibility of the company with the investors by gaining and maintaining their trust in the value of their investments.
  • Also the creditors of the company know that their payments will be made on time.

Quick Ratio Formula Example

Masters Co. Ltd has following details:

Current Assets:

  • Cash = $200,000
  • Advance = $30,000
  • Marketable Securities = $60,000
  • Account Receivables = $40,000
  • Inventories = $80,000

Total Current Assets = $410,000

Current Liabilities:

  • Account Payable = $260,000,
  • Accrual Expenses = $30,000,
  • Short-term Debt = $90,000,
  • Interest Payable = $60,000.

Total Current Liabilities = $440,000.

Previous years acid test ratio  was 1.4 and the industry average is 1.7

Calculation of acid test ratio :

Acid test ratio formula = (Cash + Short-term marketable securities + A/c’s Receivable) / Current Liabilities

= ($200,000 + $60,000 + $40,000) / ($440,000)

= ($300,000) / ($440,000)

= 0.68

Microsoft Acid Test Ratio Example

Let’s now look at the example of Microsoft acid test ratio .

As noted from the below graph, Cash Ratio of Microsoft is a low 0.110x, however, its acid test ratio is a massive 2.216x.

microsoft-quick-ratio-v1

source: ycharts

Microsoft acid test ratio is pretty high primarily due to short-term investments of around $106.73 billion! This puts Microsoft in a very comfortable position from the point of view of liquidity / Solvency.

microsoft-short-term-investments

source: Microsoft SEC Filings

Interpretation of Acid Test Ratio

  • As per previous year, the company had a acid test ratio  of 1.4, whereas this time it amounts to 0.68.
  • From this, we can figure out that the company has not maintained enough Quick assets to pay off its current liabilities. It shows that the company will face potential liquidity problems.
  • It might have to sell off its long-term assets to pay off its liabilities if needed, which is not a sign of a healthy and well-managed balance sheet.
  •  The company should maintain the an acid test ratio to at least 1, which is considered ideal and satisfactory.

Quick Ratio Calculator

You can use the following Asset to Sales Ratio Calculator

Cash
Short-term marketable securities
A/c’s Receivable
Current Liabilities
Quick Ratio =
 

Quick Ratio =
Cash + Short-term marketable securities + A/c’s Receivable
Current Liabilities
0+0+0
= 0
0

Quick Ratio in Excel (with excel template)

Let us now do the same example above in Excel.

This is very simple. You need to provide the two inputs of Total Current Assets and Total Current Liabilities.

You can easily calculate the ratio in the template provided.

Quick Ratio formula in Excel

Calculation of acid test ratio

Acid test ratio = (Cash + Short-term marketable securities + A/c’s Receivable) / Current Liabilities

Quick Ratio formula in Excel template

You can download this Quick ratio template here – Quick Ratio  Excel template

Recommended Articles

This has been a guide to Quick Ratio Formula, practical examples, and Quick Ratio calculator along with excel templates. You may also have a look at these articles below to learn more about Financial Analysis –

  • Acid Test Ratio
  • Plowback Ratio Formula
  • Debt Ratio Formula
  • Debt to Income Ratio Formula

The post Quick Ratio Formula | Calculator (with Excel Template) appeared first on Learn Investment Banking: Financial Modeling Training Online.



This post first appeared on Free Investment Banking Tutorials |WallStreetMojo, please read the originial post: here

Share the post

Quick Ratio Formula | Calculator (with Excel Template)

×

Subscribe to Free Investment Banking Tutorials |wallstreetmojo

Get updates delivered right to your inbox!

Thank you for your subscription

×