Comprehensive Excel LBO Model Build
Budget: £20 – £250 GBP
I’m looking for a well-structured leveraged buy-out model in Excel that I can drop straight into an investment memo. The core aim is to test a potential deal, so accuracy and transparency are critical.
Here’s what I must be able to pull from the file:
• Internal Rate of Return (IRR) calculated at both deal and equity levels
• Annual cash-flow projections that flow cleanly from revenue to free cash flow
• A clear debt amortisation and repayment schedule that ties back to the cash waterfall
I prefer the workbook to be colour-coded with conditional formatting so the key drivers and assumptions stand out, and any hard-coded inputs can be distinguished from formulas at a glance. Everything should remain editable—no hidden cells or locked tabs—so I can tweak scenarios later.
Please structure the model logically (assumptions → statements → returns), label every section, and keep circular references under control. A quick walk-through video or concise user notes would be appreciated so I can hand it off internally without a hitch.
If you’ve built buy-out files before and can turn this around promptly, let’s get started.
Here’s what I must be able to pull from the file:
• Internal Rate of Return (IRR) calculated at both deal and equity levels
• Annual cash-flow projections that flow cleanly from revenue to free cash flow
• A clear debt amortisation and repayment schedule that ties back to the cash waterfall
I prefer the workbook to be colour-coded with conditional formatting so the key drivers and assumptions stand out, and any hard-coded inputs can be distinguished from formulas at a glance. Everything should remain editable—no hidden cells or locked tabs—so I can tweak scenarios later.
Please structure the model logically (assumptions → statements → returns), label every section, and keep circular references under control. A quick walk-through video or concise user notes would be appreciated so I can hand it off internally without a hitch.
If you’ve built buy-out files before and can turn this around promptly, let’s get started.