Private Equity & M&A Model

LBO Returns Calculator for PE & Investment Committee Decks

Model initial sponsor equity, debt paydown, exit enterprise value, MoIC, and Equity IRR. Deconstruct returns across the three classic engines of private equity value creation: EBITDA growth, multiple expansion, and deleveraging.

Native PowerPoint Output (.pptx)

Institutional Deal Presets

Target Audience: PE Deal Team, Investment Committee, SaaS Practice Leads

Underwriting Inputs

Entry EBITDA ($)$25.00M

Entry EV/EBITDA14.00x

Entry Leverage (Debt/EBITDA)4.00x

Fees (% of EV)2.0%

Hold Period (Years)5 yrs

Operating & Cash Generation

EBITDA CAGR (%)14.0%

FCF for Debt Paydown (%)40.0%

Exit & Hurdle Targets

Exit EV/EBITDA14.00x

Hurdle IRR (%)20.0%

Return on Capital

2.53x

MoIC (Multiple on Invested)

Annualized Return

20.4%

Hurdle: 20.0% (+0.4%)

Total Equity Gain

$392.25M

Net Dollar Creation

Transaction Overview: Entry vs. Exit5-Year Hold

Metric	Entry (5 yrs ago)	Exit (Year 5)	Net Change
EBITDA	$25.00M	$48.14M	+$23.14M (+92.5%)
EV / EBITDA Multiple	14.00x	14.00x	+0.00x
Enterprise Value	$350.00M	$673.90M	+$323.90M
Net Debt (Debt - Cash)	$100.00M	$24.64M	-$75.36M
Sponsor Equity Value	$257.00M	$649.25M	+$392.25M (2.53x)

The 3 Engines of Value Creation

Attribution of net equity created ($392.25M)

Bain / McKinsey Bridge Framework

EBITDA Growth

+$323.90M(82.6%)

Value created by growing operating earnings at entry multiple

Multiple Expansion

+$0(0.0%)

Value created (or lost) through exit multiple re-rating

Deleveraging & Cash

+$68.36M(17.4%)

Net debt reduction and cash buildup from operating FCF minus fees

Breakeven exit multiple to hit 20.0% Hurdle:13.80x EV/EBITDA

Returns Sensitivity Matrix (MoIC / IRR)

Stress-test sponsor returns across Exit Multiples (rows) and EBITDA Growth Rates (columns).

≥ 20% Hurdle 15% – 20% < 15%

Exit Multiple \ CAGR	10.0% CAGR	12.0% CAGR	14.0% CAGR	16.0% CAGR	18.0% CAGR
12.00x EV/EBITDA	1.75x 11.9%	1.94x 14.2%	2.15x 16.6%	2.37x 18.9%	2.61x 21.2%
13.00x EV/EBITDA	1.91x 13.8%	2.12x 16.2%	2.34x 18.5%	2.58x 20.8%	2.83x 23.1%
14.00x EV/EBITDA	2.07x 15.6%	2.29x 18.0%	2.53x 20.4%	2.78x 22.7%	3.05x 25.0%
15.00x EV/EBITDA	2.22x 17.3%	2.46x 19.7%	2.71x 22.1%	2.99x 24.5%	3.28x 26.8%
16.00x EV/EBITDA	2.38x 18.9%	2.63x 21.3%	2.90x 23.7%	3.19x 26.1%	3.50x 28.5%

Investment Committee Memo Takeaway

Underwriting Thesis: B2B SaaS Platform Buyout underwrites to 2.53x MoIC and 20.4% Equity IRR over a 5-year hold against an institutional hurdle of 20.0% (Spread: +0.4%). Capital Structure: Sponsor checks $257.00M of initial equity alongside $100.00M of senior leverage (4.00x Entry EBITDA, 28.6% LTV). Deleveraging & Cash Engine: Free cash flow generation of $75.36M retires $75.36M of debt, reducing exit net leverage to 0.51x EBITDA. Value Creation Quality: Primary value driver is EBITDA Growth contributing $323.90M (82.6% of total equity gains); model assumes flat exit multiple (14.00x). Downside Headroom: Breakeven exit multiple to maintain the 20.0% hurdle rate is 13.80x EV/EBITDA (-0.20x vs entry).

XLSlides Deal Suite

Turn this LBO Underwriting into an IC Deck in Seconds

XLSlides automatically structures this returns bridge, leverage schedule, sensitivity matrix, and investment thesis into McKinsey/Bain-styled PowerPoint slides.

LBO Returns Mechanics & Core Formulas

Entry Valuation & Sources

Enterprise Value (EV): Calculated as Entry EBITDA multiplied by the Entry Multiple:

Entry EV = Entry EBITDA × Entry Multiple

Initial Debt & Sponsor Equity Check: Lenders provide debt based on a Debt-to-EBITDA multiple. Transaction fees (advisory, legal, financing) are added to EV to determine Total Uses. The sponsor funds the equity gap:

Sponsor Equity = Entry EV + Fees − Initial Debt

Exit Valuation & Return Metrics

Multiple on Invested Capital (MoIC): Measures total cash-on-cash equity return independent of time:

MoIC = Exit Equity Proceeds / Sponsor Initial Equity

Equity Internal Rate of Return (IRR): Annualized compound rate of return taking into account the holding period:

Equity IRR = (MoIC)^(1 / Hold Years) − 1

Private Equity Return Benchmarks (5-Year Hold)

How institutional limited partners (LPs) and general partners (GPs) interpret MoIC and IRR hurdles:

