Lesson 9 of 9

Accounting red flags

Step 5 of 7

Your company

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.

  1. 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.
  2. 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%
  1. Add this lesson's two flag checks: receivables and inventory growth against revenue growth.
  2. 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.
  3. 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."