Ratios turn financial statement amounts into comparisons across years and companies. This lesson covers the margin and return ratios that measure profitability and the working capital ratios that measure short-term liquidity and how fast cash cycles through receivables, inventory and payables.
Ground rules
- Pair a flow with a flow, or a flow with the average of a balance. Income statement amounts cover a year, so divide them by the average of the opening and closing balance sheet amounts when both are given.
- Definitions vary between analysts and loan agreements. On the exam, use the definition the question gives; if it gives none, use the standard one below.
- If a question gives only year-end balances, use them.
- A ratio means little alone. Compare it with the company's past, its competitors and any covenant it must meet.
Profitability: margins and returns
| Ratio | Formula |
|---|---|
| Return on assets | Net income / average total assets |
| Return on common equity | (Net income - preferred dividends) / average common equity |
| Net margin (return on sales) | Net income / sales |
| Operating margin | Operating income / sales |
| Gross margin | (Sales - cost of goods sold) / sales |
Returns compare profit with the resources used to earn it. Margins measure how much of each sale survives each layer of cost. Some analysts add back after-tax interest when computing return on assets, so that the measure isn't affected by how the assets were financed; use that only when a question asks for it.
Liquidity and the operating cycle
| Ratio | Formula |
|---|---|
| Inventory turnover | Cost of goods sold / average inventory |
| Days in inventory | 365 / inventory turnover |
| Receivables turnover | Net credit sales / average net receivables |
| Days sales outstanding | 365 / receivables turnover |
| Days payable outstanding | Average accounts payable / cost of goods sold x 365 |
| Current ratio | Current assets / current liabilities |
| Quick (acid-test) ratio | (Cash + marketable securities + net receivables) / current liabilities |
Days in inventory plus days sales outstanding, minus days payable outstanding, is the cash conversion cycle: how long cash is tied up in operations. Some analysts compute days payable on purchases rather than cost of goods sold; use whatever the question states. The quick ratio leaves out inventory and prepaid items, because neither turns into cash quickly enough to pay current debts.
A transaction's effect on the current ratio depends on where the ratio starts. Paying a supplier with cash takes the same amount off both sides, which raises a ratio above 1 and lowers one below 1. Buying inventory on credit adds the same amount to both sides, which lowers a ratio above 1, while working capital stays the same in both cases.
Worked example
A wholesale bakery sells to grocery stores on credit. For the year: sales 6,000,000; cost of goods sold 3,900,000; operating expenses 1,500,000; interest 80,000; income tax 130,000; net income 390,000. Average total assets were 3,900,000 and average equity (all common) 2,600,000. At year end: cash 150,000, receivables 240,000 (260,000 a year earlier), inventory 210,000 (180,000), prepaid items 30,000 and current liabilities 500,000. Accounts payable went from 300,000 to 340,000.
- Return on assets 390,000 / 3,900,000 = 10%; return on equity 390,000 / 2,600,000 = 15%.
- Net margin 390,000 / 6,000,000 = 6.5%; operating margin 600,000 / 6,000,000 = 10%; gross margin 2,100,000 / 6,000,000 = 35%.
- Inventory turnover 3,900,000 / 195,000 = 20, or 18.25 days.
- Receivables turnover 6,000,000 / 250,000 = 24, about 15.21 days.
- Days payable 320,000 / 3,900,000 x 365 = about 29.95 days.
- Current ratio 630,000 / 500,000 = 1.26; quick ratio 390,000 / 500,000 = 0.78.
The cash conversion cycle is about 18.25 + 15.21 - 29.95 = 3.51 days, or about 3.5: suppliers finance almost the whole cycle.
On the exam
Return on common equity subtracts preferred dividends and leaves preferred equity out of the denominator. Use averages for return and turnover ratios when both balances are given, cost of goods sold for inventory turnover, and credit sales for receivables turnover. The quick ratio excludes inventory and prepaid items.