Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. 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 on .

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 :(