Private Equity Fund Finance, ILPA Reporting & Performance Attribution
PE Subscription Line (Subline) IRR Boost vs TVPI Formula
Calculate Unlevered Deal IRR (%), Delayed LP Capital Call With Subline Interest ($M), Subline-Levered LP IRR (%), and Net LP TVPI Multiple Dilution (x).
Subscription credit lines boost LP IRR by shortening the clock—while shrinking cash TVPI!
Private equity funds routinely draw on a bank Subscription Credit Facility ("subline" secured by uncalled LP commitments) to close acquisitions on Day 0 while delaying the actual LP capital call by 6–12 months! Because IRR measures compounding only from the date LP cash leaves the LP’s bank account, shortening LP capital-out duration from T_hold to (T_hold - T_subline) artificially boosts reported Net IRR—often pushing a fund across an 8% preferred-return hurdle—even though bank interest Deal_Cost * r_sub * T_subline increases total LP Paid-In Capital and REDUCES Net TVPI (Exit_Proceeds / Delayed_LP_Call)! That trade-off is why Institutional Limited Partners Association (ILPA) guidelines mandate disclosing BOTH unlevered and subline-levered IRRs.
Verify on a $100.00M Buyout Exiting at $200.00M in Year 4—Deal_Equity_Cost = $100.00M (B2), Exit_Proceeds = $200.00M (B3), Total_Hold_Period = 4.0 years (B4 -> Unlevered IRR = (200/100)^(1/4) - 1 = 18.92% in E2 at 2.00x TVPI), Subline_Bridge_Years = 1.0 year (B5), and Subline_Interest_Rate = 0.08 (8.0%, B6): Delayed Year-1 LP Capital Call rises to $108.00M (E3), Subline-Levered LP IRR jumps +388 bps to (200/108)^(1/3) - 1 = 22.80% (E4), while Net LP TVPI drops from 2.00x to 200 / 108 = 1.85x (E5)!
| ILPA Subline Attribution KPI ($100M -> $200M in 4 Yrs, 1-Yr Subline @ 8.0%) | Formula | Verified Output |
|---|---|---|
| Unlevered (No-Subline) IRR (%) | ((Exit_M / Cost_M) ^ (1 / Hold_Yrs) - 1) * 100 | 18.92% (at 2.00x TVPI) |
| Delayed LP Capital Call ($M) | Cost_M * (1 + Subline_Rate * Bridge_Yrs) | $108.00M ($100.00M @ 0 Yr) |
| Subline-Levered LP IRR (%) | ((Exit_M / LP_Call) ^ (1 / (Hold - Bridge)) - 1)*100 | 22.80% (18.92% @ 0 Yr) |
| Net LP TVPI Multiple (x) | Exit_Proceeds_M / Delayed_LP_Call_M | 1.85x (2.00x @ 0 Yr) |
ILPA Unlevered vs Subline-Levered IRR & TVPI Formula
Validate Deal_Cost > 0, Exit_Proceeds > 0, Hold_Years >= 1, 0 <= Bridge_Years < Hold_Years, and Subline_Rate in [0, 0.25]!
=LET(cs_m, B2, ex_m, B3, hd_y, B4, br_y, B5, rt_s, B6, IF(OR(cs_m <= 0, ex_m <= 0, hd_y < 1, br_y < 0, br_y >= hd_y, rt_s < 0, rt_s > 0.25), "Invalid Subline Input", LET(lp_c, cs_m * (1 + rt_s * br_y), ROUND(((ex_m / lp_c) ^ (1 / (hd_y - br_y)) - 1) * 100, 2))))Zero-Bridge Unlevered Equivalence Check (Set Subline Bridge Years = 0)
Set Subline_Bridge_Years B5 to 0.0 (Day-0 direct LP capital call): Delayed Call E3 returns to $100.00M, Levered IRR E4 converges to Unlevered IRR E2 at 18.92%, and Net LP TVPI E5 restores to 2.00x!
=IF(ISTEXT(E4), E4, ROUND(B3 / (B2 * (1 + B6 * B5)), 2))Try the example
Use the original values or change them to test your understanding.