Get help

Help center

Guides and answers

Contact support

Write to our team

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Finance

Turn manual finance work into reports that update themselves.

What Finance teams automate

  • Track payables and receivables
  • Build cash flow statements
  • Compare budget against actuals

Inventory and manufacturing

See stock levels and automate ordering.

What inventory and manufacturing teams automate

  • Track inventory across multiple sites
  • Connect sales, purchasing, and warehouse data
  • Link a barcode scanner to your sheet

HR

Run recruitment, attendance, and OKR tracking from your sheets.

What HR teams automate

  • Track recruitment and onboarding
  • Record team OKRs and results
  • Track check-ins, check-outs, and leave

Project management

Assign tasks and track hours without manual updates.

What project teams automate

  • Assign tasks and track status changes
  • Estimate effort and log hours worked
  • Track milestones across projects

Sales and CRM

Track leads and sales performance with automated reports.

What sales teams automate

  • Track and convert leads
  • Set sales goals and track team metrics
  • Monitor sales KPIs on dashboards

Education

Automate attendance, grades, and school purchasing.

What schools automate

  • Track attendance and notify parents
  • Record and compare class grades
  • Track inventory lent to students and staff

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Get started

Templates

Ready-made workflows to start from

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Help center

Guides and answers

Contact support

Write to our team

Workflows

Build processes with your team

Automations

Connect files and automate tasks

Liquidity ratio: types, calculation & examples

When evaluating a company’s financial situation, you can choose from multiple financial ratios and analyses, depending on your purpose. Leverage ratios focus on a company’s reliance on debt, solvency ratios on its ability to cover long-term debt obligations, and liquidity ratios on its ability to pay off short-term debt using liquid assets.

In this article, you will learn about liquidity ratios and why they are important. You will also learn how to set up a template for liquidity analysis in Google Sheets, using the formulas for the most popular liquidity ratios. Finally, you will learn how to interpret the values you get for these ratios. Although Google Sheets or Excel lets you automate calculations to save time and avoid mistakes, with Sheetgo’s AI automations, you can connect data from several platforms and formats and schedule updates.

What is a liquidity ratio?

Liquidity ratios are financial metrics that measure a company’s ability to meet its short-term obligations. In other words, these ratios indicate whether current liabilities can be paid using current or liquid assets. Depending on the specific ratio, the focus will be on current assets in general or highly liquid assets.

These ratios are of particular interest to short-term lenders and investors because they indicate the likelihood that the company will be able to pay off its short-term debt.

Why are liquidity ratios important?

Liquidity ratios are important metrics when evaluating a company’s short-term financial health. Because they measure a business’s ability to pay off current liabilities, short-term lenders and investors can use them to assess risk. These ratios indicate whether the company would be able to pay back short-term debt in the event of unexpected setbacks.

Current liabilities, generally used as the denominator for these ratios, usually refer to debt the company must pay back within a year. There are different types of liquidity ratios, and each considers a narrower subset of current assets. Together, they provide an overview of the company’s liquidity. These ratios are frequently analyzed together with solvency ratios, which focus on paying off long-term financial obligations, including any due interest.

Types of liquidity ratios

Depending on your role or the purpose of your analysis, you’ll be interested in different types of liquidity ratios. Although they all express a company’s ability to meet current liabilities, they differ in the selection of current assets considered.

The current ratio, for example, takes into account a broad range of current assets, including inventory and prepaid expenses; the quick ratio, however, only considers highly liquid assets, i.e., assets that can be converted into cash quickly. The cash ratio is even more restrictive since it only accounts for cash and cash equivalents. However, there are even more stringent liquidity ratios. The operating cash flow ratio only considers the cash flow generated directly by operations.

In the next section, you will learn the formulas to calculate these four liquidity ratios.

What is the most widely used liquidity ratio?

The current ratio is the most widely used liquidity ratio. It takes two figures straight from the balance sheet and covers all current assets, so lenders and analysts usually check it first. The quick ratio comes next. It leaves out inventory and prepaid expenses, which gives a stricter view of what the company could pay right away.

Liquidity ratio formula: how to calculate each ratio

Use the formulas below to calculate four of the most popular liquidity ratios.

  • Current Ratio represents the company’s ability to cover current liabilities using current or liquid assets.

current ratio = current assets / current liabilities

  • Quick Ratio represents the company’s ability to pay off current liabilities using highly liquid assets. It’s also called the acid-test ratio or liquid ratio.

