Guide · 6 min read

Financial Ratio Analysis Guide

Calculating ratios is the easy half. The marks are for interpreting them: comparing across years and competitors, explaining what caused the change and saying what management should do.

What ratio analysis is for

Raw financial statements are hard to compare. A company with $1 million of profit might be doing brilliantly or poorly depending on its size. Ratios convert statement figures into relationships that can be compared across years, firms and industries. They answer four basic questions: can the business pay its bills (liquidity), does it earn a return (profitability), does it use its assets well (efficiency) and how heavily is it financed by debt (leverage).

A single ratio means little. A ratio becomes meaningful when it is compared with something: the same company in earlier years, competitors, the industry average or a target. Always say what you are comparing against.

The main ratios and their formulas

GroupRatioFormulaWhat it shows
LiquidityCurrent ratioCurrent assets divided by current liabilitiesAbility to meet short-term obligations
LiquidityQuick ratio(Current assets minus inventory) divided by current liabilitiesLiquidity without relying on selling stock
ProfitabilityGross marginGross profit divided by revenueProfit on products before overhead
ProfitabilityOperating marginOperating income divided by revenueProfit from core operations
ProfitabilityNet marginNet income divided by revenueProfit after all costs
ProfitabilityReturn on assets (ROA)Net income divided by total assetsProfit generated per dollar of assets
ProfitabilityReturn on equity (ROE)Net income divided by equityReturn to owners
EfficiencyInventory turnoverCost of goods sold divided by inventoryHow quickly stock sells
EfficiencyReceivable daysReceivables divided by revenue, times 365How long customers take to pay
EfficiencyAsset turnoverRevenue divided by total assetsSales generated per dollar of assets
LeverageDebt ratioTotal liabilities divided by total assetsShare of assets financed by debt
LeverageDebt-to-equityTotal liabilities divided by equityDebt relative to owners' funds
LeverageInterest coverageOperating income divided by interest expenseAbility to pay interest from operations

Textbooks vary on whether to use year-end or average balances for ratios such as ROA. Use whichever your course specifies. The examples below use year-end balances for simplicity.

A worked example: Northline Outfitters

Here are two years of summary figures for a hypothetical retailer, in thousands of dollars.

Income statementYear 1Year 2
Revenue8,0009,200
Cost of goods sold5,2006,210
Gross profit2,8002,990
Operating expenses2,0002,300
Operating income800690
Interest expense100150
Tax at 25 percent175135
Net income525405
Balance sheetYear 1Year 2
Cash400250
Receivables7001,000
Inventory1,3001,900
Total current assets2,4003,150
Non-current assets, net3,0003,400
Total assets5,4006,550
Current liabilities1,2001,800
Long-term debt1,5002,000
Total liabilities2,7003,800
Equity2,7002,750

The ratios, calculated

RatioYear 1Year 2Direction
Current ratio2.001.75Weaker
Quick ratio0.920.69Weaker
Gross margin35.0 percent32.5 percentWeaker
Operating margin10.0 percent7.5 percentWeaker
Net margin6.6 percent4.4 percentWeaker
ROA9.7 percent6.2 percentWeaker
ROE19.4 percent14.7 percentWeaker
Inventory turnover4.0 times3.3 timesWeaker (days of stock: 91 to 112)
Receivable days32 days40 daysWeaker
Asset turnover1.481.40Slightly weaker
Debt ratio50.0 percent58.0 percentMore leveraged
Debt-to-equity1.001.38More leveraged
Interest coverage8.0 times4.6 timesWeaker

As a check on one of them: Year 2 current ratio is 3,150 divided by 1,800, which is 1.75. Year 2 net margin is 405 divided by 9,200, which is 4.4 percent. Show a formula and a worked line like this for each ratio in an assignment, then the table.

Interpreting the results

This is where the marks are. Do not repeat the numbers. Say what story they tell. For Northline:

Sales grew but profit fell. Revenue rose 15 percent, from 8,000 to 9,200, yet net income fell almost 23 percent, from 525 to 405. Growth was bought at a cost.

The cause is margin pressure. Gross margin dropped 2.5 percentage points, which suggests discounting or higher product costs, and operating expenses rose faster than sales, which pushed operating margin from 10.0 to 7.5 percent.

Working capital is absorbing cash. Inventory grew 46 percent and receivables 43 percent, far faster than revenue. Days of inventory rose from 91 to 112 and customers now take 40 days to pay instead of 32. Cash fell from 400 to 250.

