Help - Real Estate Waterfall (Promote Levels, IRR Lookback)

[wesgrammer]

Would like assistance finalizing a waterfall tab in an excel model. Model already includes tabs to define cash flow, debt payments, etc. Need help working a contract's waterfall description into excel. Have a good start, but need assistance finalizing. Let me know if you can help.. Thanks.

 

[Trevor G]

Welcome to the Forum,

If you mean waterfall charts take a look at this link as it gives you step by step guidance.

http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/

 

[wesgrammer]

Sorry... I mean the waterfall from a real estate cashflow to the partnership. A breakdown of operating partner and capital partner IRR. Thanks.