Project Overview
Exit strategy is where PE returns are realized. This model builds a full exit analysis module: for each of three exit routes (strategic M&A, sponsor-to-sponsor, and public market listing), it applies a range of exit EV/EBITDA multiples at Years 3, 4, and 5, computes equity proceeds after debt repayment, and calculates IRR and MOIC from initial sponsor investment. The result is a return heatmap that guides the hold-vs.-exit decision.
📋Problem Statement
After acquiring a company in an LBO, determine the optimal exit route and timing to maximize sponsor returns — balancing company earnings growth against entry/exit multiple expansion or contraction.
🎯Analytical Approach
Built an exit analysis overlay on top of the LBO debt model: projected EBITDA forward by year, applied a matrix of exit EV/EBITDA multiples (ranging from 6× to 10×), computed equity proceeds after repaying remaining debt, and back-solved for IRR and MOIC given the initial equity investment.
💾Data Sources
Projected EBITDA by year (driven by the base LBO model), outstanding debt schedule, entry equity investment, and exit multiple ranges benchmarked against comparable M&A transaction precedents.
🔧Quantitative Methods
Equity proceeds = Exit EV − Net Debt at exit year. MOIC = Equity Proceeds / Equity Invested. IRR: XIRR function applied to entry equity outflow and exit equity inflow. Sensitivity tables: IRR and MOIC as a matrix of exit multiple (rows) × hold year (columns). Scenario columns: strategic buyer premium, SBO pricing, IPO float discount.
✨Key Results
A return heatmap showing that the highest IRR is achieved at Year 4 via a strategic sale at 9×–10× EBITDA, generating a 3.2× MOIC and ~35% IRR. The model demonstrates the compounding effect of EBITDA growth and debt paydown on sponsor returns over the hold period.
🧠Key Learnings
The exit multiple is as important as operational value creation. A one-turn improvement in exit multiple (8× vs. 7×) can add 400–600 bps of IRR — highlighting why sponsor exit timing and buyer identification are critical to fund performance.