INSTRUCTIONS: Given the following data and rent roll, project the NOI of the building for the...

Transcribed Image Text:

INSTRUCTIONS: Given the following data and rent roll, project the NOI of the building for the years 2021, 2022 and 2023 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. Projected inflation (CPI) 2021 1.0% 2022 2.0% 2023 3.0% Expenses for 2020 Property taxes Insurance Maintenance & operations Security Snow removal Utilities Depreciation Retail sales for Unit 1 in 2020 RENT ROLL Floor 1 Unit number Space vocation Unit 1 Retail Lease start 2017-01-01 Lease end Lease type 2026-12-31 Triple Net Square footage Rent/sq ft 23,000 2021 Percentage factor 600,000 50,000 400,000 75,000 35,000 350,000 50,000 2,000,000 2022 2023 25 25 26 5% 5% 5% 500,000 510,000 520,000 Breakpoint 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/sqft 2021 2022 2023 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/sqft 2021 2022 21 21 2023 21 Common Area 1,000 Floor 3 Unit number Unit 4 Space vocation Office Lease start 2015-01-01 Lease end 2022-12-31 Lease type Gross Square footage 25,000 Rent/sqft 2021 50 2022 50 2023 NOTE 1 TOTAL LEASABLE TOTAL COMMON TOTAL BUILDING 72,000 3,000 75,000 NOTE 1: It is anticipated 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 Grad INSTRUCTIONS: Given the following data and rent roll, project the NOI of the building for the years 2021, 2022 and 2023 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. Projected inflation (CPI) 2021 1.0% 2022 2.0% 2023 3.0% Expenses for 2020 Property taxes Insurance Maintenance & operations Security Snow removal Utilities Depreciation Retail sales for Unit 1 in 2020 RENT ROLL Floor 1 Unit number Space vocation Unit 1 Retail Lease start 2017-01-01 Lease end Lease type 2026-12-31 Triple Net Square footage Rent/sq ft 23,000 2021 Percentage factor 600,000 50,000 400,000 75,000 35,000 350,000 50,000 2,000,000 2022 2023 25 25 26 5% 5% 5% 500,000 510,000 520,000 Breakpoint 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/sqft 2021 2022 2023 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/sqft 2021 2022 21 21 2023 21 Common Area 1,000 Floor 3 Unit number Unit 4 Space vocation Office Lease start 2015-01-01 Lease end 2022-12-31 Lease type Gross Square footage 25,000 Rent/sqft 2021 50 2022 50 2023 NOTE 1 TOTAL LEASABLE TOTAL COMMON TOTAL BUILDING 72,000 3,000 75,000 NOTE 1: It is anticipated 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 Grad