Borrowing has increased risk. The debt ratio rose to 58 percent, and interest coverage nearly halved to 4.6 times, so a further profit fall would make debt servicing harder.

Liquidity has weakened. The current ratio of 1.75 is still comfortable, but the quick ratio of 0.69 shows the business depends on selling inventory to pay its bills.

Recommendations. Review pricing and discounting, tighten inventory purchasing, shorten credit terms or chase receivables, and slow the pace of borrowing until margins recover.

Notice the structure: finding, evidence, cause, consequence. That is the pattern to follow for each theme.

Working on this assignment now? Get a price for help with your paper.

Get an instant quote

DuPont analysis: why did ROE change?

The DuPont breakdown splits return on equity into three drivers: profitability, efficiency and leverage.

ROE = net margin x asset turnover x equity multiplier, where the equity multiplier is total assets divided by equity.

DriverYear 1Year 2Effect on ROE
Net margin6.56 percent4.40 percentLarge negative
Asset turnover1.481.40Small negative
Equity multiplier2.002.38Positive, but it raises risk
ROE (product)19.4 percent14.7 percentFell

Year 1: 6.56 percent times 1.48 times 2.00 gives 19.4 percent. Year 2: 4.40 percent times 1.40 times 2.38 gives 14.7 percent. The breakdown shows that falling profitability is the main reason ROE dropped, and that extra borrowing only partly offset it, which makes the business riskier. It is a compact way to show insight.

A practice problem with solution

A company has revenue of 2,000, cost of goods sold of 1,200, operating income of 260, interest expense of 40 and net income of 160. It has current assets of 600 (of which inventory is 250), current liabilities of 400, total assets of 1,600, total liabilities of 800 and equity of 800. Calculate the main ratios and a DuPont check.

RatioWorkingAnswer
Current ratio600 / 4001.50
Quick ratio(600 - 250) / 4000.88
Gross margin(2,000 - 1,200) / 2,00040 percent
Operating margin260 / 2,00013 percent
Net margin160 / 2,0008 percent
ROA160 / 1,60010 percent
ROE160 / 80020 percent
Asset turnover2,000 / 1,6001.25
Debt ratio800 / 1,60050 percent
Interest coverage260 / 406.5 times

DuPont check: net margin 8 percent x asset turnover 1.25 x equity multiplier (1,600 / 800 = 2.0) = 20 percent, which matches ROE. Interpretation in one line: the company earns a solid 20 percent return for owners, with a healthy half of its assets financed by debt that is comfortably covered by operating profit.

Choose a fair benchmark

BenchmarkStrengthLimit
Same company in earlier years (trend)Shows direction and speed of changeDoes not show whether the level is good
CompetitorsShows relative performanceDifferent accounting or business models can distort comparison
Industry averageGives a standard for the sectorAverages hide a wide range of firms
Internal targets or covenantsLinks to decisionsMay not be public

Use at least two benchmarks if you can, and say why they are appropriate. A ratio that looks weak against a competitor may be normal for a business with a different model.

Limits of ratio analysis

Show you understand what ratios cannot do. They rely on historical accounting data and can be affected by accounting policies, one-off items and seasonal timing. Year-end balances may not represent the year, for example a retailer's stock is often highest just after a peak season. Ratios show what happened, not why, and the causes need other evidence from the notes, the market and management. They also cannot capture things such as brand strength or staff quality. A brief comment on limits in your conclusion shows judgment.

  • Show formulas and workings Give the formula once, then at least one worked calculation.
  • Group the ratios Organize by liquidity, profitability, efficiency and leverage.
  • Compare and explain Always say against what, and why it changed.
  • Recommend End with actions supported by the analysis.

For help with a full ratio analysis report, you can order a financial ratio analysis.

Quick answers

Should I use average or year-end balances?

Follow your course. Average balances are theoretically better because they match a full year of flows, but many courses use year-end balances for simplicity. State your choice.

How many ratios should I calculate?

Cover each group (liquidity, profitability, efficiency, leverage) with two or three ratios unless told otherwise. Quality of interpretation matters more than quantity.

What is a good current ratio?

There is no universal answer. Many textbooks cite 1.5 to 2 as comfortable, but it depends on the industry. Compare with peers and with the firm's own history.

Why use DuPont analysis?

It shows whether a change in ROE comes from profitability, efficiency or leverage, which tells you whether the change is healthy or just a result of more borrowing.

Need a hand with your paper?

Tell us the assignment and see your price straight away.

Get an instant quote