Private Equity Fund Model

This model provides a comprehensive framework to assess investment performance using key financial metrics such as Gross and Net IRR, Gross and Net MOIC, TVPI, and DPI. The model is available in both the American and European Waterfall distribution structures.

Key Features

1. Dual Waterfall Engine (Toggle Switch)

• Instantly switch between American and European distribution structures.
  

• Built-in logic for Preferred Return (Hurdle), GP Catch-up, and Carried Interest.
  

• See exactly how cash flows split between Limited Partners (LPs) and the General Partner (GP).
  

2. Comprehensive GP Management Company Module

• Detailed bottom-up budgeting for the GP entity.
  

• Input staff salaries across levels (Partners to Analysts), office rent, tech stacks, and travel costs.
  

• Calculates Net GP Profit.
  

3. Portfolio Construction & Scenarios

• Model up to 10 unique portfolio investments with varying entry dates, check sizes, and sector tags.
  

• Granular exit assumptions: input specific Exit Multiples, Hold Periods, and Debt/Equity ratios for each deal.
  

• Sensitivity Analysis: Visualize how changes in Exit Multiples impact your Fund’s Net IRR and MOIC.
  

4. Subscription Line (Debt) Modeling

• Includes a credit facility module to simulate the impact of leverage on IRR (the "J-Curve" effect).
  

• Configurable interest rates, commitment fees, and repayment periods.
  

5. Professional Dashboard

• Print-ready executive summary tab.
  

• Visualizes the J-Curve, Capital Call Schedules, and Sector Exposure.
  

• Key Metrics calculated automatically: Net IRR, Net MOIC, DPI, TVPI.