Technicals · 03
The conventions nobody teaches, then the models that get built.
Formatting rules, the circular reference in every debt schedule, and the two models that come up most: the leveraged buyout and the merger.
- 01Excel for financeFormat a model the way the industry does and trap the errors before someone else finds them.10
- 02Debt schedules and circularityBuild a debt schedule and fix the circular reference two different ways. assumes an earlier lesson11
- 03LBO basicsBuild sources and uses, a paydown schedule, and a returns bridge that adds up. assumes an earlier lesson14
- 04Merger mathCompute accretion and dilution, find the breakeven synergy, and show where the P/E rule fails. assumes an earlier lesson12
Being writtenThe three-statement model, The revenue build, Reviewing a model.