Lesson 6 of 6

The analyst's spreadsheet

Step 4 of 6

Do it yourself

Small and practical. Do it now while it is fresh.

About 15 minutes:

  1. Open a blank Google Sheet. Type the Apple table above into rows 1–2, revenue numbers in blue.
  2. Add the YoY formula in C3 and drag it right. Check your answers match.
  3. Add the CAGR in B4 both ways (^(1/4) and RRI). They should agree.
  4. Now do the same for Costco. Open Costco's income statement page from its FY2026 10-K. (The income statement is the table of a year's sales, costs and profit; Module 3 explains it.) The top line, Total revenue, shows three fiscal years, newest on the left. Type them into a new row with the oldest on the left: FY2024, FY2025, FY2026.
  5. Add the YoY growth for FY2025 and FY2026, and the CAGR. Three years means two gaps, so use 2 periods.

Optional, for later: Module 5, lesson 01 shows how to find any company's 10-K. Each shows three years of revenue, so five years needs two.

Show answers

Costco total revenue ($ millions): FY2024 254,453, FY2025 275,235, FY2026 303,154.

YoY: 275,235 ÷ 254,453 − 1 ≈ +8.2%, then 303,154 ÷ 275,235 − 1 ≈ +10.1%. CAGR = (303,154 ÷ 254,453)^(1/2) − 1 ≈ 9.2% a year.

If your growth came out negative (about −9.2% and −7.6%), your years are in the wrong order: newest on the left, as the SEC page shows them.

That's the end of Module 2. You can now grow money forward, discount it back, measure returns and risk, think in scenarios, and do it all in a sheet. Next lesson: Accounting is the language of business, the start of Module 3.