LBO Model Generator

Generate a lightweight acquisition model and export an Excel workbook with operating assumptions, debt paydown, cash flow, and investor return schedules.

Build an acquisition workbook

Enter a few high-level deal assumptions and download a structured Excel file for reviewing purchase price, debt capacity, operating forecast, cash flow, and sponsor returns.

  • Business type presets seed growth, margin, capex, and working capital assumptions.
  • The workbook includes sources and uses, income statement, balance sheet, cash flow, debt schedule, initiatives, and returns tabs.
  • Inputs are intentionally broad so the first pass stays fast, then you can refine the workbook in Excel.

How to use the output

Treat the exported workbook as a first-pass deal screen, not a finished investment memo. The default assumptions help you frame whether a purchase multiple and leverage level are broadly workable before you spend time on detailed diligence.

Inputs to revisit in Excel

After export, review revenue growth, gross margin, fixed cost leverage, working capital days, capex, tax rate, interest rate, and exit multiple. Small changes in those assumptions can materially change debt paydown and investor IRR.

Model export guide

How to use the LBO model generator

The LBO model generator creates a structured Excel-ready model from a smaller set of operating and deal assumptions. Use it when you need a downloadable starting point for diligence, lender discussions, or investor review.

What the export includes

The model export organizes revenue, margin, operating costs, cash flow, debt paydown, and investor return calculations. That gives you a cleaner starting point than a blank spreadsheet.

You should still customize the output for the specific deal, especially if the business has seasonality, working-capital swings, multiple debt tranches, or unusual capex.

How to set assumptions

Use conservative sales, margin, and growth assumptions first. A model that works only with perfect execution is too fragile for debt.

Then run upside cases separately so you can see whether the extra return comes from realistic improvement or just aggressive assumptions.

The method is to separate operating performance from deal structure: first prove the business can create cash, then decide how much leverage that cash flow can support.

Worked example

If a business starts with $50 million in sales and modest growth, the model can show how EBITDA, cash flow, debt balance, and equity value evolve over the hold period.

The key output is not only IRR. Look at debt paydown, cash flow coverage, and exit value dependence.

What to review before sharing

Check formulas, assumptions, debt terms, tax rate, exit multiple, and working-capital treatment before sending the file to anyone else.

A clean model should make assumptions visible so the discussion focuses on business risk instead of spreadsheet mechanics.

Frequently asked questions

Is the export a complete diligence model?

No. It is a structured starting point. Add deal-specific schedules, monthly detail, covenant calculations, and diligence support as needed.

What output matters most?

IRR and multiple of money matter, but debt service coverage, free cash flow, and exit multiple sensitivity are often more important for risk.

Should I model a downside case?

Yes. A downside case shows whether the business can survive lower growth, margin pressure, or a weaker exit.

Can I use this for SBA deals?

You can use it as a first-pass model, but SBA structures need loan-specific terms, fees, covenants, and lender requirements.