Skip to content
×
PRO
Pro Members Get Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. Cancel anytime
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
Private Lending & Conventional Mortgage Advice
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated over 9 years ago,

Account Closed
  • Real Estate Professional
  • Ottawa, Ontario
0
Votes |
1
Posts

Waterfall Structure Help

Account Closed
  • Real Estate Professional
  • Ottawa, Ontario
Posted

Hi everyone, was hoping someone could help me! 

Im trying to set up a model that calculates Project Profit Margin (unlevered), Project Return on Cost (unlevered) and IRR for the problem below:

It's a condo development that has costs for 32 months then one lump sum of revenue once construction is completed.

Financing:

Loan of $18.5m,
Purchaser deposits of $2.5m
Equity - investor - $3m
Equity Developer - $1m

Costs:

Land - $7m
Soft costs - $6m (incurred equally every month)
Hard costs - $12m (incurred equally every month during construction)

Revenue:
$31m one month after construction

Waterfall Structure:

•Investor will contribute 75% of the equity and developer will contribute the remaining 25%

•Equity will be returned as follows: (1) both partners will receive a return of their equity pari passu, (2) 50/50 until Investor receives an IRR return of 20%, (3) 40/60 in favour of developer thereafter

The loan bears interest at 4.25% per annum

I'm having a hard time with this one :(