Private Lending & Conventional Mortgage Advice
Market News & Data
General Info
Real Estate Strategies
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/hospitable-deef083b895516ce26951b0ca48cf8f170861d742d4a4cb6cf5d19396b5eaac6.png)
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_trust-2bcce80d03411a9e99a3cbcf4201c034562e18a3fc6eecd3fd22ecd5350c3aa5.avif)
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_1031_exchange-96bbcda3f8ad2d724c0ac759709c7e295979badd52e428240d6eaad5c8eff385.avif)
Real Estate Classifieds
Reviews & Feedback
Updated over 9 years ago on .
Waterfall Structure Help
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 :(