Consumer Electronics sample workbook

AAPL DCF Excel model

A mature-company DCF starter workbook emphasizing buyback-like cash generation, terminal value, and downside cases.

Inside the workbook

  • Editable assumptions tab
  • Income statement, balance sheet, and cash flow forecast
  • WACC and DCF valuation tabs
  • Scenario analysis, sensitivity tables, tornado chart, and Monte Carlo tab

Important note

This is a starter sample for education and research. It uses simplified assumptions and public-company framing. Review and adjust assumptions before relying on any output.