How LBO Model Builder Works
The LBO Model Builder constructs a leveraged buyout financial model that calculates investor returns based on the acquisition structure, debt paydown schedule, and exit assumptions. It is the standard analytical framework used by private equity firms to evaluate potential acquisitions and determine the maximum price they can pay while achieving target returns.
The tool walks you through building the three core components of an LBO model. First, the sources and uses of funds — how the acquisition is financed through a combination of debt tranches (senior, mezzanine, subordinated) and equity from the sponsor. Second, the operating model — projecting revenue growth, EBITDA margins, and free cash flow generation over a typical 5-7 year hold period. Third, the debt schedule — modeling mandatory amortization, cash flow sweeps, and optional prepayments to show how leverage decreases over time.
With these inputs, the model calculates the internal rate of return (IRR) and multiple of invested capital (MOIC) under your base case assumptions. The IRR captures the annualized return to the equity sponsor, while MOIC shows the total cash-on-cash multiple. Most PE firms target a minimum 20-25% IRR or 2.0-3.0x MOIC.
The sensitivity analysis feature lets you flex key assumptions — entry multiple, exit multiple, revenue growth, and leverage ratio — to understand which variables drive returns most. This reveals whether a deal is primarily a "multiple expansion" story, an "operational improvement" story, or a "deleveraging" story. Use it alongside the Cap Table Calculator for equity structuring or the Comparable Company Analysis (Comps) tool to validate entry and exit multiple assumptions.
Key Terms Explained
- Internal Rate of Return (IRR)
- The annualized effective compounded return rate earned by the private equity sponsor on their invested equity, accounting for the timing and magnitude of all cash flows.
- Multiple of Invested Capital (MOIC)
- The total cash returned to the equity investor divided by the total equity invested, representing the gross cash-on-cash return without regard to time.
- Debt Service Coverage Ratio
- Operating cash flow divided by total debt service (interest plus mandatory principal payments), measuring the company's ability to meet its debt obligations.
- Leveraged Buyout
- An acquisition strategy where a significant portion of the purchase price is financed with debt, using the target company's cash flows to service and repay that debt over time.
- Exit Multiple
- The EV/EBITDA multiple at which the private equity sponsor sells the company, a critical assumption that heavily influences the projected IRR.
Who Needs This Tool
Building a quick LBO model during a deal screening process to determine if a target company can support enough leverage to achieve the fund's 25% IRR hurdle rate.
Running an LBO analysis as part of a sell-side pitch to demonstrate what price financial sponsors could afford to pay for the client's business.
Practicing LBO modeling for private equity recruiting by building models on real companies and testing sensitivity to key assumptions.
Evaluating whether a division spinoff to a PE buyer would generate a higher valuation than a strategic sale by modeling what PE firms could pay.
Stress-testing a leveraged loan by modeling downside scenarios to determine if the borrower can maintain debt service coverage ratios above covenant thresholds.
Methodology & Formulas
IRR is calculated as the discount rate that sets the net present value of the equity sponsor's cash flows (initial investment plus any dividends minus the exit equity value) to zero. Exit equity value equals the projected exit-year EBITDA multiplied by the exit multiple, minus net debt remaining at exit. Debt paydown follows a waterfall: mandatory amortization first, then excess cash flow sweeps (typically 50-75% of excess cash), with remaining cash building on the balance sheet. Leverage ratios (Debt/EBITDA) are tested against typical covenant levels at each period.
Pro Tips
- Start with the debt capacity analysis — determine maximum leverage by ensuring minimum 1.5x debt service coverage in your downside case, then work backward to the equity check.
- Model at least three scenarios (base, upside, downside) and pay attention to which assumptions must hold for the deal to meet minimum returns in the downside case.
- Remember that IRR is highly sensitive to hold period — a 2.5x MOIC over 3 years is a 36% IRR, but over 6 years it's only 16%. Time kills IRR.
- Include management rollover equity and any co-invest from LPs separately to properly calculate the fund-level versus gross deal-level returns.
- Validate your exit multiple assumption by checking current trading multiples and historical transaction multiples in the sector using comparable company analysis.