Private Equity Fund Finance, Portfolio NAV Facilities & Credit Risk
PE NAV Loan LTV Covenant, Drawdown Buffer & DPI Formula
Calculate Late-Life PE Portfolio NAV Facility Initial LTV (Debt / NAV), Hard Maintenance Covenant Minimum NAV (Debt / Max_LTV), Allowable Portfolio Valuation Drawdown Buffer, and Synthetic Recap DPI Uplift.
Stress-test PE portfolio NAV-loan markdown cushions before borrowing to fund synthetic DPI!
Whereas early-life Subscription Lines borrow against uncalled LP commitments, late-life Private Equity NAV Facilities ("NAV Loans") pledge the unrealized equity value of a diversified pool of 8–15 mature portfolio companies after the investment period has expired—either to finance accretive tuck-in M&A or to distribute recallable/synthetic cash DPI! Because NAV lenders enforce a Hard Maintenance LTV Covenant (typically Max_LTV = 25%–35%, above which 100% cash sweep or equity cure triggers!), LPs and fund CFOs monitor Initial_LTV = Drawn_NAV_Debt / Eligible_Portfolio_NAV, Covenant Breach Minimum NAV = Drawn_NAV_Debt / Max_LTV, and Allowable Portfolio Markdown Buffer = 1 - (Min_Covenant_NAV / Eligible_NAV) = 1 - (Initial_LTV / Max_LTV)!
Verify on a Mature Buyout Fund V—Eligible_Portfolio_NAV = $400.00M (B2), Drawn_NAV_Facility_Debt = $80.00M (B3 -> Initial Portfolio LTV = 80 / 400 = 0.2000 or 20.00% in E2), Hard_Maintenance_LTV_Covenant = 0.32 (32.0%, B4 -> Covenant Breach Minimum NAV = 80 / 0.32 = $250.00M in E3), and Fund_Paid_In_Capital PIC = $250.00M (B5): Allowable Valuation Drawdown Buffer before breaching 32% LTV is 1 - (250 / 400) = 0.3750 (a resilient 37.50% markdown cushion in E4), while distributing the $80M proceeds lifts cash DPI immediately by 80 / 250 = +0.3200x (E5)!
| PE NAV Facility Metric ($400M NAV, $80M Debt, 32% Max LTV, $250M PIC) | Formula | Verified Output |
|---|---|---|
| Initial Portfolio LTV Ratio | Drawn_NAV_Debt / Eligible_NAV | 0.2000 (0.3000 @ $120M Draw) |
| Covenant Breach Min NAV ($M) | Drawn_NAV_Debt / Max_Covenant_LTV | $250.00M ($375.00M @ $120M) |
| Portfolio Markdown Buffer | 1 - (Covenant_Min_NAV / Eligible_NAV) | 0.3750 (0.0625 @ $120M Draw) |
| Synthetic DPI Recap Uplift (x) | Drawn_NAV_Debt / Paid_In_Capital | 0.3200x |
PE NAV Facility Allowable Valuation Markdown Buffer Formula
Validate Eligible_NAV > 0, Drawn_Debt > 0, Max_LTV in (0, 0.80], Initial_LTV < Max_LTV, and PIC > 0!
=LET(nv_p, B2, db_n, B3, lt_m, B4, pi_c, B5, IF(OR(nv_p <= 0, db_n <= 0, lt_m <= 0, lt_m > 0.8, (db_n / nv_p) >= lt_m, pi_c <= 0), "Invalid or Breached NAV Facility", LET(mn_v, db_n / lt_m, ROUND(1 - (mn_v / nv_p), 4))))Aggressive $120M Draw Thin-Cushion Stress Check
Increase Drawn_NAV_Debt B3 from $80.00M to $120.00M (30.00% Initial LTV vs 32.00% covenant): Breach Minimum NAV E3 jumps to $375.00M, leaving a razor-thin 0.0625 (6.25% in E4) valuation markdown cushion!
=IF(ISTEXT(E4), E4, ROUND(B3 / B5, 4))Try the example
Use the original values or change them to test your understanding.