Efficiency ratios — also called activity or operations ratios — measure how hard a company’s assets work. Two businesses with the same profit margin can have very different cash needs if one collects from customers in 20 days and the other in 70. This calculator turns a few income-statement totals and average balances into turnover ratios, day counts and the cash conversion cycle.
How to use the efficiency ratios calculator
- Enter net sales and cost of goods sold for the period, and choose the number of days in the period (365, 360, or a 91-day quarter).
- Enter average balances for inventory, accounts receivable, accounts payable, total assets and net fixed assets. Average = (beginning balance + ending balance) ÷ 2.
- Leave any balance blank if you don’t have it; the ratios that need it are skipped.
- The tape leads with the cash conversion cycle; the table lists every ratio with a short reading.
Efficiency ratio formulas
Inventory and payables are measured against cost of goods sold because both are carried at cost; receivables are measured against sales because invoices are issued at selling price.
Worked example
A wholesaler has $1,200,000 of sales and $720,000 of cost of goods sold. Average inventory is $120,000, receivables $150,000 and payables $80,000.
Inventory turnover = 720,000 ÷ 120,000 = 6.0, so DIO = 365 ÷ 6 = 60.8 days
Receivables turnover = 1,200,000 ÷ 150,000 = 8.0, so DSO = 365 ÷ 8 = 45.6 days
Payables turnover = 720,000 ÷ 80,000 = 9.0, so DPO = 365 ÷ 9 = 40.6 days
Cash conversion cycle = 60.8 + 45.6 − 40.6 = 65.9 days
With average total assets of $960,000 the asset turnover is 1.25, and with $400,000 of net fixed assets the fixed asset turnover is 3.0. Every dollar of equipment supports three dollars of sales.
What moves the cash conversion cycle
| Lever | Effect on the cycle | Example |
|---|---|---|
| Faster inventory turns | Shorter DIO | Smaller, more frequent purchase orders |
| Tighter credit terms | Shorter DSO | Net 30 instead of net 45, early-payment discounts |
| Longer supplier terms | Longer DPO | Negotiating net 60 with key vendors |
Cutting the cycle by ten days frees roughly ten days of cost of goods sold in cash. In the example, that is about 720,000 ÷ 365 × 10 ≈ $19,700 released without borrowing a cent.
Reading the numbers carefully
- Use credit sales for DSO when possible. Cash sales never become receivables, so including them makes collections look faster than they are.
- Seasonality skews averages. A toy retailer’s December balance sheet looks nothing like its June one; averaging four quarters is more reliable.
- Stretching payables has limits. A long DPO can mean supplier goodwill is being spent, or that late fees are piling up.
For the other side of short-term health, see the liquidity ratios calculator, and use the profitability ratios calculator to connect asset turnover with return on assets.
Ratios are estimates for analysis and education. Industry benchmarks vary widely; they are not a substitute for professional financial advice.
Frequently asked questions
What is the cash conversion cycle?
It is the number of days between paying suppliers for inventory and collecting cash from customers: days inventory outstanding plus days sales outstanding minus days payables outstanding. A shorter cycle means less money tied up in operations.
Why use average balances instead of year-end balances?
Sales and cost of goods sold accumulate over the whole year, while a balance sheet is a single day. Averaging the opening and closing balances (or the monthly balances) matches the two better, especially for seasonal businesses.
Should I use 365 or 360 days?
Either works if you are consistent. Many corporate analysts use 365; banks and some textbooks use 360 for simpler arithmetic. The choice changes the day counts slightly but not the turnover ratios.
What is a good inventory turnover ratio?
It depends entirely on the industry. Grocery stores often turn inventory 12 to 20 times a year, apparel retailers 4 to 6 times, and heavy equipment dealers 2 to 3 times. Compare against close competitors and your own history.
Can the cash conversion cycle be negative?
Yes. Companies that sell quickly for cash but pay suppliers on long terms, such as large online retailers, can have a negative cycle. Their suppliers effectively finance day-to-day operations.