MoIC	5-Yr IRR	Performance Tier	Underwriting Reality
1.8x – 2.0x	12% – 15%	Below Top-Tier PE / Infrastructure	Acceptable for lower-risk infrastructure or core-plus assets; typically insufficient for middle-market private equity hurdle rates.
2.0x – 2.5x	18% – 22%	Standard Underwriting Target	Meets standard 20% institutional hurdle rate over a 5-year hold; standard baseline expected by most limited partner advisory committees.
2.5x – 3.0x	22% – 26%	Top-Quartile Performance	Clear winner in fund performance; creates strong carry potential and proves substantial operational or buy-and-build value addition.
3.0x+	28%+	Upper-Decile Outlier	Exceptional fund-maker deal; usually requires the convergence of operational EBITDA compounding, disciplined deleveraging, and multiple expansion.

Common LBO Underwriting Pitfalls

01.Underwriting multiple expansion as the primary driver: Top-tier sponsors assume flat or contracting exit multiples, treating multiple expansion as unbanked upside.

02.Ignoring working capital build and cash taxes: Assuming headline EBITDA converts straight into debt paydown overlooks receivables drag, capex maintenance, and interest expense.

03.Assuming uniform linear growth: Missing year-1 integration slip-ups or ERP cutover disruption can depress early cash flow, impairing covenant headroom and compounding IRR drag.

04.Overleveraging in higher-rate environments: A 5.5x debt structure that worked at 2% SOFR creates severe interest burden at 5%+ SOFR, suppressing cash conversion.

05.Failing to model exit friction: Forgetting to deduct remaining transaction fees, lender prepayment penalties, or management incentive pool payouts when calculating final net sponsor proceeds.

Where Private Equity & Finance Teams Use This Tool

Investment Committee (IC) Memo Preparation: Formulate standard 3-engine returns decomposition and multiple sensitivity matrices before formal partner review.

Deal Screening & Bidding Triage: Rapidly determine the maximum allowable purchase price multiple that still clears a 20% or 25% IRR hurdle.

Lender Package & Credit Framing: Model post-debt paydown debt-to-EBITDA ratios and total deleveraging capacity to secure senior and mezzanine financing.

Management Incentive & Options Sizing: Calculate projected equity pool proceeds at various exit valuations to align founder and C-suite equity packages.

Value Creation Planning: Isolate how much EBITDA growth and cash generation the operating partner must deliver if market multiples compress by 1.0x–2.0x.

LP Annual Reviews & Advisory Board Decks: Bridge ongoing portfolio company returns to show whether realized gains stem from organic operational growth or multiple expansion.

Related Free Business & Valuation Tools

EBITDA Multiple Valuation Calculator

Benchmark EV/EBITDA multiples across peer industries, calculate implied enterprise value, and bridge to equity value.

Net Debt to EBITDA Calculator

Model leverage ratios, debt covenant headroom, and debt paydown schedules for lender packages and sponsor updates.

Debt Service Coverage Ratio (DSCR) Calculator

Measure cash flow available for debt service against interest and principal amortization to ensure lender compliance.

M&A Accretion Dilution Calculator

Evaluate pro forma EPS impact, purchase price financing mix, and earnings accretion for corporate development and IC decks.

IRR & Capital Budgeting Calculator

Model multi-year cash flow internal rate of return, MIRR, NPV, and payback periods for capital expenditure approvals.

Investment Committee Memo to Deck Generator

Turn CIMs, diligence notes, and financial models into an institutional investment committee deck outline.

Frequently Asked Questions

What is an LBO and how do private equity returns work?

A Leveraged Buyout (LBO) is the acquisition of a company using a combination of equity provided by a private equity sponsor and debt provided by lenders. The target company’s cash flows are used to pay interest, amortize debt, and fund operations. Returns to equity investors are measured primarily through MOIC (Multiple on Invested Capital) and Equity IRR (Internal Rate of Return).

What are the three core drivers of LBO value creation?

The three classic engines of LBO returns are: (1) EBITDA Growth (increasing earnings via revenue growth, margin expansion, or operational efficiencies), (2) Debt Paydown / Deleveraging (using operating cash flows to retire debt, transferring enterprise value from lenders to equity holders), and (3) Multiple Expansion (selling at a higher EV/EBITDA multiple than the entry multiple, often achieved through scaling into a larger platform).

How is MoIC (Multiple on Invested Capital) calculated?

MoIC equals Total Exit Equity Proceeds divided by Initial Sponsor Equity Check. For example, if a private equity firm invests $100M of equity and receives $250M at exit after paying off debt, the MoIC is 2.50x ($250M / $100M). MoIC is time-independent.

How is Equity IRR calculated in an LBO?

In a single-cash-in / single-cash-out model, Equity IRR is calculated as: IRR = (Exit Equity / Initial Equity)^(1 / Hold Years) - 1, which is equivalent to (MoIC)^(1 / Hold Years) - 1. For example, a 2.50x MoIC realized over 5 years yields an annualized IRR of 20.1%.

Why do Investment Committees focus on Returns Attribution?

Investment Committees prioritize the quality and repeatability of returns. An LBO where 70% of gains come from EBITDA expansion and debt paydown is viewed as disciplined and defensible. Conversely, an underwriting that relies entirely on multiple expansion is viewed as speculative market timing.

How does XLSlides help PE deal teams and CFOs after running this calculator?

XLSlides converts the LBO return model, 3-engine value creation bridge, and exit multiple sensitivity tables directly into editable PowerPoint slides formatted to institutional investment committee and board standards in McKinsey, Bain, and private equity visual themes.