PE Fund Returns & Distributions Model Example

texag3236's picture
Rank: Chimp | banana points 5

This summer I am making the jump from F100 M&A to a small PE fund (500mm AUM) as an associate. They told me right out of the gate I would be working on their "Fund master model" where they calculate returns and cash flow distributions to LPs, co-investors, debt-holders and the GP at the portco and fund level.

I have really good modeling experience, but am unaccustomed to looking at investments and distributions from a portfolio rollup level (we buy everything cash free/debt free and integrate it). This fund is rapidly committing capital so I plan to be very involved with the continued build-out of this model.

I want to hit the ground running here to make an immediate impact - anyone know of a good example or resource to use to get familiar? Or in your experience is this just something you saddle up and figure out quick?

Private Equity Interview Course

  • 2,447 questions across 203 private equity funds. Crowdsourced from over 500,000 mem.
  • 9 Detailed LBO Modeling Tests and 15+ hours of video solutions.
  • Trusted by over 1,000 aspiring private equity professionals just like you.

Comments (2)

Mar 6, 2019

asimplemodel.com has one I think, search for modeling the return waterfall I think.

    • 1
Mar 7, 2019
    • 1