Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the following data and rent roll, project the NOI of the building for the years 2021, 2022 and 2023 Projected inflation (CPI) Expenses for
Given the following data and rent roll, project the NOI of the building for the years 2021, 2022 and 2023
Projected inflation (CPI) Expenses for 2020 RENT ROLL Retail sales for Unit 1 in 2020 Floor 1 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Percentage factor Breakpoint Common Area Floor 2 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Common Area Floor 3 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Property taxes Insurance Maintenance & operations TOTAL LEASABLE TOTAL COMMON TOTAL BUILDING Security Snow removal Utilities Depreciation Unit 1 Retail 2017-01-01 2026-12-31 Triple Net 23,000 2021 25 5% 500,000 2,000 Unit 2 Office 2017-01-01 2026-12-31 Gross 10,000 2021 50 Unit 3 Office 2017-06-01 2027-06-01 Triple Net 14,000 2021 21 1,000 Unit 4 Office 2015-01-01 2022-12-31 Gross 25,000 2021 50 72,000 3,000 75,000 2021 2022 2023 2022 25 5% 510,000 2022 +CPI 2022 21 2022 50 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 1.0% 2.0% 3.0% 600,000 50,000 400,000 75,000 35,000 350,000 50,000 2,000,000 2023 26 5% 520,000 2023 +CPI 2023 21 2023 NOTE 1 Projected inflation (CPI) Expenses for 2020 RENT ROLL Retail sales for Unit 1 in 2020 Floor 1 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Percentage factor Breakpoint Common Area Floor 2 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Common Area Floor 3 Unit number Space vocation Lease start Lease end Lease type Square footage Rent/sq ft Property taxes Insurance Maintenance & operations TOTAL LEASABLE TOTAL COMMON TOTAL BUILDING Security Snow removal Utilities Depreciation Unit 1 Retail 2017-01-01 2026-12-31 Triple Net 23,000 2021 25 5% 500,000 2,000 Unit 2 Office 2017-01-01 2026-12-31 Gross 10,000 2021 50 Unit 3 Office 2017-06-01 2027-06-01 Triple Net 14,000 2021 21 1,000 Unit 4 Office 2015-01-01 2022-12-31 Gross 25,000 2021 50 72,000 3,000 75,000 2021 2022 2023 2022 25 5% 510,000 2022 +CPI 2022 21 2022 50 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 1.0% 2.0% 3.0% 600,000 50,000 400,000 75,000 35,000 350,000 50,000 2,000,000 2023 26 5% 520,000 2023 +CPI 2023 21 2023 NOTE 1Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started