Free DCF model

The Amazon DCF model.

The spreadsheet from the video. Pre-filled with Amazon, so you can see it working on a real company. Change the blue cells, everything else does the maths.

Download it straight away, and you'll join The Notebook, my weekly letter. Unsubscribe anytime.

Change the blue cells

Your assumptions, year by year: the blue input cells

See your value per share and margin of safety

What the business is worth: intrinsic value per share and margin of safety

What's inside

  • Free cash flow built line by line, with a plain-English note on every row.
  • Value per share against today's price, with your margin of safety.
  • A grid showing how two small rates change the answer.

Works in Excel and Google Sheets. The Amazon numbers are my base-case assumptions, not a price target. Educational only, not financial advice. Do your own research.