Private Equity Fund Cashflows Model
Originally published: 26/06/2020 11:59
Last version published: 23/08/2021 09:30
Publication number: ELQ-97275-3
View all versions & Certificate
certified

Private Equity Fund Cashflows Model

PE Financial Model to analyze fund cashflows and returns available to LP and GP along with portfolio level cashflows.

Description
Overview
The financial model offers a comprehensive set of assumptions used for fundraise by a PE fund. It provides a detailed analysis on fund cashflows flowing from LP contributions to portfolio investments and back to LP in accordance with the waterfall distribution assumptions. The J-curve on net LP cashflows along with key PE ratios such as Value of Fund, Portfolio NAV, TVPI, DPI, Gross/Net MOIC, Gross/Net IRR, etc. are also presented in the Dashboard.

Structure
1. Input/Assumptions: The model has inputs at the fund level including equity contributions, debt ratio, fund life, commitment period, fund expenses, hurdle rate and investor-wise management fees, promote structure, etc. Along with these assumptions, a capital drawdown schedule is also provided to track the timeline of investments during commitment period. Moreover, there are specific assumptions provided for availing debt and also the returns to be generated from each portfolio investment and its holding period.
2. Performance Metrics: Once the inputs are established, the model presents the output in form of various performance metrics for each LP and the GP as well. Portfolio level returns are also presented both in nominals and IRR/Cash on Cash Multiples. Fund level performance charts are also provided along with key fund ratios.
3. Fund Cashflows: It tracks total capital contributions (derived from each LP capital and debt principal) and the take-outs in form of fees, expenses and transaction fees. The net remains (or net invested capital) is then invested in portfolio investments. Portfolio cashflows are provided for each individual investments as well along with the NAV calculation. The cash inflow from portfolio is first used to pay off scheduled debt payment (interest and principal) then fees and expenses. The remaining cashflows are used for waterfall distributions based on hurdle, catch-up and carry assumptions between LP and GP. A summary of gross and net returns at fund level is also provided at the end.
4. LP Cashflows: The model has 4 categories of LP investors with each having different terms for fees (both during and post commitment period), investment amount, catch-up eligibility and ratio, and carried interest ratio. Contributions, take-outs, investments and distributions for each class of investor is tracked separately to analyze their cashflows. Thereafter, a summary of gross and net returns is presented at the end.
5. GP Cashflows: GP as LP cashflows are treated similar to LP cashflows. Additionally, the fees and carried interest earned by GP is added to their cashflows for their returns.
6. Debt: A debt schedule is also provided based on moratorium and tenure assumptions.
7. Index: An index sheet is available to navigate through the model easily.

Assumptions
1. 10-year fund life with extension option available for up to 3 years (10+3). Fund life can be set to less than 10 years as well.
2. Investment holding period is dependent on commitment period and total fund life to avoid no-activity years. For instance, if the fund life is 10 years and commitment period is 5 years then the holding period will be 5 years to receive the final exit in 10th year. Re-investments option is not provided in the model but can be made available on request.
3. Debt is assumed at 40% of total fund size. It can be set to 0% as well.
4. Each debt tranche is assumed to mature or paid in-full with respective portfolio investment exits. If there are negative cashflows after debt payments then equity distributions will be held off and paid in cumulative in future periods.
5. LP Categories also include GP as LP (IM’s contribution).
6. Fees are calculated on cumulative contributions during the commitment period and then on net invested capital post commitment period.
7. Annual fund expenses (fund operations) are calculated on total fund size.
8. The model is based on European waterfall method. American structure (deal-by-deal) can be made available on request. Claw-back option is also not available and can be added on request.

Please let me know if you need specific modifications in the model or place a customized request. We have provided our services to various clients, especially, the fund managers based out of Europe and US looking to analyze fund cashflows. You may reach us for any other type of modelling request as well including but not limited to LBOs, DCF, Real Estate PE, sector-specific company models, etc. Please contact us at streetfoxadvisors@gmail.com

This Best Practice includes
Excel Workbook

Acquire business license for $105.00

Add to cart

Add to bookmarks

Discuss

Further information

The model can be used as a template by any private equity firm raising funds and looking at portfolio investments. The model is detailed and covers all the relevant concepts used in private equity cashflow models.

Investor Cashflows, Commitments and Distributions, Carry-Catchup Calculations, Hurdle Calculations, Waterfall structure

Reviews

People using this Best Practice also downloaded


keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Private Equity Fund Cashflows Model

The user community and author are here to help. Go ahead!

  • Medzai
    Is this just an excel template?
    arrow_drop_uparrow_drop_downReply reply
    • Anuj Verma
      This is a detailed model with variables for changing the output based on fund specifics.
      arrow_drop_uparrow_drop_downReply reply
    • ACOR
      Is this possible to work on a 10 years funds (+ extensions 2x1 year) based on a 5 years investment period + capacity to reinvest proceeds (under conditions)?
      arrow_drop_uparrow_drop_downReply reply
      • Anuj Verma
        It doesn’t have extensions and reinvestment options in built in the model. However, I can work on it to add these options and customize the model according to your requirements. Please let me know your thoughts on anuj.verma190494@gmail.com. Thanks.
        1arrow_drop_uparrow_drop_downReply reply
        • ACOR
          I sent you an email Anuj, please check and answer asap please
          Regards
          arrow_drop_uparrow_drop_downReply reply
      • Bill Bertha
        This appears to be a great tool for evaluating potential primary commitments into prospective PE and/or VC funds. In looking through the inputs, it does not appear to have the functionality for evaluating secondary private equity LP interest transfers (i.e. modelled returns for a prospective buyer of an LP interest in a fund after "x" amount of years, as opposed to an initial commitment at time of close). Is this valid or is it possible to incorporate into the framework as currently constructed? Thanks!
        arrow_drop_uparrow_drop_downReply reply


        4.0 / 5 (3 votes)

        please wait...