Leveraged Finance, Private Credit & Mezzanine Debt
PIK-Toggle Mezzanine Note Balloon Accretion & Cash-Save Formula
Calculate Payment-in-Kind (PIK) Toggle Mezzanine Annual Cash Liquidity Preserved, Compounded Balloon Redemption Principal P0*(1 + r_cash + r_stepup)^T, Cumulative PIK Accretion, and Excess Compounding Cost vs Cash Pay.
Quantify the exponential balloon penalty of electing PIK-Toggle interest relief!
Private credit and LBO mezzanine facilities frequently grant borrowers a Payment-in-Kind (PIK) Toggle option during heavy capex or cyclical trough years: instead of paying the Base Cash Coupon r_cash in cash, the borrower capitalizes interest onto principal at a stepped-up PIK rate r_pik = r_cash + r_stepup (typically +150 to +250 bps)! A common modeling error treats PIK accretion linearly as P0 * r_pik * T; in reality, capitalized PIK notes compound onto prior PIK additions, inflating maturity Balloon Principal = P0 * (1 + r_cash + r_stepup)^T and creating an Excess Compounding & Step-Up Cost = (Balloon_Principal - P0) - (P0 * r_cash * T) over simple cash-pay coupons!
Verify on a $100M Sponsored Mezzanine Tranche—Initial_Principal P0 = $100M (B2), Base_Cash_Coupon = 0.10 (10.0%, B3), PIK_Toggle_StepUp_Spread = 0.02 (+200 bps -> 12.0% all-in PIK rate, B4), and PIK_Election_Horizon = 3 years (B5): Annual Cash Liquidity Preserved in Year 1 is $100M * 10% = $10.00M (E2); Compounded Balloon Principal after 3 PIK years reaches 100 * (1.12^3) = $140.4928M (E3); Cumulative PIK Principal Accretion is $40.4928M (E4); and Excess Compounding & Step-Up Penalty vs $30M of flat cash coupons is $10.4928M (E5)!
| PIK-Toggle Debt Metric ($100M Note, 10% Cash + 2% Toggle Step-Up, 3 PIK Yrs) | Formula | Verified Output |
|---|---|---|
| Year-1 Cash Liquidity Saved ($M) | IF(T=0, 0, P0 * r_cash) | $10.00M ($0 @ 0 PIK Yrs) |
| Compounded Balloon Principal ($M) | P0 * (1 + r_cash + r_stepup)^T | $140.4928M ($100M @ 0 Yrs) |
| Cumulative PIK Accretion ($M) | Balloon_Principal - P0 | $40.4928M |
| Compounding & Step-Up Penalty ($M) | PIK_Accretion - (P0 * r_cash * T) | $10.4928M ($0 @ 0 Yrs) |
PIK-Toggle Excess Compounding & Step-Up Penalty Formula
Validate P0 > 0, 0 < r_cash < 0.50, 0 <= r_stepup < 0.20, and 0 <= PIK_Years <= 20!
=LET(pr_0, B2, r_cs, B3, r_su, B4, n_yr, B5, IF(OR(pr_0 <= 0, r_cs <= 0, r_cs >= 0.5, r_su < 0, r_su >= 0.2, n_yr < 0, n_yr > 20), "Invalid PIK Toggle Terms", LET(bl_n, pr_0 * ((1 + r_cs + r_su) ^ n_yr), pk_i, bl_n - pr_0, cs_i, pr_0 * r_cs * n_yr, ROUND(pk_i - cs_i, 4))))Pure Cash-Pay Baseline Check (Set PIK Election Years = 0)
Set PIK_Election_Years B5 = 0: Cash Saved E2 is $0, Maturity Principal E3 remains par $100.0000M, and Compounding Penalty E5 collapses cleanly to $0!
=IF(ISTEXT(E2), E2, ROUND(B2 * ((1 + B3 + B4) ^ B5), 4))Try the example
Use the original values or change them to test your understanding.