In cell E19, enter a VLookup function to calculate the annual base rent for the first unit based on Unit Type. Use the Year 1 Rental Assumptions table in your formula and make sure to calculate annual rent. Copy your formula down the column to cell E42.

B D G H L M N O 1 2022 (Year 1) Rental Assumptions 2022 Operating Expense Assumptions Extra Credit #of Units 2 3 4 4. 10 Unit Type 1 Bedroom 2 Bedroom 3 Bedroom Small Commercial Large Commercial Total Rent /Month $1,600 $2,200 $2.800 $3,200 $4400 $14,200 RSF per Unit 830 995 1,475 1,200 2,100 5 Total RSF by Unit Type 3320 9950 8,850 3600 2,100 27820 6 6 3 1 Mortgage Financ Purchase Price Down Payment Rate Down Payment Loan Amount Annual Interest Rate Loan Term Iyears) Monthly Debt Payment Annual Debt Payment 7 8 9 Expense Taxes Insurance Repairs & Maintenance Utilities Legal Accounting Janitorial Cleaning Management Fees Elevator Maint Security Brokerage Fee. Residential Brokerage Fee-Commercial Capital Reserves 24 2022 Expense Rate Per $30 453 $1.3767 Residential SF / year $8,000 $400 Residential Unit/year $1,440 $120 Residential Unit/month $5,760 $0.40 Per Common SF /month 54000 $4,000 Year $3,200 $3,200 Year $15.600 $150 Day of Cleaning $35.520 55 Dolar of Base Rent/year $900 $900 Year $59,904 $12 Hour $45,200 Monthly Rent Every 2 Years 2 $3.500 5% Total Lease Base Rent $13.910 $0.50 RSF 12 10 11 12 13 14 15 Number of months/year Residential Rent Increase Commercial Rent increase Comman Area Sq. Footage Vacancy & Collection Loss 2% 10% 1200 4.5% Annually Every 5 Years SF Annually 16 Income Unit # Unit Type 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Unit 1A Unit 18 Unit 1C Unit 1D Unit 24 Unit 26 Unit 2c Unit 2D Unit 3A Unit 3B Unit 3C Unit 3D Unit 4A Unit 4B Unit 4C Unit 4D Unit 5A Unit 58 1 Bedroom 2 Bedroom 2 Bedroom 3 Bedroom 1 Bedroom 2 Bedroom 2 Bedroom 3 Bedroom 1 Bedroom 2 Bedroom 2 Bedroom 3 Bedroom 1 Bedroom 2 Bedroom 2 Bedroom 3 Bedroom 2 Bedroom 2 Bedroom