The 3-Statement and DCF Model Template

Most students can describe a DCF, but in an interview, explaining a model you've just read about sounds very different from explaining one you've actually built.

This is a finished valuation of a sample public company, built in Excel with every formula left visible so you can actively work through it and see how it all works together.

  • Valuation Summary: four methods weighted into one fair value per share, against the market price

  • 3SM: income statement, balance sheet, and cash flow

  • DCF: projections, discounting, terminal value both ways, enterprise to equity

  • Comps and Precedents: built out, not just described in the abstract

If you'd like someone to walk through the model with you, book a free consultation with one of our Wall Street insiders!