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.

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

 

Users who purchased Waterfall Model for Joint Venture Real Estate Project, also purchased:
Financial Modeling – Actual vs Budget and Previous Year
Add to wish list
Purchase Excluding 7.7% tax
Consolidated Financial Statements Actual vs. Budget
Income Statement Consolidated
Add to wish list
Purchase Excluding 7.7% tax
Peer to peer (P2P) lending Investing Model
Banking concept 3D
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 to submit a review.

    Leave a Reply