Lesson 10 of 10

Build your first DCF end to end

Step 7 of 7

Go deeper

Watch

Read / use

  • Optional: check against a professional model, Damodaran's simple Ginzu. It opens on Almarai; turn on iterative calculation first. Overwrite the yellow Input-sheet cells with your Costco figures (base year B11–B24; growth 9% in B26, 6.5% in B28; margin 3.85% in B27 and B29; sales-to-capital 6.5 in B31 and B32; Treasury 5.07% in B34). For the cost of capital, set B11 on its Cost of capital worksheet to "I will input" and B12 to 8.6%. To match your long-run growth, set B67 to Yes and B68 to 4% (it defaults to the risk-free rate). There's no check value: it runs ten years, moves tax to the marginal rate and reinvests more after year 10 than your row 19, so it can land above or below you.
  • Costco — FY2026 10-K and the special dividend release — every base-year figure above.

Sources