Waterfall Model for Joint Venture Real Estate Project

Dynamic financial model for calculating cash splits to sponsors/investors based on various IRR hurdles getting reached.

, , ,
, , , , , , , , , , , , , , , ,

Video Tutorial:

This is a waterfall build that has been combined with a dynamic pro-forma real estate template. The cash flow available for split will populate into the waterfall model automatically.

You can adjust a bunch of assumptions that define the cash generated by the real estate pro-forma, including an exit value, rent increases, debt, and operating expenses / startup costs.

Every progressive hurdle that gets met means any future cash flows are split at the new promote % for the sponsor/investor.

I have added charts in order to clearly show how the hurdles affect the total cash returned for the project.

Note, Version 2 was recently added. It has logic to split cash flows at a secondary level (i.e., if the cash flow to the investor or sponsor goes to two other parties and they, in turn, have their own promotes based on the hurdles. Also, it functions by simply inputting the project cash flows per month as well as includes an equity multiple minimum for the investor.

Version 3 is the same as version 1, except it allows the user to look at 5 different scenarios at once and see the resulting sponsor/investor cash flows and final IRRs.

Reviews

  • perfect

    great model

    411 of 836 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • You must log in to submit a review.