INSTRUCTIONS: Given the following data and rent roll, p Please make your calculations to the rig...

Transcribed Image Text:

INSTRUCTIONS: Given the following data and rent roll, p Please make your calculations to the rig Upload your file onto Moodle by the dea Projected inflation (CPI) 2021 1.0% 2022 2.0% 2023 3.0% Expenses for 2020 Property 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 2020 2,000,000 RENT ROLL Floor 1 Unit number Space vocation Unit 1 Retail Lease start 2017-01-01 Lease end 2026-12-31 Lease type Triple Net Square footage 23,000 Rent/sq ft 2021 2022 2023 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 2021 2022 2023 50 +CPI +CP Unit number Space vocation Unit 3 Office 2017-06-01 Lease start Lease end 2027-06-01 Lease type Triple Net Square footage Rent/sq ft 14,000 2021 2022 21 21 2023 21 Common Area 1,000 Floor 3 Unit number Unit 4 vocation Office INSTRUCTIONS: Given the following data and rent roll, p Please make your calculations to the rig Upload your file onto Moodle by the dea Projected inflation (CPI) 2021 1.0% 2022 2.0% 2023 3.0% Expenses for 2020 Property 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 2020 2,000,000 RENT ROLL Floor 1 Unit number Space vocation Unit 1 Retail Lease start 2017-01-01 Lease end 2026-12-31 Lease type Triple Net Square footage 23,000 Rent/sq ft 2021 2022 2023 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 2021 2022 2023 50 +CPI +CP Unit number Space vocation Unit 3 Office 2017-06-01 Lease start Lease end 2027-06-01 Lease type Triple Net Square footage Rent/sq ft 14,000 2021 2022 21 21 2023 21 Common Area 1,000 Floor 3 Unit number Unit 4 vocation Office