Question: Complete pro forma for NOI. (Please show Excel) Commercial Complex 4 tenants Property will be held for 5 years Tenant Lease Type Size Current Lease

Complete pro forma for NOI. (Please show Excel)

Commercial Complex 4 tenants Property will be held for 5 years

Tenant

Lease Type

Size

Current Lease Rate

Rent Growth

CAM

Bank

NNN

Outparcel

$85,250/yr

2.15%

Retailer

Percentage

3,125

$4.50/ sq ft

Plus 4.55% revenue

Tenant revenue is expected to grow at 2.5% per year

Year 1 Revenues are $310,000

Limited to $2.75 per sq foot

Pro rata on sq feet

Office

9,600

$21.00/ sq ft

CPI

None

Office

4,375

$22.50/ sq ft

CPI

Limited to $5.25 per sq foot

Pro rata on sq feet

OP EX Category

Cost

Growth Rate

Utilities

$3.25 per sq ft

2.85% per year

Taxes

$11,627 per year

2.75% per year

Insurance

$2.75 per sq ft

2.0% per year

Maintenance

$3.15 per sq ft

3.15% per year

CPI

Rate

Years 1-3

1.75%

Years 4-7

2.25%

Years 8-10

3.25%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!