$45.00 USD
Latest Upgrades:
- Updated to include up to 4 properties / acquisitions that can easily be turned on or off with a 'on/off' selector. Each deal has its own inputs for all assumptions, debt, refi, and joint venture waterfall. Data is shown individually and consolidated.
- Added a DCF Analysis with NPV for each individual property and as an aggregate.
The main purpose of using IRR hurdles is so an investor can give an incentive to the sponsor to try and get better returns for them. You can think of this as profit sharing driven by return performance. The investor pool will be willing to give the sponsor a greater portion of the profits depending on how high their IRR is.
For example, the cash flow may be split 80/20 up to 8% IRR, then from 8% to 12% it may be split 70/30. The investor would almost always have the higher share since they will be contributing the most equity. It is worth it for them to be willing to share more of the cash flow if it means a greater IRR and more overall cash returned. The first hurdle can almost be thought of as a preferred return as it states all cash flow is split x%/y% up to that first hurdle and if that hurdle is never reached, the sponsor would not get any kind of promote in their share of the profits.
This type of waterfall distribution is really complex to get to work in excel. I have done it on a monthly level in other models, but never on an annual basis nor with logic to account for a refinance event in the middle of the project. Having this new template will cover a lot more needs that users have within the space.
The logic for how cash flows are split is really hard to do in your head. I don't think it is actually possible to do unless you have it in an excel model or some program. This template will show you how each tier fills up the buckets of the sponsor and investor and then as soon as a hurdle is reached, the remaining cash flow goes into the next tier and is split according to that promote schedule. It is all dynamic per the inputs and defined promotes/hurdles.
The logic for the refinance is also complex, but it allows you to dynamically see the debt service and cash available no matter what year you refinance and what year you exit.
The rest of the model is fairly common for the multi-family real estate acquisition space. You have various variables that define revenues, expenses, and the growth of both. I did put in some drop-downs so you can avoid the detailed population of unit makeup and expenses and just put in a single number for current revenue and expenses. If you would like, the model allows you to pick 'detailed assumptions' or 'high-level assumptions'.
The executive summary is what was designed to be printable. I built this in because the Pro-forma detail tab is too busy and has too many light yellow input cells to make look ready for printing.
Other than that, this template has just about everything you need to analyze real estate deals quickly and have something that is straight forward to investors.
For example, the cash flow may be split 80/20 up to 8% IRR, then from 8% to 12% it may be split 70/30. The investor would almost always have the higher share since they will be contributing the most equity. It is worth it for them to be willing to share more of the cash flow if it means a greater IRR and more overall cash returned. The first hurdle can almost be thought of as a preferred return as it states all cash flow is split x%/y% up to that first hurdle and if that hurdle is never reached, the sponsor would not get any kind of promote in their share of the profits.
This type of waterfall distribution is really complex to get to work in excel. I have done it on a monthly level in other models, but never on an annual basis nor with logic to account for a refinance event in the middle of the project. Having this new template will cover a lot more needs that users have within the space.
The logic for how cash flows are split is really hard to do in your head. I don't think it is actually possible to do unless you have it in an excel model or some program. This template will show you how each tier fills up the buckets of the sponsor and investor and then as soon as a hurdle is reached, the remaining cash flow goes into the next tier and is split according to that promote schedule. It is all dynamic per the inputs and defined promotes/hurdles.
The logic for the refinance is also complex, but it allows you to dynamically see the debt service and cash available no matter what year you refinance and what year you exit.
The rest of the model is fairly common for the multi-family real estate acquisition space. You have various variables that define revenues, expenses, and the growth of both. I did put in some drop-downs so you can avoid the detailed population of unit makeup and expenses and just put in a single number for current revenue and expenses. If you would like, the model allows you to pick 'detailed assumptions' or 'high-level assumptions'.
The executive summary is what was designed to be printable. I built this in because the Pro-forma detail tab is too busy and has too many light yellow input cells to make look ready for printing.
Other than that, this template has just about everything you need to analyze real estate deals quickly and have something that is straight forward to investors.
Here are some things to focus on in the real estate investing space that can give you a competitive advantage.
Related Real Estate Financial Models:
Related Real Estate Financial Models:
- Retail Building Construction
- Lot Development
- Strip Mall Acquisition Model
- Apartment Building
- Single Tenant Industrial
- Mobile Home Parks
- Mixed-Use Real Estate
- Self Storage: Up to 6 Deals
- Rental Property Scaling
- Condo Development
- STRs (Short-term Rentals)
- Unit-Based Real Estate Acquisition
- Assisted Living Facility / Nursing Home
- Short-term Rental Arbitrage
- Hotel Development / Acquisition
- IRR Sensitivity Analysis (occupancy)
- Real Estate Flipping Calculator
- Property Management Business
- Real Estate Brokerage
- Real Estate Development
- Real Estate Checklist
- Rental Property ROI Calculator
- Seller Financing
- General Cash Flow Waterfall: 3 IRR Hurdles
- General Cash Flow Waterfall: 3 IRR Hurdles and GP Catch-up Provision
- Preferred Equity
- Preferred Return
- Zero Down Seller Financing
- Cost Segregation Study
