EXCEL WORKBOOK
Buying a company with borrowed money
A detailed LBO model (leveraged buyout: a company purchase funded with investor money and loans). Work through a fictional company’s purchase, business forecast, loan repayments and sale. The formulas are linked so you can change an assumption and see the effect.
- A working five-year model with profit, cash flow and balance-sheet calculations.
- Separate loan calculations, tax assumptions, fees, management payments and investor returns.
- A detailed build guide with cell references, worked explanations, mistakes to avoid and exercises.
- A formula map, definitions, model checks and editable price comparisons.
Made-up practice figures. Read the workbook’s stated assumptions before changing them. Open in Microsoft Excel with automatic calculation enabled.