Customizable Carried Interest Waterfall Excel Template
  • Customizable Carried Interest Waterfall Excel Template
  • Customizable Carried Interest Waterfall Excel Template
  • Customizable Carried Interest Waterfall Excel Template
  • Customizable Carried Interest Waterfall Excel Template
  • Customizable Carried Interest Waterfall Excel Template
  • Customizable Carried Interest Waterfall Excel Template
Originally published: 14/03/2018 16:43
Last version published: 05/07/2018 07:29
Publication number: ELQ-51197-3
View all versions & Certificate
certified

Customizable Carried Interest Waterfall Excel Template

Customizable and powerful template for carried interest calculations for private equity projects

carried interestclawbackexcelfinancial modelhurdle rateinvestment returnirrpepreferred returnprivate equity

Description
This module allows calculating of carried interest payments with high customization:

- fully customizable hurdle rate, preferred return, carried interest and clawback provision
- monthly, quarterly, semiannual or annual payment schedule
- detailed monthly (quarterly, semiannual or annual) cash flows for General Partners (GP) and Limited Partners (LP)
- calculating of IRR for the project, GP and LP
- calculation of preferred returns for LP
- catch-up calculations for LP
- flexible setup of project cash flows

This module could be used as a stand-alone tool for valuation and building of a distribution waterfall for a project/investment. Or this module could be integrated into financial models as a framework for investment distribution.

More on distribution:
In a private equity fund, the general partner manages the committed capital of the limited partners. The GP usually commits some amount to the fund, usually 1 to 2% of the commitment. When distributing the capital back to the investor, hopefully with an added value, the general partner will allocate this amount based on a waterfall structure previously agreed in the Limited Partnership Agreement.

A waterfall structure can be pictured as a set of buckets or phases. Each bucket contains its own allocation method. When the bucket is full, the capital flows into the next bucket. The first buckets are usually entirely allocated to the LPs, while buckets further away from the source are more advantageous to the GP. This structure is designed to encourage the general partner to maximize the return of the fund.

This business tool includes
One Excel Waterfall Model

Acquire business license for $49.00

Add to cart

Add to bookmarks

Discuss

Further information

Distribution of cash flows between GP and LP in private equity projects (waterfall)

Private equity projects
Venture investments

Reviews

  • Steven Grin(last updated: 01/06/2018 11:59)
    Excellent carried interest waterfall model
    I was looking for a model to calculate waterfall returns and this model is fully customizable and enables you to change hurdle rates, GP/LP splits and easily allows for clawbacks.

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Customizable Carried Interest Waterfall Excel Template?

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

please wait...