BALANCECHEAT / VALUATION
LBO Model & Sponsor Returns
Explore how entry price, leverage, cash generation and exit assumptions determine sponsor MOIC and IRR. Build a transparent first-pass leveraged buyout.
Loading valuation tool…
Open the full valuation model
Continue in the full financial model with independent periods, scenarios, adjustments and detailed valuation assumptions.
A return model for an equity investor
A leveraged buyout model measures returns to a sponsor that funds part of an acquisition with debt. It is not an intrinsic valuation method. The same business can generate different sponsor returns under different purchase prices, financing terms, ownership structures and exit dates.
The compact tool uses explicit illustrative assumptions for entry multiple, debt, interest and exit. It links cash generation to an operating forecast and sweeps available cash to debt. The full workspace expands this into transaction fees, rollover equity, multiple tranches and independent entry and exit years.
Reconcile sources and uses
Uses include equity purchase price, refinancing existing debt, transaction fees, financing fees and other transaction requirements. Sources include new debt, sponsor equity, management rollover and other funding. Sponsor equity balances the funding equation only when it remains positive and all sources and uses are explicitly included.
Do not confuse enterprise purchase value with the amount paid to equity holders. Cash, existing debt and other claims create the bridge. Whether existing cash remains in the business and how much minimum cash must be funded affects the transaction economics.
Model debt and cash generation
Debt tranches can have different cash interest rates, PIK rates, mandatory amortization, maturity and cash-sweep priority. Cash interest reduces available liquidity; PIK adds to debt principal rather than consuming current cash. Mandatory amortization comes before discretionary cash sweep.
The model uses opening balances for annual cash interest, then capitalizes PIK and pays required principal. Excess cash above the minimum balance is applied to participating tranches in priority order. These annual conventions must be understood when comparing with a monthly financing model.
Minimum cash and funding shortfalls
A cash sweep cannot repay more than available cash or outstanding principal. Retaining minimum cash reduces discretionary paydown. If operations or a debt maturity create a funding deficit, an attractive calculated IRR is not a funded investment case.
BalanceCheat flags the shortfall and withholds IRR and MOIC until the assumptions support the required payments. Revisit entry financing, maturity, amortization or cash generation. Do not solve the problem by allowing unexplained negative cash or silently inventing refinancing proceeds.
Calculate exit proceeds and returns
Exit enterprise value equals the selected exit operating metric multiplied by the exit multiple. Subtract remaining debt and other claims, add cash and appropriate assets, and deduct exit fees to obtain equity proceeds. Apply sponsor ownership after management rollover or an explicitly chosen ownership assumption.
MOIC equals sponsor proceeds plus interim distributions divided by sponsor equity invested. IRR also accounts for timing. A 2× return in three years is economically different from a 2× return in seven years. Interim distributions may improve IRR without changing total value created.
Identify what drives the investment case
Separate operating growth, margin expansion, debt paydown and multiple change. A return case that depends primarily on a higher exit multiple is different from one supported by cash generation at an unchanged multiple. Test entry price and downside operating assumptions before relying on a single headline return.
The full model exposes stable sponsor IRR and MOIC outputs for scenario comparison. It does not solve a reverse LBO target automatically. Use DCF and comparable methods to assess business value separately from the return a particular financing package can produce.