quick ratio = (cash + marketable securities + accounts receivable) / current liabilities

  • Cash Ratio represents a company’s ability to pay for current liabilities using cash and cash equivalents.

cash ratio = (cash + marketable securities) / current liabilities

  • Operating Cash Flow Ratio represents the company’s ability to pay off its current liabilities using the cash flow generated by core operations.

operating cash flow ratio = operating cash flow / current liabilities

In the next section, you have examples of calculating these in Google Sheets, using data from the company’s financial statements.

Liquidity ratio examples

The data you need to calculate liquidity ratios is on the company’s financial statements, like balance sheets or cash flow statements. You can easily set up a template in Google Sheets to calculate the ratios you need.

1. Gather data

The first step is to gather the necessary data in your spreadsheet. The data below belong to Company A.

Liquidity ratio data in Google Sheets — Company A balance sheet and cash flow figures: cash, marketable securities, accounts receivable, operating cash flow, total current assets, and total current liabilities

2. Add formulas

Now that you have the data, you can add the formula for each ratio using cell references. Check the previous section for the formulas.

Current ratio

In cell E3, enter =B7/B8 (total current assets divided by total current liabilities).

Current ratio formula in Google Sheets — =B7/B8 typed in cell E3 next to the current ratio label

Quick ratio

In cell E4, enter =(B3+B4+B5)/B8.

Quick ratio formula in Google Sheets — =(B3+B4+B5)/B8 typed in cell E4, below a current ratio of 2.45

Cash ratio

In cell E5, enter =(B3+B4)/B8.

Cash ratio formula in Google Sheets — =(B3+B4)/B8 typed in cell E5, below the current and quick ratio results

Operating cash flow ratio

In cell E6, enter =B6/B8.

Operating cash flow ratio formula in Google Sheets — =B6/B8 typed in cell E6, below the current, quick, and cash ratio results

3. Analyze & compare the results

Once you have the values for your chosen liquidity ratios, you can interpret them using the general guidelines from the next section. However, remember that it’s important to compare your values to those of similar companies and use industry-specific benchmarks.

Liquidity ratio results in Google Sheets — current ratio 2.45, quick ratio 2.46, cash ratio 1.34, and operating cash flow ratio 0.97

Liquidity ratio interpretation

As mentioned, financial ratios, including liquidity ratios, should be analyzed in context by comparing them to those of similar companies in the industry. Every industry has its specific customs and accounting practices, which could significantly impact the range of acceptable values for these ratios.

What is a good liquidity ratio?

Because liquidity ratios divide assets by liabilities, higher values are better. For the current ratio, a value of 1 indicates that the company can cover current debt using current assets. A ratio of 2 indicates it could pay for it twice, a more comfortable financial position.

However, some liquidity ratios take a much stricter approach and only consider cash and cash equivalents. A cash ratio below 1 shouldn’t necessarily be the cause for concern, particularly in specific industries.

Conclusion

You now know about liquidity ratios and what they can tell you about a company’s current finances. Together, these ratios provide an overview of how well a company can cover its current liabilities using current assets. You also know the formulas for the four most common liquidity ratios and how to interpret their values. As with any financial ratio, it’s important to get industry benchmarks and compare values to those of similar companies.

From the current ratio, which provides the broadest view of liquid assets, to the operating cash flow ratio, which is very specific, you can easily set up a quick template in Google Sheets. For a more comprehensive analysis, you can add other types of financial ratios to the template. If the figures come from several spreadsheets, Sheetgo’s AI finance virtual employee can collect them on a schedule and keep your ratios up to date.

To learn more about financial ratios and analyses used to assess a company’s financial health and performance, check out these articles on:

● Available 24/7

Put Owen on your finance ops

Sheetgo's finance virtual employee keeps your numbers current and your reporting on time. Your data stays in Google Sheets; you work with Owen in Slack, Teams, or Google Chat.

You may also like…

simple finance add on featured image

Build a stock portfolio spreadsheet, track your investments

Staying on top of your investments can be a real challenge, particularly if you manage them through many brokers. In this post we will...
finance

How to use Google Sheets for currency conversion

Staying up to date with the latest conversion rates can be a daunting task. But it doesn’t have to be. Read on to learn how to use Google...
finance processes and templates

8 steps to prepare a bank reconciliation statement

Bank reconciliation is a crucial financial process for businesses to ensure that records match bank statements. In this post, we'll...