Mezzanine Debt Funding ModelFree Financial Model Download
Structure mezzanine financing with coupon, PIK toggle, and equity upside to bridge leverage gaps while protecting sponsor returns and lender position. Model warrant or equity kicker valuation, paydown scenarios, and total mezzanine investor IRR combining cash interest and equity proceeds.
Free download. No sign-up required.
About this model
A Mezzanine Debt Fund Model values a $300M fund deploying into 15 portfolio companies (avg $18M loan per company) over a 4-year investment period (Years 0-3), then harvesting over a 3-year exit period (Years 4-6). Each loan earns a blended 15% gross return: 11.5% all-in cash coupon (SOFR 1% floor + 6.2% spread + 4.3% mezzanine structuring premium), 3.5% PIK (paid-in-kind, accrued to principal), 2% origination/OID fees, 1.5% prepayment fees (if refinanced early), 0.5% commitment fees (on unfunded capacity), and 3% equity warrant kickers (allowing the fund to purchase 3% of borrower equity at maturity, capturing upside in exits).
The Loan_Portfolio sheet models annual deployments (25%, 30%, 25%, 10% of fund size in Years 0-3) to a stable of 15 portfolio companies. Each loan accrues interest on opening deployed principal; PIK capitalizes into principal each year, creating leverage accretion. Default rates (3% of opening portfolio annually) and recovery rates (50% for mezzanine subordination) apply from Year 1 onward. Credit Losses are modeled as a drag on fund returns (1.5% net loss rate). Cash interest is distributed to LPs annually; PIK is realized only at loan exits (maturity or refinance). Capital calls follow a PRIOR-period cap formula to avoid circular references. The Distributions sheet applies the LP waterfall: return of capital (Tier 1), then preferred return accrual at 7% on un-returned capital (Tier 2), then 80/20 split (Tier 3) between LPs and GP on remaining profits.
Key metrics include Gross IRR (~15-18% target), Net IRR to LPs (~12-15% post-fees), management fees (1.5% of committed capital in investment period, 1.0% of invested capital in harvest), and carried interest (15% on GP-realized gains). This model applies to credit fund investors, credit analysts, and portfolio company management evaluating mezzanine financing terms. Typical mezzanine terms: 5-7 year tenor, 40-65% LTV, covenant DSCR minimums of 1.25-1.35×. Equity warrant provisions (typically 2-5% coverage) provide meaningful upside in strong exits.
Recolor to your brand.
Formatted to IB standards.
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.
- Brand-ready
- Institutional grade
- Fully auditable
What's included
- Mezzanine debt sizing and coupon assumptions
- PIK toggle mechanics and interest cash versus accrual treatment
- Warrant or equity kicker sizing and dilution impact
- Debt paydown schedule and refinance scenarios
- Mezzanine investor return analysis combining debt IRR and equity upside
PIK feature modeling
Show how accrued interest compounds when in PIK mode, creating a larger exit debt balance and reducing net mezzanine investor proceeds at refinancing or exit.
Equity kicker valuation
Estimate warrant or equity value at exit and fold into total mezzanine investor return alongside cash interest payments across the holding period.
Sponsor equity protection
Model mezzanine paydown priority and exit waterfall to ensure the sponsor retains meaningful equity upside and appropriate incentive alignment.
Frequently asked
What is a typical mezzanine coupon rate?+
Mezzanine coupons typically range from 10-15% depending on deal risk. Rates are higher when a PIK toggle is included or when equity is deeply subordinated, compensating investors for subordination risk relative to senior debt.
How do equity kickers work in mezzanine financing?+
Warrants or equity stakes are granted at a low or zero strike to compensate mezzanine investors for subordination. At exit, the warrants convert at the agreed strike, giving investors equity upside if the company has performed well.
What happens if mezzanine cannot be refinanced before maturity?+
Model paydown from operating cash flow or asset sales. If cash is tight, the PIK toggle allows interest to accrue; at refinancing or exit, the increased debt balance reduces proceeds available to the equity sponsor.
Who uses mezzanine debt models?+
Mezzanine lenders, private equity sponsors, investment banks, and CFOs use these models for deal financing strategy, investor pitches, and refinancing planning decisions.
How does mezzanine fit into a leveraged buyout capital structure?+
Mezzanine sits between senior secured debt and equity. It allows a sponsor to increase total leverage beyond what senior lenders will provide, reducing the required equity check while keeping senior lenders comfortable with their position.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Related templates
Leveraged Buyout Model
Complete LBO analysis with debt financing structures, sponsor returns, and sensitivity to exit scenarios.
Direct Lending Fund Model
Financial model for direct lending fund with loan origination, yield, losses, and fund returns.
Secondary Private Company Sale Model
Modeling secondary sales of stakes in private companies, including buyer valuations, hold periods, and investor return scenarios.
Venture Capital Fund Model
Model VC fund cash flows, distributed returns, and IRR by vintage year and exit scenario.