A liquidity ratios calculator shows whether a company can pay its short-term debts. Enter the current assets, split into cash, securities, receivables, inventory and the rest, and the current liabilities, and it gives the current ratio, the quick ratio and the cash ratio, with a note on what each one means.
How to use the liquidity ratios calculator
- Enter the current assets from the balance sheet, item by item.
- Enter the current liabilities.
- Press Calculate.
Current ratio
The current ratio is current assets divided by current liabilities [1]. A ratio of less than 1 means the firm should pay close attention to the composition of its current assets [1]. Acceptable levels vary by industry [2], and a ratio that is too high may mean that the company holds too much idle cash [3]. The calculator adds the items that you enter to get the current assets.
Quick ratio
The quick ratio, or acid-test ratio, divides the quick assets by the current liabilities [2]. Quick assets are the most liquid current assets, which leave out inventory and prepaid expenses [1]; in the usual case that means cash and cash equivalents, marketable securities and accounts receivable. Inventory is left out because it is the least liquid current asset [2]. A quick ratio below 1 means the company cannot currently pay back all its current liabilities from quick assets.
Reading the quick ratio
An acid-test ratio of at least 1 is preferred, though what is acceptable varies by industry [2]. A software firm that sells on credit may run well below a supermarket chain, which collects cash at the till. Compare the result with firms in the same industry before you draw a conclusion, and look at the trend over several periods.
Cash ratio
The cash ratio is the strictest test: cash and marketable securities divided by current liabilities [3]. Cash and cash equivalents divided by current liabilities is the same idea [1]. It shows how much of the short-term debt could be paid at once from cash. A ratio of 0.35 means that cash covers 35 percent of the current liabilities. Few firms hold enough cash to reach 1, and a ratio under 1 is not always bad [1].
A worked example
Take cash of 50, securities of 20, receivables of 80, inventory of 100 and prepaid expenses of 10, with current liabilities of 200. The current assets are 260, so the current ratio is 1.3. The quick assets are 150, so the quick ratio is 0.75. The cash ratio is 70 divided by 200, which is 0.35. The company passes the current ratio test but is below 1 on the quick ratio, because much of its asset value is in stock. These are our own calculations.
Other liquidity ratios
The quick ratio is a more conservative indication of liquidity than the current ratio, and the cash ratio is more conservative still [3]. The current ratio can be deceptive if much of the current assets is inventory, supplies or prepaid expenses [3]. Comparing a firm with the average of its industry is a better test than a fixed rule [3].
What the ratios miss
A balance sheet is a snapshot. It does not show when the bills are due, whether the receivables will be paid on time or whether the bank will extend a credit line. A company with a ratio above 1 can still run short of cash if the debts fall due before it collects. Use the ratios with the cash flow statement and with the trend over several years.
Using the calculator
Take the figures from the latest balance sheet. Enter each item in the same unit, such as thousands. Leave out items that you do not have, and the calculator treats them as zero. To see the effect of a change, such as collecting receivables faster, change the figure and compare the ratios. A change in inventory moves the current ratio but not the quick ratio.
Improving the ratios
A company can raise its current ratio by collecting receivables faster, by selling stock, by raising long-term finance or by paying down short-term debt. Collecting receivables and selling stock turn assets into cash, which helps the quick ratio too. Taking out a long-term loan to pay a short-term one lowers the current liabilities and so raises both ratios. Use the calculator to test each change before you decide.
For small businesses
Lenders often look at the current ratio when deciding whether to extend credit. A small business can calculate it each month from its books. A falling ratio is an early sign of strain, long before cash runs out. Keep the figures in the same unit, and use the end of the month for all of them.
Common mistakes
- Counting inventory as quick. The quick ratio leaves it out.
- Mixing units. Use one unit throughout.
- Comparing across industries. Acceptable levels differ.
- Using long-term debt. Use current liabilities only.
A second example: a stock-heavy business
Enter cash of 40, receivables of 60, inventory of 150 and prepaid expenses of 10, with no securities, and current liabilities of 125. The current assets are 260, so the current ratio is 2.08, comfortably above 1. The quick assets are only 100, so the quick ratio is 0.8, and the cash ratio is 40 divided by 125, or 0.32.
The calculator explains each figure in words: the current ratio is at or above 1, while the quick ratio is below 1, so the business could not pay all its current liabilities from quick assets today. The gap between the two ratios is the stock. A business like this depends on selling its inventory in time to pay its bills, so check how fast the stock turns over before relying on the current ratio alone.
What next
Use this often? Add Liquidity Ra to your Home screen.
Frequently asked questions
What is a liquidity ratios calculator?
A tool that shows whether a company can pay its short-term debts, using the current, quick and cash ratios.
What is the current ratio?
Current assets divided by current liabilities. Below 1 means the firm should look closely at the make-up of its current assets.
What is the quick ratio?
Cash, marketable securities and receivables divided by current liabilities, or current assets less inventory and prepaid expenses over current liabilities.
What is a good quick ratio?
An acid-test ratio of at least 1 is preferred, though what is acceptable varies by industry.
What is the cash ratio?
Cash and marketable securities divided by current liabilities, the strictest of the three.
Sources
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.