Financial Ratios Calculator: Liquidity and Profit Ratios

Financial Ratios Calculator Inputs You Need

Every ratio on this page comes from your financial statements, so gathering the inputs is the only real work. You need eleven figures, pulled from two reports for the same period: The free payback period calculator is free to use with no sign-up, and works on desktop and mobile.

• From the balance sheet: total current assets, total current liabilities, total long term assets, total long term liabilities, accounts receivable and inventory.
• From the income statement: sales (also called net sales or total revenue), cost of goods sold, operating expenses, interest expense and any other income.

The calculator then derives the rest for you. Gross profit is sales minus cost of goods sold. Operating income is gross profit minus operating expenses, which is close to earnings before interest and tax (EBIT). Your net income before taxes adds other income and subtracts interest expense. Total assets is current assets plus long term assets, and total liabilities adds current liabilities to long term liabilities.

Use figures from the same period for both reports. Mixing a year-end balance sheet with a single quarter of sales will understate every ratio that divides one by the other, and the result will mislead you rather than inform you.

Formulas Behind the Ten Ratios

Each ratio is a simple division, and the formula for each one is shown below so you can check the result by hand.

Liquidity Ratios and the Ratio Calculator

Liquidity ratios answer the question lenders ask first: when your short-term bills come due, will there be enough cash and near-cash to pay them? Profitable companies fail when they run short of cash at the wrong moment, which is why liquidity gets checked before anything else. The debt service coverage ratio dscr calculator uses the same plain-English approach, so you can compare results side by side.

Current Ratio

The current ratio divides what you own that turns into cash within a year by what you owe within the same year:

$$\text{Current ratio} = \frac{\text{Current assets}}{\text{Current liabilities}}$$

Current assets include cash, accounts receivable, inventory and prepaid expenses. Current liabilities include accounts payable, accrued wages, taxes payable and the portion of long term debt due this year. A current ratio of 1.0 or higher is generally acceptable, because it means your short-term resources at least match your short-term obligations. A current ratio near 2.0 is a common rule of thumb, though the right level varies by industry. Far above 2.0 can signal capital sitting idle in stock or cash, and below 1.0 signals trouble covering short term liabilities.

Quick Ratio

The quick ratio, also called the acid test, strips inventory out of the numerator because stock is the slowest current asset to convert into cash:

$$\text{Quick ratio} = \frac{\text{Current assets} - \text{Inventory}}{\text{Current liabilities}}$$

A quick ratio between 0.5 and 1.0 is usually considered acceptable, and anything under 0.5 raises the risk of running out of cash. When your current ratio looks healthy but your quick ratio is thin, your liquidity depends on selling inventory at a decent price.

Working Capital

Working capital turns the same comparison into a dollar figure: current assets minus current liabilities. Where the working capital ratio tells you how many times you cover your bills, the dollar amount tells you how much room you have to fund growth, a new hire or a slow month without borrowing.

Profitability Ratios in Financial Ratios and Calculators

Profitability ratios show how much of every sales dollar survives each layer of cost. Most tools present three margins, each one deducting a further layer of expense.

Gross Profit Margin

$$\text{Gross profit margin} = \frac{\text{Gross profit}}{\text{Net sales}} \times 100$$

Gross profit is what remains after the cost of goods sold, meaning the materials, supplies and direct labor behind what you sell. The gross profit margin tells you whether your pricing covers production at the most basic level. If it stays low, no amount of volume or efficiency elsewhere will rescue the business.

Operating Profit Margin

$$\text{Operating profit margin} = \frac{\text{Operating income}}{\text{Sales}} \times 100$$

This margin deducts operating expenses such as rent, payroll and marketing, and it ignores interest and taxes. It is the cleanest read on how efficiently the business runs before any financing decision enters the picture, so it is the best margin for comparing two companies with different debt loads.

Net Profit Margin

$$\text{Net profit margin} = \frac{\text{Net income}}{\text{Sales}} \times 100$$

Often called the bottom line, the net profit margin counts everything, including interest expense. The net profit figure that results is what is left for owners to reinvest or take home. A margin around 10% is often cited as average, but it moves a lot between industries.

Return on Assets

$$\text{Return on assets} = \frac{\text{Net income}}{\text{Total assets}} \times 100$$

Return on assets shows how well the buildings, equipment, stock and cash you own are generating profit. It lets you compare two businesses of very different sizes on the same footing, and it is one of the first numbers an investor checks, and a bank assessing a business credit application checks it too. Its close relative, return on equity, divides net income by shareholders' equity instead, so it also rewards the use of borrowed money.

Financial Ratios for Efficiency and Leverage

Operating efficiency and leverage ratios complete the picture. The first group asks how hard your assets are working, and the second asks how much of the business is financed by lenders rather than owners.

Inventory Turnover

$$\text{Inventory turnover} = \frac{\text{Cost of goods sold}}{\text{Inventory}}$$

