Waterfall Model for Joint Venture Real Estate Project

waterfall

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 effect the total cash returned for the project.

Note, Version 2 was recently added. It has logic to split cash flows in 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 has included an equity multiple minimum for the investor.

 

Users who purchased Waterfall Model for Joint Venture Real Estate Project, also purchased:
Residual Land Value Calculation
Add to wish list
Purchase Excluding 7.7% tax
Real Estate Developer Model
Real estate developer
Add to wish list
Purchase Excluding 7.7% tax
Commercial Real Estate Valuation Model
Commercial Real Estate Valuation
Add to wish list
Purchase Excluding 7.7% tax
Industry , ,
Summary Dynamic financial model for calculating cash splits to sponsors/investors based on various IRR hurdles getting reached.
Screenshots / Pictures Waterfall model for joint venture
Hurdles
w4
total equity
waterfall model proejct
Waterfall model for joint venture real estate project
Monthly Pro Forma
Use Cases , , , , , , , , , , , , , , ,

Reviews

  • perfect

    great model

    1 of 2 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 and be a buyer of this download to submit a review.

    Leave a Reply