This repository contains a collection of Leveraged Buyout (LBO) models built in Excel to evaluate acquisition opportunities from a private equity perspective.
Each model focuses on:
- Structured transaction modelling
- Capital structure optimization
- Cash flow-driven debt repayment
- Investor return analysis (IRR & MOIC)
The objective is to demonstrate the ability to analyze, structure, and evaluate leveraged acquisitions using fundamental financial principles.
Private equity returns are driven by disciplined entry, efficient leverage, operational improvement, and a well-timed exit.
This repository is built on four core drivers of LBO returns:
- Entry valuation discipline
- Use of leverage to amplify equity returns
- Cash flow generation for debt repayment
- Exit multiple and timing
A Leveraged Buyout (LBO) is the acquisition of a company using a significant amount of debt, where:
- Debt is used to fund a large portion of the purchase price
- The company’s own cash flows are used to repay that debt over time
At its core, an LBO works like this:
- Buy a company using mostly borrowed money
- Use the company’s cash flows to pay down debt
- Sell the company after a few years
- Equity investors keep the remaining value
Why does this work?
Leverage magnifies returns on equity.
-
If the business performs well:
- Debt reduces over time
- Equity value increases faster
-
If the business performs poorly:
- Debt becomes a burden
- Equity can be wiped out
Uses (where money goes):
- Purchase of equity
- Refinancing existing debt
- Transaction fees
Sources (where money comes from):
- Debt (senior, mezzanine, etc.)
- Equity contribution
Each LBO model in this repository follows a structured approach:
- Entry multiple (e.g., EV/EBITDA)
- Debt vs equity split
- Financing structure (types of debt)
- Fees and transaction costs
Projection period: typically 3–7 years
Key drivers:
- Revenue growth
- EBITDA margins
- Capital expenditures
- Working capital changes
These projections determine the company’s ability to service and repay debt.
The model includes detailed tracking of:
- Opening debt balances
- Mandatory repayments
- Optional prepayments (cash sweep)
- Interest expense
Interest Expense:
Interest = Debt × Interest Rate
Cash flow priority: debt repayment before equity returns
Cash generated each year is used in the following order:
- Operating expenses
- Interest payments
- Mandatory debt repayment
- Optional debt repayment
- Residual cash (if any)
Cash Sweep (Optional Repayment):
Cash Sweep = Available Cash Flow − Mandatory Uses
At the end of the holding period:
- Company is sold at an assumed exit multiple
- Remaining debt is repaid
- Residual value belongs to equity investors
Exit Enterprise Value:
Exit EV = Exit EBITDA × Exit Multiple
Equity Value at Exit:
Equity Value = Exit EV − Remaining Debt
Key outputs:
- IRR (Internal Rate of Return)
- MOIC (Multiple of Invested Capital)
MOIC:
MOIC = Exit Equity / Initial Equity
IRR:
IRR = (Exit Equity / Initial Equity)^(1 / Holding Period) − 1
These measure:
- Annualized return
- Total return on equity invested
All models in this repository follow:
- Clear separation of:
- Inputs
- Calculations
- Outputs
- Fully transparent debt schedules
- No hardcoded values within formulas
- Consistent and auditable structure
Given the sensitivity of LBO outcomes:
- Entry multiple, exit multiple, and leverage are stress-tested
- Base, upside, and downside cases are included
- Operational assumptions are varied to assess risk
LBO returns are primarily driven by:
- Entry valuation
- EBITDA growth
- Margin expansion
- Debt paydown
- Exit multiple
Strong returns can come from operations, leverage, or multiple expansion — but relying solely on one increases risk.
This repository will include:
- LBO models across industries
- Companies with varying leverage capacity
- Different capital structures and deal assumptions
- Highly sensitive to assumptions
- Dependent on accurate cash flow projections
- Not suitable for businesses with unstable or unpredictable cash flows
LBO outputs should be interpreted with care and scenario awareness.
- Understanding of private equity deal mechanics
- Ability to build integrated financial models in Excel
- Strong grasp of leverage, risk, and return dynamics
- Structured thinking in transaction analysis
In an LBO, returns are not created by leverage alone — they are earned through disciplined assumptions, operational performance, and capital structure efficiency.