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

Asset Name | TEST |  |  |  | EQUITY |  |  |  |  | DEBT |  |  |  |  | Operating Expense | IP $[NAME] | IP %TR | % GPR | Min $ | Max $ | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly Sensitivity | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | TOTAL
Acquisition Date | 2020-08-01 00:00:00 |  | WF Period: | Annual | TIR Equities | 1 |  |  |  |  | Loan 1 | Loan 2 | Loan 3/Refi |  | Adjustments |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0.3 | 0.2 | 0.2 | 0.2 | 0.1 | 0 | 0 | 0 | 0 | 0
Hold Period | 5 |  | Mths/Period: |  | LP Name 2 | 0 |  |  |  | Loan Type | None | None | None |  | Reimbursements |  |  | 0.0976 | 150000 | 0
[NAME] Costs | No |  | Monthly IRR: | No | Total LP |  |  |  |  | [NAME] | LC |  |  |  | Fee Recurring |  |  | 0.021 | 1 | 0 |  |  | Vacant Fill |  | initial | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Vacant Fill | 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 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120
[NAME]: | No |  | TI Fee | 0 | TIR Equities |  |  |  |  | Funding Month (BOP): | 1 | 0 | 36 |  | Other Income |  |  | 0.0175 | 1 | 0
Reserves/Unit: | 5 |  | Const Fee: | 0 | Total Equity |  |  |  |  | Term | 36 | 1 | 84 |  | Credit Loss |  |  |  | 0 | 0 |  |  | Single | Beginning Unit Count
Annual Rent Inc %: | 0.0375 |  | Leasing Fee: | 0 | WATERFALL TERMS |  |  |  |  | Rate Type | Fixed Rate | Fixed Rate | Fixed Rate |  |  |  |  |  |  |  |  |  |  | Units Filled, Net |  | 20 | 40 | 60 | 80 | 60
Dispositon Date |  |  | Sales Cost: | 0 |  | TIER 1 | TIER 2 | TIER 3 | Remaining | Subordination: | Senior | Senior | Senior |  | Property Management Fee |  |  | 0.05000000000000001 | 0 | 0 |  |  |  | Ending Unit Count
Term [NAME]: | 0.07 |  | Asset Mgmt: | 0.015 | [NAME] | Yes | No | No | Yes | Funding Method: | Amount | Amount | Amount |  |  |  |  |  |  |  |  |  |  | New Resident Deposit
Disposition Fee: | 0.02 |  | Debt Fee ([NAME]): | 0.01 | Compounding | Annual | Annual | Annual |  | Cap-Ex Funding | No | No | No |  | On-Site Management |  |  | 0 | 45000 | 0 |  |  |  | Rent Increase
Pricing | Community | Leased Homes |  |  | [NAME] | Yes |  |  |  | FUNDING |  |  |  |  | On-Site Office Personnel |  |  |  | 27500 | 0 |  |  |  | Gross Potential Rent
O/I | Yes | Yes |  |  | Periodocity Rate |  |  |  |  | Valuation |  |  |  |  | On-Site Maintenance Personnel |  |  |  | 40000 | 0 |  |  | Multi | Beginning Unit Count
Units |  |  |  |  | Apply Catch-UP | Yes | No | No |  | LTV% | 0.9 | 0 | 0.7 |  | On-Site Sales Director |  |  |  | 0 |  |  |  |  | Units Filled, Net
Annual Rev |  |  |  |  |  |  |  |  |  | Funding Amount |  |  |  |  | On-Site Finance Director |  |  |  | 0 |  |  |  |  | Ending Unit Count
Expenses |  |  |  |  | [NAME] | 0.08 | 0 | 0 |  | Loan Fee | 0 | 0 | 0 |  | Security |  |  |  | 0 |  |  |  |  | New Resident Deposit
NOI |  |  |  |  | Cash Flow Split |  |  |  |  | Prepayment % | 0 | 0 | 0 |  | Seasonal Wages |  |  |  | 0 |  |  |  |  | Rent Increase
[NAME] | 0.0347 | 0 |  |  | [NAME] |  |  |  |  | P&I Payment |  |  |  |  | Bonus/Commissions |  |  |  | 0 |  |  |  |  | Gross Potential Rent
SubTotal |  |  |  |  | Catch Up Split |  |  |  |  | Index Rate @ Funding: |  |  |  |  | Contract Labor |  |  |  | 0 |  |  |  | Total | Beginning Unit Count
Total Acquisition Price |  |  |  |  |  |  |  |  |  | Spread: | 0 | 0 | 0 |  | On-Site Salaries & Wages |  |  |  |  |  | 0.012 |  |  | Units Filled
CLOSING COSTS: |  |  |  |  | [NAME] |  |  |  |  | Interest Rate | 0.055 | 0 | 0.05 |  |  |  |  |  |  |  |  |  |  | Ending Unit Count
[NAME] | Yes |  |  |  | Cash Flow Split |  |  |  |  | Interest Calc: | 30/360 | 30/360 | 30/360 |  | Payroll Tax |  |  | 0.11 | 0 | 0 |  |  |  | New Resident Deposit
Auditor | No |  |  |  | [NAME] |  |  |  |  | IO Period (M) | 0 | 0 | 0 |  | Workers Compensation |  |  |  | 0 | 0
Due Diligence | 0.01 |  |  |  | Catch Up Split |  |  |  |  |  | 360 | 360 | 360 |  | Healthcare Allocation |  |  |  | 0 | 0 |  |  | Homes for Lease |  | initial | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Homes Leased | 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 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120
Legal | Yes |  |  |  | TOTAL |  |  |  |  | Cap-Ex Funding |  |  |  |  | 401K |  |  |  | 0 | 0
Transfer Tax | 0.01 |  |  |  | [NAME] |  |  |  |  | TI % | 0 |  |  |  | Vacation & Holiday Pay |  |  |  | 0 | 0 |  |  | Rent | 231
Title Insurance | 0.00083 |  |  |  | Cash Flow Split |  |  |  |  | LC % | 0 |  |  |  | Uniforms |  |  |  | 0 | 0 |  |  | Single | Beginning Unit Count
Brokerage | 0 |  |  |  | [NAME] |  |  |  |  | Other Capital % | 0.7 | 0 | 0 |  | Payroll Processing |  |  |  | 0 | 0 |  |  |  | Units Leased
Acquisition Fee: | 0.01 | of Acquisition Price |  |  | Catch Up Split |  |  |  |  | Draw Period (M) | 12 | 0 | 0 |  | Misc |  |  |  | 0 | 0 |  |  |  | Ending Unit Count
Debt Fee (Initial): |  | of Total Debt at Acq |  |  |  |  |  |  |  | Refinance Inputs |  |  |  |  | Staff Benefits |  |  |  |  |  |  |  |  | New Resident Deposit
Equity Cost | 0 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Multi | Beginning Unit Count
Total Closing Costs |  |  |  |  | Cash Flow Split |  | 0.3 | 0.4 | 0.5 |  |  | No | Yes |  | Utilities & Services Expense |  |  | 0.1375 | 50000 | 250000 | 0 |  |  | Units Leased
SUMMARY |  |  |  |  | [NAME] | 0.2 | 0.3 | 0.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ending Unit Count
Purchase Price: |  |  |  |  | Catch Up Split | 0.5 | 0.5 | 0.5 |  |  |  |  | No |  | Utilities & Services R&M |  |  | 0.015 | 0 | 2500 |  |  |  | New Resident Deposit
[NAME] |  |  |  |  |  |  |  |  |  | Total [NAME]: |  |  |  |  | Grounds R&M |  |  | 0.035 | 0 | 7500 |  |  | Total | Beginning Unit Count
Closing Costs: |  |  |  |  |  |  |  |  |  | Fund This Balance? | No | No | Yes |  | Landscaping R&M |  |  | 0.035 | 0 | 10000 |  |  |  | Units Leased
Total Purchase Price |  |  |  |  |  |  |  |  |  | Loan Summary |  |  |  |  | Building/Leased Units R&M |  |  | 0.02 | 0 | 17500 |  |  |  | Ending Unit Count
Initial Loan Amount: |  |  |  |  |  |  |  |  |  | Start Date: |  |  |  |  | Equipment & Supplies R&M |  |  | 0.01 | 0 | 1500 |  |  |  | New Resident Deposit
Equity Contribution |  |  |  |  |  |  |  |  |  | End Cap-Ex: |  |  |  |  | Other R&M |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Amort Begin: |  |  |  |  | TOTAL R&M
 |  |  |  |  |  |  |  |  |  | Initial Balance: |  |  |  |  | Taxes |  |  | 0.15 | 0 | 135000 | 0.012
 |  |  |  |  |  |  |  |  |  | [NAME]: |  |  |  |  | Insurance |  |  | 0.0225 | 0 | 37500
 |  |  |  |  |  |  |  |  |  | Bal To Amortize: |  |  |  |  | Professional Fees |  |  | 0.015 | 0 | 15000
 |  |  |  |  |  |  |  |  |  | Ending Balance: |  |  |  |  | Advertising & Marketing |  |  | 0.01 | 0 | 5000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Travel & Entertainment |  |  | 0.0013 | 0 | 1500
 |  |  |  |  |  |  |  |  |  | Int/Total Balance: |  |  |  |  | General & Administrative |  |  | 0.0233 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Principal Payment:
 |  |  |  |  |  |  |  |  |  | Total P&I:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Warnings