INSTRUCTIONS:

Given the following data and rent roll, project the NOI of the building for the years $2024,2025$ and $2026$

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.

Grade $($out of $10)$:

Projected inflation $($CPI$)20241,0\%$

$20252,0\%$

$20263,0\%$

Expenses for $2023$

Property taxes $600000$

Insurance $50000$

Maintenance & operations $400000$

Security $75000$

Snow removal $35000$

Utilities $350000$

Depreciation $50000$

Retail sales for Unit $1$ in $20232000000$

RENT ROLL

Floor $1$

Unit number Unit $1$

Space vocation Retail

Lease start $2018-01-01$

Lease end $2027-12-31$

Lease type Triple Net

Square footage $23000$

Rent$/$sq ft $202420252026$

$252526$

Percentage factor $5\%5\%5\%$

Breakpoint $500000510000520000$

Common Area $2000$

Floor $2$

Unit number Unit $2$

Space vocation Office

Lease start $2018-01-01$

Lease end $2027-12-31$

Lease type Gross

Square footage $10000$

Rent$/$sq ft $202420252026$

$50+$CPI $+$CPI

Unit number Unit $3$

Space vocation Office

Lease start $2018-06-01$

Lease end $2028-06-01$

Lease type Triple Net

Square footage $14000$

Rent$/$sq ft $202420252026$

$212121$

Common Area $1000$

Floor $3$

Unit number Unit $4$

Space vocation Office

Lease start $2016-01-01$

Lease end $2025-12-31$

Lease type Gross

Square footage $25000$

Rent$/$sq ft $202420252026$

$5050$ NOTE $1$

TOTAL LEASABLE $72000$

TOTAL COMMON $3000$

TOTAL BUILDING $75000$

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