background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for September 2024 for September 2024
:
Private EquityReal Estate Investing
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for September 2024 is Open
Wall Street Prep

Liquidity Ratio

Step-by-Step Guide to Understanding the Liquidity Ratio Concept

Last Updated April 18, 2024

Learn Online Now

Liquidity Ratio

How to Calculate Liquidity Ratio?

Liquidity is defined as how quickly an asset can be converted into cash.

Therefore, assets that can be sold and turned into cash in a short amount of time are considered to be highly liquid (and vice versa for assets with low liquidity).

Other than cash itself, common examples of current assets recorded on the balance sheet with the highest liquidity include:

  • Treasury Bills
  • Treasury Bonds
  • Certificate of Deposits (CDs)
  • Marketable Securities
  • Short-Term Investments
  • Money Market Funds

The current assets listed above are often consolidated within the “Cash and Cash Equivalents” line item.

Other current assets considered to be highly liquid include:

  • Accounts Receivable (A/R)
  • Inventory

However, the actual liquidity of these assets tends to be dependent on the company (and financial circumstances).

For instance, accounts receivable – the uncollected payments from customers that paid on credit – are not guaranteed to be received (i.e. “bad A/R”) and can be time-consuming to collect.

As for inventory, finding interested buyers can require steep discounts, so the sale price is often lower than the value as stated on the books (or could even remain unsold).

With that said, liquidity ratios can come in various forms, but the most common are as follows.

  • Current Ratio
  • Quick Ratio
  • Cash Ratio
  • Net Working Capital (NWC) % Revenue
  • Net Debt

The pattern among each of these measures of liquidity is the short-term focus and the amount of value placed on current assets (rather than current liabilities).

1. Current Ratio Formula

The current ratio measures a company’s capacity to pay off all its short-term obligations.

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

The current ratio includes all current assets that can be converted into cash within one year and all current liabilities with maturities within one year.

Generally, a current ratio around 1.5x to 3.0x is considered “healthy,” with a current ratio of <1.0x being a sign of impending liquidity problems.

Current Ratio = Current Assets ÷ Current Liabilities

2. Quick Ratio Formula

The quick ratio is a more stringent variation of the current ratio, including only the most liquid assets – or more specifically, assets that can be converted into cash within 90 days with a high degree of certainty.

While dependent on the specific industry, the quick ratio should generally exceed >1.0x.

Quick Ratio = (Cash & Equivalents + Marketable Securities + Accounts Receivable) ÷ Current Liabilities

3. Cash Ratio Formula

Of the ratios listed thus far, the cash ratio is the most conservative measure of liquidity.

The cash ratio measures a company’s ability to meet short-term obligations using only cash and cash equivalents (e.g. marketable securities).

If the cash ratio equals 1.0x, the company has exactly enough cash and cash equivalents to pay off short-term liabilities, so anything higher would be considered a positive sign (i.e. cash & equivalents are adequate).

Cash Ratio = Cash & Cash Equivalents ÷ Current Liabilities

4. Net Working Capital to Revenue Ratio Formula (NWC)

Net working capital (NWC) is equivalent to current operating assets (i.e. excluding cash & equivalents) less current operating liabilities (i.e. excluding debt and debt-like instruments).

The NWC metric indicates whether a company has cash tied up within operations or sufficient cash to meet its near-term working capital needs.

  • Positive NWC ➝ More Cash is Tied Up in Operations, Less Free Cash Flows
  • Negative NWC ➝ Less Cash is Tied Up in Operations, More Free Cash Flows

With that said, from a liquidity standpoint, a negative NWC is preferred over a positive NWC.

There is no set percentage that all companies strive for, as the optimal level of NWC is dependent on the company’s specific industry and business model, but higher ratios are typically perceived negatively.

Higher NWC/Revenue ratios mean that more current assets are locked up in the business, which reduces liquidity – e.g. the company is struggling to collect cash payments from customers that paid on credit or facing difficulty in selling off inventory.

NWC % Revenue = Net Working Capital ÷ Revenue

5. Net Debt Formula

The net debt is a measure of how much of a company’s short-term and long-term debt obligations could be paid off right now with the amount of cash available on its balance sheet.

Note that the net debt metric is not a liquidity ratio (i.e. includes long-term debt) but is still a useful metric to evaluate a company’s liquidity.

If two identical companies have the same amount of debt in their capital structure – but one has a lower net debt balance – it can be implied that this company has comparatively more liquidity (and reduced risk).

Net Debt = Total DebtCash & Cash Equivalents

Liquidity Ratio Calculator

We’ll now move to a modeling exercise, which you can access by filling out the form below.

Excel Template | File Download Form

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

Liquidity Ratio Calculation Example

Suppose we’re tasked with analyzing the liquidity risk of a company with the following financial data.

Liquidity Ratio Year 1 Year 2 Year 3 Year 4 Year 5
Cash and Equivalents $100 $120 $140 $160 $180
Marketable Securities 10 12 14 16 18
Accounts Receivable 25 30 35 40 45
Inventory 65 69 73 77 81
Total Current Assets  $200 $231 $262 $293 $324
Accounts Payable $50 $60 $70 $80 $90
Accrued Expense 10 11 12 13 14
Short-Term Debt 40 35 30 25 20
Total Current Liabilities  $100 $106 $112 $118 $124

Given the financial data, we can calculate the current ratio, quick ratio, and cash ratio for each year.

Current Ratio

  • Year 1 = 2.0x
  • Year 2 = 2.2x
  • Year 3 = 2.3x
  • Year 4 = 2.5x
  • Year 5 = 2.6x

Quick Ratio

  • Year 1 = 1.4x
  • Year 2 = 1.5x
  • Year 3 = 1.7x
  • Year 4 = 1.8x
  • Year 5 = 2.0x

Cash Ratio

  • Year 1 = 1.0x
  • Year 2 = 1.1x
  • Year 3= 1.3x
  • Year 4 = 1.4x
  • Year 5 = 1.5x

From Year 1 to Year 5, the company’s current ratio expanded from 2.0x to 2.6x, quick ratio increased from 1.4x to 2.0x, and cash ratio grew from 1.0x to 1.5x.

Therefore, the company’s liquidity risk reduced substantially based on the improvement across each liquidity ratio.

Liquidity Ratio Calculator

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
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

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.