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

Quick ratio: calculation, formula & examples

Liquidity ratios are among the many financial ratios used to evaluate a business’s financial health and performance. Specifically, they express the company’s ability to pay back short-term debt using current assets. Popular liquidity ratios include the quick ratio and current ratio.

The quick ratio, aka quick asset ratio or acid test, considers only highly liquid assets, like cash or securities. The company’s financial statements have the information you need for the quick ratio calculation.

In this article, you will learn about the quick ratio and what it says about a company’s financial situation. You will also learn how to calculate the quick ratio in Google Sheets and interpret its value in the context of the company’s industry.

Quick ratio calculation

The quick ratio, or quick asset ratio, results from dividing quick assets by current liabilities. Quick assets are those that can be turned into cash quickly – within 90 days. The value of quick assets can be added using the balance sheet data. This is easy to set up in a template, using tools like Excel or Google Sheets. Remember to only include highly liquid assets like cash, accounts receivable, and marketable securities – no inventory or prepaid expenses.

Quick ratio formula

The quick ratio can be calculated using the following formula:

quick ratio = quick assets / current liabilities

If the value of quick assets is not directly available, you can always calculate it yourself from the data available on the balance sheet.

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

or

quick ratio = (current assets – (inventory + prepaid expenses)) / current liabilities

What is a good quick ratio?

A quick ratio above 1 is considered good, as this usually means current debt can be paid for using highly liquid assets, like cash and marketable securities. This makes creditors and investors happy, as it implies financial stability; current liabilities can be covered without having to sacrifice long-term assets.

What if the quick ratio is less than 1?

A quick ratio below 1 usually means that the company could struggle to meet short-term obligations using quick assets. An unexpected setback could force the company to sell long-term assets to pay the short-term debt. However, they might find that long-term assets are harder to sell, particularly without incurring significant losses.

Within reason, the higher the ratio, the better: a ratio that is too high could indicate problems in the company’s management and accounting practices. Remember to get industry benchmarks to compare quick ratio values. Depending on various factors – like the type of industry and the size of the company – the acceptable top range of values may vary.

Quick ratio vs current ratio

While the quick ratio focuses exclusively on highly liquid assets, the current ratio provides a broader view by considering all current assets. In other words, it expresses the company’s ability to cover its short-term liabilities within a year using current assets.

Quick ratio examples

If a company has quick assets valued at $85,000.00 and its current liabilities total $53,000.00, the quick ratio can be calculated as follows:

$85,000.00 / $53,000.00 = 1.603773585

A ratio of 1.6 would usually be considered very healthy.

However, if quick assets are worth $53,000.00 and liabilities are $85,000.00:

$53,000.00 / $85,000.00 = 0.6235294118

A quick ratio with a value of 0.62 is something that most investors would be concerned about, although there may be exceptions.

How to calculate the quick ratio in Google Sheets?

Let’s say you want to calculate the quick ratio for Company A in Google Sheets. The company has the data shown below on the balance sheet.

Quick ratio in Google Sheets — balance sheet with total current assets of $1,085,500.00 and total current liabilities of $801,833.00

1. In an empty cell, type in the ‘=' sign and open the parenthesis. Add the cells with the values for the quick assets.

Quick ratio formula — =(B3+B4+B5) in cell E1 next to the Quick Ratio label, adding cash, marketable securities, and accounts receivable

2. After closing the parenthesis, add the ‘/’ sign and click on the cell with the value for total current liabilities.

Quick ratio formula — =(B3+B4+B5)/B29 dividing quick assets by total liabilities of $801,833.00

3. Press “Enter” to get the quick ratio.

Quick ratio calculation — cell E1 showing a quick ratio of 0.9858661342

Conclusion

Now you know how to calculate the quick ratio using data found on the balance sheet. You also know how to add the formula directly in your spreadsheet and include this ratio in your balance sheet template. With Sheetgo’s AI automations, you can connect the spreadsheets that hold your balance sheet data and keep them in sync on a schedule, so the ratio uses the latest figures. For recurring finance work, Sheetgo’s AI finance virtual employee can collect the figures and keep your ratios up to date.

The quick ratio is one of the various liquidity ratios available. While these ratios are generally good indicators of a company’s financial health, it’s important to interpret them in context and not rely on individual indicators. You can easily set up the formulas for multiple indicators in your spreadsheets. To learn more about these, as well as other financial ratios and analyses, check out the articles below:

● 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...