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!