Please solve this: You'll find the excel sheet in the picture. Thanks.

Below is information for a fully leased industrial building to two tenants containing a total of 120,000 sf. Note that each tenants space has been subdivided into office and warehouse space with different rents per square foot for each space. However, the expenses apply to all of the tenants leased space.

Total building square footage 120,000

Tenant A 40% of total building square footage

% Warehouse 85% $3.50 psf

% Office 15% $12.50 psf

Pass Thru Items: Property Taxes

Insurance

Term of lease- 11 years

Tenant B 60% of total Space

% Warehouse 70% $4.00 psf

% Office 30% $11.00 psf

Pass Thru Items: Property Taxes

Insurance

R & M

Term of lease-10 years

RET 3% of Market Value

Market Value $8,000,000

Property will not be ressessed until after year 10.

Insurance $0.40 psf

R & M $1.60 psf

Other information

No vacancy or credit loss is projected

Cap Ex/Improve $25,000/year (PAID by LANDLORD)