Modelling reference
Financial modelling guides
Practical references for the Excel skills and model builds that finance interviews test, written to be checked against a real model.
Excel skills
- Financial model formatting cheat sheetCore conventions for colour, number display, hierarchy and checks.Open guide →
- Advanced custom number formatsSyntax, scaling, literals, colours, conditions and tested examples.Open guide →
- Investment banking Excel shortcutsA print-friendly Windows and macOS keyboard reference.Open guide →
- Common Excel modelling errorsHardcodes, signs, broken links, references, copied formulas, formatting, checks and sensitivities.Open guide →
Model builds
- Building a DCFForecast structure, unlevered free cash flow, WACC, terminal value and the equity bridge.Open guide →
- Three-statement modellingStatement links, working capital, PP&E, the cash flow statement, debt and balance checks.Open guide →
- Operating modelForecast structure, revenue build, cost structure and margins, capex, working capital drivers and scenarios.Open guide →
- LBO modellingSources and uses, financing structure, the debt schedule, the cash sweep, exit assumptions and returns.Open guide →