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.

NOTE 1:

It is aniticipated that this lease will not be renewed.

Space will be leased starting March 1 2022. Rate of $60/sq ft with 4 months free rent.

Landlord is also providing tenant with a $50/sq ft tenant inducement package. Lease is 10 years.

NOTE 2:

Landlord will replace oil boiler with a gas boiler which by January 1 2021.

This is expected to produce 30% in cost savings.

It will cost $50,000 to replace the boiler. Cost will be capitalized.

INSTRUCTIONS: Given the following data and rent roll, project the 2020, 2021 and 2022 NOI for the building. 13 Please make your calculations to the right of the data and rent roll on this worksheet. 4 Upload your file onto Moodle by the deadline indicated on the course outline. Also bring a paper copy to submit before the start of class. 16 Late submissions will automatically be given 0. NO EXCEPTIONS Grade (out of 5): 0 Projected inflation (CPD) 2020 22 2021 1. 0% 2022 2.0% 4 Expenses for 2018 Taxes Insurance $ 600,00 50,00 Maintenance & operations Security 400,000 Snow removal 75,000 Utilities 35,000 Depreciation $ 350,000 50.000 Retail sales for Unit 1 in 2020, 2021 and 2022 S 2,000,000 RENT ROLL Floor 1 Unit number Type of Space Unit 1 Lease start Retail Lease end 016-01-01 2 Lease type 025-12-31 3 Square footage Triple Net 4 Rent/sq ft 23,000 2020 25 2021 6 Percentage factor 7 Breakpoint 5% 25 5% $ 500,000 $ 510,000 $ 520,000 1 Floor 2 Unit number 3 Type of Space Unit 2 Lease start Office Lease end 017-01-01 026-12-3 Lease type 7 Square footage Gross 18 Rent/sq ft 0,000 2019 2020 50 +CPI Unit number Type of Space Unit 3 23 Lease start Office Lease end 017-06-01 Lease type 2027-06-01 Square footage Triple Net 7 Rent/sq fit 14.000 2020 2021 2022 2 Floor 3 Unit number Type of Space Unit 4 15 Lease start Office Lease end n/a Lease type Square footage Gross 9 Rent/sq it 25,000 80 2020 2021 202 vacant vacant Note 1 TOTAL BUILDING AREA 72,000 NOTE 1: It is aniticipated that this lease will not be renewed. 6 Space will be leased starting March 1 2022. Rate of $60/sq ft with 4 months free rent. 7 Landlord is also providing tenant with a $50/sq ft tenant inducement package. Lease is 10 years. 89 NOTE 2: Landlord will replace oil boiler with a gas boiler which by January 1 2021. 10% in cost savings. It will cost $50,000 to replace the boiler. Cost will be capitalized