17 - Equity Waterfall Modeling WalkThrough
18 - Modeling GP LP Cash Flow Splits
19 - Building Out The Investment Timeline
20 - Modeling ProjectLevel Cash Flows
21 - Building Out The NOI
22 - Modeling Principal Interest Payments
23 - Purchase Loan Metrics
24 - Disposition Metrics
25 - Modeling Loan Payoff ProjectLevel Cash Flows
26 - Modeling The Preferred Return
27 - Beginning Balance Preferred Interest Accrual
28 - Modeling The Preferred Return Over Time
29 - Modeling LP Contributions Distributions
30 - Modeling GP Contributions Distributions
31 - Total Distributions Cash Flow Remaining
32 - Modeling Hurdle 2
33 - Beginning Balance Hurdle 2 Accrual
34 - Modeling Hurdle 2 LP Distributions Total Cash Flow
35 - Modeling Hurdle 2 GP Distributions
36 - Modeling Hurdle 3
37 - Hurdle 3 GP Distributions
38 - Modeling Hurdle 4
39 - Total LP Cash Flows Returns
40 - Total GP Cash Flows Returns
41 - ProjectLevel Return Metrics
42 - Calculating Promoted Interest
42 - Real-Estate-Equity-Waterfall-Model-Final.xlsx