Sign Up, Its Free

Join our Affiliate Program by simply copying the link of our products on your site and earn affiliate commission on every sale

Are you a Marketing expert, having some strategic tools? Come and Join as our Vendor

If you are a Vendor looking to sell tools in any specific category which is not present at the moment on our platform, for instance, say "Branding and Strategy." Simply, email us along with one of your sample business tools on "support@icrestmodels.com" and we will add the same after verifying.

We have our showcased inventory as well so that the upcoming vendors can view the quality of business tools we are looking for.

What's New

Joint Venture Cash Flow Waterfall with Priority Preferred Equity Option

Type of Business : Financial Models

Price : USD 45 45.00

Need More Clarifications/Customized Tool? Generate Ticket

Add to Wishlist icrest approved product

  • Short Description

    This is a joint venture financial template built in excel. Its purpose is to show how cash is distributed between preferred equity as well as common equity (Investor vs. Sponsor) or (Limited partner vs. General Partner).

  • Full Description

    Up to 10 years can be modeled and the main user input is simply the year 0 through 10 project equity contributions and distributions, preferred return, and hurdle rates. This is a two-tier model and if the preferred equity leg is not required, that can easily be zeroed out and all the cash will flow to the standard IRR hurdle waterfall with up to 3 hurdle rates and defined percentage splits per hurdle. The point of this model was to allow a separate preferred equity leg and potential equity kicker with a preferred return to sit on top of your regular joint venture distributions. In the preferred equity leg, 100% of all cash goes back to investors along with a defined preferred return until the equity balance has been fully repaid. The user can define if any unpaid preferred return gets accrued as well as if there is a hard reset after each year (with yes/no selectors). Below the preferred return, there is a kicker rate that can be defined for how much of the remaining cash goes to the preferred equity leg. Any remaining cash flow will then go to common equity and that could be 100% to a sponsor/general partner or it could be a secondary joint venture with its own cash sharing schedule between investors/sponsors. This secondary waterfall has up to 3 IRR hurdle rates and defined splits at each hurdle in your more typical joint venture model fashion. The cash flow for the secondary splits is based on pari-passu until the first hurdle is met, but it can be modified to any percentages desired. A final summary shows the total IRR and equity multiple of all legs involved as well as their cumulative cash flow and a visual. Note, there have been instructions added after the video that give a definition for each input cell so it is easier to follow along. There have also been upgrades to the general flow to make it easier to zero things out that may not be required.

  • Table of Content
    No. Content
    Key A key describes each input cell.
  • Reviews

    No Review. Write a review and be the first.

Related Products