# LBO Model & Debt Schedule Calculator Evaluate leveraged buyout returns, debt payoff schedules, multiple of invested capital, and internal rate of return metrics. --- - **Canonical URL:** https://dothecalculation.com/calculators/lbo-model - **Category:** Financial calculators - **Publisher:** Do The Calculation (https://dothecalculation.com) - **Cost:** Free, no account or sign-up required - **Privacy:** Runs entirely in the browser; inputs are never sent to a server - **Methodology:** https://dothecalculation.com/methodology --- ## LBO Model & Debt Schedule Calculator — Sponsor IRR and MOIC Model sponsor equity requirements, debt paydown schedules, interest payments, cash sweeps, and exit returns (IRR and MoIC) for a leveraged buyout. - Custom debt financing tranches - Dynamic debt schedules with cash sweeps - Internal Rate of Return (IRR) & Multiple on Invested Capital (MoIC) metrics ## How to Use This Calculator Enter the target's entry EBITDA, the purchase multiple (EV/EBITDA), the percentage of the purchase price funded with debt, the debt's interest rate, your assumed exit multiple, expected annual EBITDA growth, and the holding period in years. The calculator builds the entry sources-and-uses, runs a year-by-year debt schedule that sweeps free cash flow against the debt balance, and calculates the sponsor's equity value at exit, MOIC, and IRR. ## Worked Example: $10M EBITDA, 8x Entry, 60% Leverage Entry EBITDA $10,000,000, 8.0x purchase multiple, 60% debt funding, 7.5% debt interest rate, 9.0x exit multiple, 5% annual EBITDA growth, 5-year holding period. Entry enterprise value: $10,000,000 × 8.0 = $80,000,000. Initial debt: $80,000,000 × 60% = $48,000,000. Sponsor equity check: $80,000,000 − $48,000,000 = $32,000,000. EBITDA grows from $10,000,000 to roughly $12,762,816 by year 5 at 5% annual growth. Free cash flow each year sweeps against the debt balance, paying it down from $48,000,000 to roughly $17,829,612 by exit. Exit enterprise value: $12,762,816 × 9.0 ≈ $114,865,341. Sponsor exit proceeds (after repaying remaining debt): $114,865,341 − $17,829,612 ≈ $97,035,729. MOIC: $97,035,729 ÷ $32,000,000 ≈ 3.03x. IRR: 3.03x compounded over 5 years ≈ 24.84% annualized — comfortably inside the 20% to 25% IRR range sponsors typically target, driven by a combination of debt paydown, EBITDA growth, and a full turn of multiple expansion (8.0x entry to 9.0x exit). ## Understanding Leveraged Buyouts (LBOs) A Leveraged Buyout (LBO) is the acquisition of a company by a private equity sponsor, financed using a significant portion of debt (typically 50% to 80% of the purchase price). The cash flows of the acquired business are used to service the debt and pay down the principal over the investment horizon (usually 3 to 7 years). Value is created in an LBO through three primary channels: paying down debt using operational cash flows (which increases equity value relative to enterprise value), operational improvements that grow EBITDA, and multiple expansion (selling the company at a higher multiple than the acquisition multiple). ## Sources and Uses of Funds The foundation of any LBO model is the Sources and Uses table. It outlines the total capital required to execute the deal (Uses) and how that capital is raised (Sources). **Uses of Funds** include the purchase price of the target (Enterprise Value), transaction fees (investment banking, legal, accounting), and financing fees (costs to arrange debt financing). **Sources of Funds** outline the debt tranches (Senior Secured Bank Debt, Mezzanine Debt, High-Yield Bonds) and the remaining balancing figure, which is the Sponsor Equity contribution. ## Debt Paydown and Cash Sweep Mechanics During the holding period, the target company's operating cash flow is directed toward debt service. A cash sweep is a contract term requiring that any cash remaining after meeting operating expenses, taxes, CapEx, and mandatory debt amortization be used to prepay outstanding principal. The order of repayment follows the debt seniority: Senior Secured Debt is repaid first, followed by subordinated tranches. Mandatory amortization is paid first, then discretionary prepayments (sweeps) are applied. ## Calculating LBO Returns: IRR and MoIC Sponsor returns are measured using two primary metrics: Internal Rate of Return (IRR) and Multiple on Invested Capital (MoIC). **Multiple on Invested Capital (MoIC)** measures the total return relative to the initial equity check: $$\text{MoIC} = \frac{\text{Sponsor Equity at Exit}}{\text{Sponsor Equity at Entry}}$$ **Internal Rate of Return (IRR)** calculates the annualized geometric rate of return on the investment over the holding period \(t\): $$\text{IRR} = (\text{MoIC})^{\frac{1}{t}} - 1$$ A typical private equity sponsor targets a 20% to 25% IRR and a 2.0x to 3.0x MoIC. ## Related Calculators Cross-check the entry valuation with the [DCF calculator](/calculators/corporate-valuation-dcf-calculator), and once the sponsor exits, run the deal's cash-on-cash return through the [ROI calculator](/calculators/roi-calculator). ## Frequently asked questions ### What makes a company a good candidate for an LBO? Ideal LBO targets have stable and predictable cash flows to service debt, low CapEx requirements, strong management teams, valuable assets for collateral, and clear operational improvement opportunities. ### Why do private equity firms use leverage? Leverage boosts investment returns. By using borrowed money to cover the majority of the purchase price, the sponsor reduces the amount of their own equity capital required, boosting the IRR when the company is sold. ### What is a Cash Sweep? A cash sweep is a lending agreement covenant that requires the borrower to use excess free cash flow to pay down outstanding debt principal early, reducing credit risk for lenders. ### How do you calculate sponsor equity at exit? Sponsor equity at exit is calculated as Exit Enterprise Value minus Remaining Debt plus Cash at the time of sale. This represents the equity portion available to the sponsor. ### What is the relationship between holding period and IRR? IRR is sensitive to time. A shorter holding period yields a higher IRR for the same MoIC. Conversely, as the holding period lengthens, the sponsor must achieve a much larger absolute MoIC to maintain the same annualized IRR. ### What is the difference between Senior Debt and Subordinated Debt? Senior debt has first priority on cash flow and assets in a default, and usually carries a lower interest rate. Subordinated debt is junior in repayment priority, riskier, and carries a higher interest rate, often with PIK (payment-in-kind) features. ### What is PIK interest? Payment-in-Kind (PIK) interest is interest that is paid by adding the accrued interest amount directly to the outstanding principal balance of the loan, rather than paying it in cash during the period. ### How does EBITDA growth impact LBO returns? EBITDA growth increases the enterprise value at exit, which flows directly to the equity holders. It also increases cash flow during the holding period, allowing faster debt paydown. ### What is a typical leverage ratio in an LBO? Leverage is typically measured as Net Debt to EBITDA. Historical averages range from 4.0x to 6.0x Debt/EBITDA, depending on credit market conditions and the stability of the target business. ### What are transaction fees in an LBO? Transaction fees are the advisory, underwriting, legal, and accounting costs incurred to execute the buyout. They are capitalized or expensed at entry, increasing the total uses of funds. ## Related concepts - **IRR** — Internal Rate of Return, the annualized rate of return on capital invested. - **MoIC** — Multiple on Invested Capital, measuring total return multiple. - **Sponsor Equity** — The cash check written by the private equity firm to execute the buyout. ## Related guides - [Business Valuation Methods: A Practical Owner Guide](https://dothecalculation.com/blog/business/business-valuation-methods) — Compare market, income, and asset valuation methods, normalize revenue and profit, and use multiples as a planning range rather than a formal appraisal. - [ROI Calculation: Formula, Annualized Return, and Examples](https://dothecalculation.com/blog/business/roi-calculation) — Calculate ROI and annualized return with total costs included, compare opportunities consistently, and understand what a simple ROI result leaves out. ## Related calculators - [Capital Expenditure (CapEx) ROI Calculator](https://dothecalculation.com/calculators/capex-roi-calculator) — Evaluate capital expenditure projects using return on investment, simple payback period, and net present value metrics before you invest. - [Weighted Average Cost of Capital (WACC) Calculator](https://dothecalculation.com/calculators/wacc-calculator) — Estimate Weighted Average Cost of Capital, after-tax cost of debt, and capital weights to evaluate investment and financing decisions. - [Discounted Cash Flow (DCF) Calculator](https://dothecalculation.com/calculators/corporate-valuation-dcf-calculator) — Estimate a company enterprise and equity value using a multi-year discounted cash flow model with terminal value assumptions. - [Convertible Note & SAFE Valuation Calculator](https://dothecalculation.com/calculators/convertible-debt-pricing-calculator) — Calculate startup convertible note and SAFE conversion share price, post-conversion ownership, and founder dilution impact. - [M&A Accretion/Dilution Calculator](https://dothecalculation.com/calculators/mergers-acquisitions-accrual-calculator) — Analyze pro forma financial impacts of a merger, combined earnings per share, and synergy break-even targets for M&A deals. - [Startup Equity Dilution & Cap Table Simulator](https://dothecalculation.com/calculators/startup-equity-dilution-calculator) — Simulate venture capital seed and Series A funding rounds, share pricing, option pool dilution, and founder equity ownership stakes. --- _This tool is for educational purposes only. Mortgage rates, PMI premiums, property valuations, tax assessments, and insurance underwriting details depend on individual credit profiles, local government policies, and lender overlays. Always consult a licensed mortgage broker, financial planner, or tax professional before making property transactions._ --- _Source: [Do The Calculation](https://dothecalculation.com/calculators/lbo-model). Quote freely with attribution and a link to this page._