The same ratios for the company you picked in Module 5, in your own sheet. There's no single right answer. Expect 60–90 minutes, far longer than a normal exercise.
- Reopen your sheet from Module 4 lesson 06. In a new tab, paste your company's three latest statements from its Interactive Data pages: raw numbers on top, your rows below. Put the years oldest-first, as in Module 4 lesson 06.
- Add these rows, each a formula built from cells:
| Ratio (lesson) | Formula | Usual range |
|---|---|---|
| Revenue growth (01) | this year ÷ last year − 1 | −20% to +50% |
| Margins (02) | gross profit, operating income, net income ÷ revenue | gross > operating, usually > net |
| ROE (03) | net income ÷ average equity | 5–40% |
| ROIC (03) | operating income × (1 − tax rate) ÷ average (equity + debt) | 5–40% |
| Net debt / EBITDA (05) | (debt − cash and short-term investments) ÷ (operating income + D&A) | below 0 to 4× |
| Interest coverage (05) | operating income ÷ interest expense | above 2× |
| Current ratio (05) | current assets ÷ current liabilities | 0.5–3 |
| Cash conversion cycle (06) | DSO + DIO − DPO | −90 to +150 days |
| Cash conversion (07) | operating cash flow ÷ net income | 0.8–1.5 |
| Diluted shares (08) | this year ÷ last year − 1 | −5% to +3% |
- Add this lesson's two flag checks: receivables and inventory growth against revenue growth.
- Outside a range? Check the input first: wrong year column, thousands for millions, a lost minus sign, a second "Total revenue" (lesson 01). If the input is right, the result is real: find the reason in MD&A or the notes and write it beside the number.
- Add one dated line to your notes file: what these numbers changed in your view of the business, if anything.
An illustration, not an answer: Costco, fiscal 2026. You computed most of these in lessons 01–05.
Revenue growth +10.1%
Margins 12.8% gross, 3.9% operating, 3.0% net
ROE / ROIC 28.4% / 22.9%
Net debt / EBITDA −1.1× (net cash: $21.3B against $6.2B of debt)
Interest coverage 80.6×
Current ratio 1.06
Cash conversion cycle +0.3 days (4.8 + 26.7 − 31.2)
Cash conversion 1.71 ← outside the range
Diluted shares −0.1%
The 1.71 is real, not a slip: $2.7B of depreciation is added back, and accounts payable rose $2.8B. The flag check: receivables grew 23.6% against sales' 10.1%, but they're under 5 days of sales. A finished tab: every ratio a formula, every odd result with a one-line reason, and a dated note such as "20 Nov 2026: thin margins, fast turnover, net cash; nothing here changes my view."