Just for unit 1 please so I can understand how to do it
INSTRUCTIONS: Given the following data and rent roll, project the 2020, 2021 and 2022 NOI for the building. Please make your calculations to the right of the "data and rent roll" on this worksheet. Upload your file onto Moodle by the deadline indicated on the course outline. Grade (out of 10): Projected inflation (CPI] 2020 1.0% 2021 2.0% 2022 3.0% Expenses for 2019 Taxes 600,000 Insurance 50,000 Maintenance & operations 400,000 Security 75,000 Snow removal 35,000 Utilities 350,000 Depreciation 50,000 Retail sales for Unit 1 in 2019 2,000,000RENT ROLL Floor 1 Unit number Unit 1 Space vocation Retail Lease start 2016-01-01 Lease end 2025-12-31 Lease type Triple Net Square footage 23,000 Rent'sq ft 2020 2021 2022 25 25 26 Percentage factor 5% 5% 5% Breakpoint 500,000 510,000 520,000 Common Area 2.000 Floor 2 Unit number Unit 2 Space vocation Office Lease start 2017-01-01 Lease end 2026-12-31 Lease type Gross Square footage 10,000 Rent'sq ft 2020 2021 2022 50 + CPI + CPI Unit number Unit 3 Space vocation Office Lease start 2017-06-01 Lease end 2027-06-01 Lease type Triple Net Square footage 14.000 Rent'sq ft 2020 2021 2022 21 21 21 Common Area 1,00050 + CPI + CPI Unit number Unit 3 Space vocation Office Base Lease start 2017-06-01 Perc Lease end 2027-06-01 Exp Lease type Triple Net Total Square footage 14.000 NOI Rent'sq ft 2020 2021 2022 21 21 21 Common Area 1.000 Floor 3 Unit number Unit 4 Space vocation Office Base Lease start 2015-01-01 Perc Lease end 2021-12-31 Exp Lease type Gross Tota Square footage 25.000 Exp Rent'sq ft 2020 2021 2022 NE 50 50 NOTE 1 NOI TOTAL LEASABLE 72.000 TOTAL COMMON 3.000 TOTAL BUILDING 75.000 NOTE 1: It is aniticipated that this lease will not be renewed. The unit will be vacant for 3 months. The new lease will have a free rent period of 3 months and a base rent (gross) of $60)sq ft