Spreadsheet: 687072d1594938296-min-max-calc-for-financial-projection-fm-mhc-model-excelforum-
Sheet: Waterfall

WATERFALL |  |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44
CASH FLOWS and FEES |  | IRR | Profit
 | Property Tier Cash Flow
GP Fees
 | Acquisition Fee
 | Debt Fee (Initial)
 | Debt Fee (Refi)
 | Asset Management Fee
 | Disposition Fee
 | TI Fee
 | LC Fee
 | Capital Improvement Fee
 | Total GP Fees
 | Cash Flows After Fees
SUMMARY DISTRIBUTIONS |  | % of Profit | Profit
 | LP Total Fund Tier Distributions
 | GP Total Fund Tier Distributions
 | Total Fund Tier Distributions
 | Check (Should be Zero)
 | IRR to LP
 | Equity Multiple
DETAILED DISTRIBUTIONS
Total Limited Partner |  | IRR | Profit
 | [NAME]
 | [NAME] Up
 | [NAME]
 | [NAME] Up
 | [NAME]
 | [NAME] Up
 | Remainder
 | Total Return
 |  | IRR | Profit
 | [NAME]
 | [NAME] Up
 | [NAME]
 | [NAME] Up
 | [NAME]
 | [NAME] Up
 | Remainder
 | Total Return
 |  | IRR | Profit
 | [NAME]
 | [NAME] Up
 | [NAME]
 | [NAME] Up
 | [NAME]
 | [NAME] Up
 | Remainder
 | Total Return
 |  | IRR | Profit
 | Tier 1 - GP
 | Tier 1 - GP + Catch Up
 | [NAME]
 | [NAME] Up
 | [NAME]
 | [NAME] Up
 | Remainder
 | Total Return w/out Fees
 | Total Return with Fees
 |  | IRR | Profit
 | [NAME]
 | [NAME] Flow+Catch Up
 | [NAME]
 | [NAME] Up
 | [NAME]
 | [NAME] Up
 | Remainder
 | Total Return w/out Fees
 | Total Return with Fees
WATERFALL CALCULATION |  |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44
Tier 1
 | Cash Available for Tier 1
 | LP Share of Tier 1
 | BOP Capital Balance
 | Accrued Preference
 | Paid Preference
 | Capital Contributions
 | Capital Distributions
 | EOP Capital Balance
 | GP Share of Tier 1
 | BOP Capital Balance
 | Accrued Preference
 | Paid Preference
 | Capital Contributions
 | Capital Distributions
 | EOP Capital Balance
 | Tier 1 LP (Contributions)/Distributions
 | Tier 1 GP (Contributions)/Distributions
Catch-Up Tier 1
 | Cash Available for Catch-Up Tier 1
 | [NAME] Tier 1 LP Profits
 | [NAME] Tier 1 GP Profits
 | Total Pre-Catch-up Tier 1 Profits
 | Cumulative LP Profits
 | Cumulative GP Profits
 | LP Tier 1 Catch -Up Distribution
 | GP Tier 1 Catch -Up Distribution
 | Total Catch-Up Tier 1
 | Post Catch-Up Tier 1 LP Profits
 | Post Catch-Up Tier 1 GP Profits
 | Total Post Catch-Up Tier 1 Profits
 | LP Profit %
 | GP Profit %
 | Cumulative LP Profits Through Catch-Up Tier 1
 | Cumulative GP Profits Through Catch-Up Tier 1
 | Total Cumulative Profits
 | LP Cumulative Profit %
 | GP Cumulative Profit %
[NAME]
 | Cash Available for Tier 2
 | LP Share of Tier 2
 | GP Share of Tier 2
 | BOP Capital Balance
 | Accrued Preference
 | Tier 1 Paid Preference
 | Waterfall Paid
 | [NAME]
 | Capital Contributions
 | Capital Distributions
 | EOP Capital Balance
 | [NAME] (Contributions)/Distributions
 | Tier 2 GP (Contributions)/Distributions
Catch-Up Tier 2
 | Cash Available for Catch-Up Tier 2
 | [NAME] Tier 2 LP Profits
 | [NAME] Tier 2 GP Profits
 | Total Pre-Catch-up Tier 1 Profits
 | Cumulative LP Profits
 | Cumulative GP Profits
 | LP Tier 2 Catch -Up Distribution
 | GP Tier 2 Catch -Up Distribution
 | Total Catch-Up Tier 2
 | Post Catch-Up Tier 2 LP Profits
 | Post Catch-Up Tier 2 GP Profits
 | Total Post Catch-Up Tier 2 Profits
 | LP Profit %
 | GP Profit %
 | Cumulative LP Profits Through Catch-Up Tier 2
 | Cumulative GP Profits Through Catch-Up Tier 2
 | Total Cumulative Profits
 | LP Cumulative Profit %
 | GP Cumulative Profit %
Tier 3
 | Cash Available for Tier 3
 | LP Share of Tier 3
 | GP Share of Tier 3
 | BOP Capital Balance
 | Accrued Preference
 | Tier 1 Paid Preference
 | [NAME]
 | Waterfall Paid
 | Tier 3 Paid Preference
 | Capital Contributions
 | Capital Distributions
 | EOP Capital Balance
 | Tier 3 LP (Contributions)/Distributions
 | Tier 3 GP (Contributions)/Distributions
Catch-Up Tier 3
 | Cash Available for Catch-Up Tier 3
 | [NAME] Tier 3 LP Profits
 | [NAME] Tier 3 GP Profits
 | Total Pre-Catch-up Tier 1 Profits
 | Cumulative LP Profits
 | Cumulative GP Profits
 | LP Tier 3 Catch -Up Distribution
 | GP Tier 3 Catch -Up Distribution
 | Total Catch-Up Tier 3
 | Post Catch-Up Tier 3 LP Profits
 | Post Catch-Up Tier 3 GP Profits
 | Total Post Catch-Up Tier 3 Profits
 | LP Profit %
 | GP Profit %
 | Cumulative LP Profits Through Catch-Up Tier 3
 | Cumulative GP Profits Through Catch-Up Tier 3
 | Total Cumulative Profits
 | LP Cumulative Profit %
 | GP Cumulative Profit %
Remainder
 | Remaining Cash Available
 | LP Share of Remainder
 | GP Share of Remainder
 | Cash Remaining
 | Lists and Other Data  - Do Not delete
 | Type of Compounding | # of Mos | Mos Between
 | Monthly | 12 | 1
 | Quarterly | 4 | 3 | No
 | Annual | 1 | 12
 | % of Purchase Price
 | % of EGR
 | % of NOI
 | % of Initial Equity