Knowledge & learning
Accounting & Modeling
Financial statements, forecasts and model building.
Excel template
Equity valuation model
A reusable three-statement model with detailed operating, investing and financing cash flows. It includes four historical years, five forecast years, financial ratios, a DCF and a trading-comparables worksheet for up to 12 peers.
Base, bull and bear cases each have linked financial statements and their own valuation. The workbook also checks balance-sheet and cash-flow reconciliation.
Download the Excel model (.xlsx)Start with Setup, enter historical figures in Actuals, then complete Drivers and the case shifts. Fill Comps with peer data and review Checks before using the valuation. The ReadMe documents input signs, formulas and company-specific adjustments.