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.
Similar Products
Other customers were also interested in...
Mixed-Use Real Estate Model: Leverage / JV Options
A general real estate model to plan all assumptions for up to 7 'uses' for a given property. Include... Read more
Real Estate Financial Model Bundle
This is a collection of financial model templates that provides the financial projections and valuat... Read more
Real Estate Brokerage Economic Analysis
Create up to a 10 year financial forecast for a real estate brokerage operator. Includes three way m... Read more
Commercial Real Estate – Lease or Sell Quart...
Commercial Real Estate - Lease or Sell Quarterly Excel Model with 3 Statements, Valuation, and Devel... Read more
Hotel Development REIT Financial Model Excel Templ...
Get the Best Hotel Development REIT Financial Model. Excel Template for your pitch deck to convince ... Read more
Self Storage Financial Model (Construction, Operat...
Considering investing in a self-storage facility? This might be an easier way for entry-level real e... Read more
Shopping Mall Financial Model
Shopping Mall Financial Model presents the case of an investment into a shopping mall and its operat... Read more
Warehouse Development Financial Model
This is a detailed, well-structured and transparent cash flow model for the development of... Read more
Real Estate Multi-Family Development Excel Model
Real Estate Financial Model to evaluate a development project, with Equity Waterfall and Advanced Sc... Read more
Real Estate Acquisition-Rent-Sell Comprehensive An...
An integrated, dynamic and ready-to-use Real Estate Acquisition-Rent-Sell Comprehensive Analysis Mod... Read more
Reviews
great model
411 of 836 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
-
Thx
416 of 865 people found this review helpful.
Help other customers find the most helpful reviews
Did you find this review helpful?
You must log in to submit a review.