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 rent roll on this worksheet.
ata and
Title Subtitle Subtle Em... Emphasis Intense E... Strong Quote Font Paragraph Styles INSTRUCTIONS: Common Area 2.000 Given the following data and rent roll, project the NOI of the building for the years 2021, 2022 and 2023 Floor 2 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. Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Unit 2 office 2017-01-01 2026-12-31 Gross 10,000 2021 50 2023 2012 HCPI +CHI Projected inflation (CPU) 2021 2022 2023 1.0% 2.0% 3.0% Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Unit 3 Office 2017-06-01 2027-06-01 Triple Net 14,000 2021 21 2022 21 2023 21 Expenses for 2020 Property taxes Insurance Maintenance & operations Security Snow removal Utilities Depreciation 600,000 50,000 400,000 75,000 35,000 350,000 50,000 Common Area 1,000 Floor 3 Unit 4 Retail sales for Unit 1 in 2020 2,000,000 Office RENT ROU Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft 2015-01-01 2022-12-31 Gross 25,000 2021 50 Floor 1 2022 50 2023 NOTE 1 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Unit 1 Retail 2017-01-01 2026-12-31 Triple Net 23,000 2021 25 596 500,000 TOTAL LEASABLE TOTAL COMMON TOTAL BUILDING 72,000 3,000 75,000 2023 26 2022 25 5% 510,000 Percentage factor Breakpoint 595 520,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 anada) Title Subtitle Subtle Em... Emphasis Intense E... Strong Quote Font Paragraph Styles INSTRUCTIONS: Common Area 2.000 Given the following data and rent roll, project the NOI of the building for the years 2021, 2022 and 2023 Floor 2 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. Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Unit 2 office 2017-01-01 2026-12-31 Gross 10,000 2021 50 2023 2012 HCPI +CHI Projected inflation (CPU) 2021 2022 2023 1.0% 2.0% 3.0% Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Unit 3 Office 2017-06-01 2027-06-01 Triple Net 14,000 2021 21 2022 21 2023 21 Expenses for 2020 Property taxes Insurance Maintenance & operations Security Snow removal Utilities Depreciation 600,000 50,000 400,000 75,000 35,000 350,000 50,000 Common Area 1,000 Floor 3 Unit 4 Retail sales for Unit 1 in 2020 2,000,000 Office RENT ROU Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft 2015-01-01 2022-12-31 Gross 25,000 2021 50 Floor 1 2022 50 2023 NOTE 1 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Unit 1 Retail 2017-01-01 2026-12-31 Triple Net 23,000 2021 25 596 500,000 TOTAL LEASABLE TOTAL COMMON TOTAL BUILDING 72,000 3,000 75,000 2023 26 2022 25 5% 510,000 Percentage factor Breakpoint 595 520,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 anada)