This turnover ratio counts how many times you sell through your stock in a period. A higher number generally means leaner use of capital, while a low number means cash is parked on shelves. Dividing 365 by the result gives the average days a product sits before it sells.

Sales to Receivables

$$\text{Sales to receivables} = \frac{\text{Net sales}}{\text{Receivables}}$$

This ratio shows how many times your accounts receivable turned over. The higher it is, the faster customers pay you, which feeds directly into cash flow. Compare it with your industry average and with your own payment terms before drawing conclusions.

Debt Ratio and Debt to Worth Ratio

The debt to worth ratio divides total liabilities by your net worth (total assets minus total liabilities). It is the same idea as debt to equity: a result of 1.0 means lenders and owners have funded the business equally. A broader debt ratio divides total liabilities by total assets instead. Higher leverage amplifies gains in good years and losses in bad ones, and lenders weigh it heavily. Related measures such as interest coverage compare earnings before interest and tax with interest expense to show how comfortably you can service what you owe.

Two other efficiency measures, accounts payable days and operating expenses to sales, are not among the ten results this calculator returns, but you can work them out from the same inputs.

Checking a Loan Covenant with Financial Ratios and Calculators

Priya Nandakumar owns a taproom and brewery, and her bank has offered a $140,000 equipment loan on one condition: a current ratio of at least 1.25 and a debt to worth ratio of no more than 2.5 at the last quarter's close. Before signing, she opens the balance sheet and keys the figures into the calculator.

She enters current assets of $214,380 (including $61,450 of inventory, mostly grain and kegged beer) and current liabilities of $183,920. Total liabilities are $612,700 against total assets of $905,300, which leaves a net worth of $292,600.

The results come back at once. Her working capital ratio, the same figure as the current ratio, is 1.17, below the 1.25 covenant. The quick ratio is 0.83, inside the 0.5 to 1.0 band lenders usually accept. Debt to worth is 2.09, safely under 2.5. One number fails, and the calculator shows exactly which.

The next question is what to change. Priya has $78,200 of cash on the balance sheet, so she tries paying down her revolving credit line. Solving the current ratio formula for the payment, she needs to retire at least $62,080 of short term debt, since the same amount leaves both current assets and current liabilities. She reruns the calculator with $63,500 paid: current assets fall to $150,880, current liabilities to $120,420, and the current ratio rises to 1.25. Debt to worth improves to 1.88. The quick ratio slips to 0.74, still above 0.5, and working capital drops to $30,460, a real cost she weighs against the loan.

Armed with those numbers, she repays the line before quarter-end and brings the rerun results to the bank, rather than discovering the shortfall during underwriting.

Worked Example with the Ratio Calculator

Take Harbor Lane Hardware, a single-location shop reporting a full year. Here are the figures entered into the calculator:

From those inputs, gross profit is $471,500, operating income is $153,300 and net income before taxes is $138,700. Total assets come to $794,800, total liabilities to $406,200 and net worth to $388,600. The results:

Reading them together tells a clear story. The shop is comfortably liquid, with $2.49 of current assets for each $1.00 of current liabilities, but more than half of its current assets ($187,900 of $356,200) is inventory, and a turnover of 4.32 means stock takes about 84 days to sell. Customers pay in roughly 32 days. Leverage is balanced, with $1.05 owed for every $1.00 of owner equity.

Expressing Every Ratio as a Percentage of Revenue

The three margin results are each a percentage of total revenue. In the Harbor Lane example, $1,284,000 of revenue yields 36.72 cents of gross profit per dollar, 11.94 cents of operating income and 10.80 cents of pre-tax net income. Stating margins this way lets you compare a strong year with a slow one even when revenue swings, because the formula strips out the scale.

Common Mistakes When Running the Numbers

• Mismatched periods. Use the same formula inputs from one reporting period, never a monthly sales figure beside an annual balance.
• Counting the wrong items. Move the portion of long term debt due within a year into short-term obligations, or your liquidity will look better than it is.
• Ignoring seasonality. A business that stocks up before a busy season will show a lower turnover and a higher inventory balance at year end than its average month.
• Reading one ratio alone. Each formula answers a single question, so judge the business on the whole set, not on the best-looking figure.
• Skipping the trend. A ratio that falls two quarters in a row matters more than one that sits slightly below a rule of thumb.

Rerun the calculator whenever a new loan, product line or change in supplier terms alters your inputs, so your business credit picture stays current.

Reading Results Against Your Industry

No ratio means much in isolation. Compare your current ratio and net profit margin with a published benchmark for your sector, with your own prior periods and with direct competitors where figures are available. Professional services firms often show gross margins above 80%, while construction and manufacturing sit well below that. Track each ratio monthly or quarterly so a trend appears before it becomes a crisis, and ask your accountant which targets fit your situation. Lenders and investors will run these same numbers, so knowing them first lowers your risk of surprises with the bank.