Private Equity Fund Finance, ILPA Reporting & Subscription Facilities
PE Subscription Line IRR Uplift vs TVPI Dilution Formula
Compare Unlevered Day-1 Capital-Call IRR against Subscription-Credit-Facility ("Sub-Line") Deferred LP Capital-Call IRR, Financed LP Drawdown Including Interest, and Sub-Line Net TVPI Multiple Dilution.
See mathematically why PE subscription lines boost LP IRR while trimming TVPI cash multiples!
Buyout and infrastructure funds routinely fund initial deal closings on a bank Subscription Credit Facility ("Sub-Line" secured by uncalled LP commitments), deferring actual LP capital calls by 6 to 12 months! Under ILPA Subscription Line reporting guidelines, LPs demand BOTH Unlevered IRR (from Day 0 deal close) and Levered IRR (from the delayed LP capital call date) because of a classic optical trade-off: shortening the LP’s cash-out-of-pocket clock from T_deal years down to (T_deal - T_bridge) years sharply INCREASES annualized IRR—whenever Deal_IRR > SubLine_Interest_Rate—yet paying Sub-Line interest P0 * r_sub * T_bridge increases total LP cash called (or reduces net proceeds), slightly REDUCING the LP’s cash-on-cash TVPI multiple!
Verify on a Single-Deal Illustration—Deal_Equity_Outlay = $100.00M at Year 0 (B2), Gross_Exit_Proceeds = $216.00M at Year 4 (B3), Total_Deal_Hold T_deal = 4.0 years (B4), SubLine_Deferral T_bridge = 1.0 year (B5), and SubLine_Simple_Rate = 0.08 (8.0%, B6): Without a Sub-Line, Unlevered 4-Year IRR is (216 / 100)^(1 / 4) - 1 = 0.2123 (21.23% in E2) at a 2.1600x multiple! With a 1-year Sub-Line, LPs wire $100M * (1 + 0.08 * 1) = $108.00M at Year 1 (E3) and receive $216.00M three years later—boosting Sub-Line LP IRR by +476 bps to (216 / 108)^(1 / 3) - 1 = 2^(1/3) - 1 = 0.2599 (25.99% in E4), while trimming LP Cash Multiple from 2.1600x down to 216 / 108 = 2.0000x (E5)!
| ILPA Sub-Line Metric ($100M Deal, $216M Exit @ Yr 4, 1-Yr Bridge @ 8.0%) | Formula | Verified Output |
|---|---|---|
| Unlevered 4-Yr Deal IRR | (Exit_Proceeds / Deal_Cost)^(1 / T_deal) - 1 | 0.2123 (21.23% Annualized) |
| Deferred LP Capital Call ($M) | Deal_Cost * (1 + r_sub * T_bridge) | $108.00M ($100.00M @ 0 Bridge) |
| Sub-Line Deferred LP IRR | (Exit / LP_Call)^(1 / (T_deal - T_bridge)) - 1 | 0.2599 (25.99%; +476 bps Boost) |
| Sub-Line LP Cash Multiple (x) | Exit_Proceeds / Deferred_LP_Call | 2.0000x (vs 2.1600x Unlevered) |
Sub-Line Deferred Capital-Call IRR Formula
Validate Deal_Cost > 0, Exit_Proceeds > 0, Total_Hold >= 1, 0 <= Bridge_Years < Total_Hold, and 0 <= r_sub < 0.30!
=LET(c_dl, B2, ex_p, B3, t_hl, B4, t_br, B5, r_sb, B6, IF(OR(c_dl <= 0, ex_p <= 0, t_hl < 1, t_br < 0, t_br >= t_hl, r_sb < 0, r_sb >= 0.3), "Invalid Sub-Line Schedule", LET(lp_c, c_dl * (1 + r_sb * t_br), ROUND((ex_p / lp_c) ^ (1 / (t_hl - t_br)) - 1, 4))))Zero-Bridge Unlevered Parity Check (Set Sub-Line Deferral = 0 Years)
Set SubLine_Deferral B5 = 0 years: Deferred LP Call E3 reverts to $100.00M, Sub-Line IRR E4 matches Unlevered IRR 0.2123 identically, and LP Cash Multiple E5 restores the full 2.1600x!
=IF(ISTEXT(E4), E4, ROUND(B3 / E3, 4))Try the example
Use the original values or change them to test your understanding.