Question: please show excel work Part 1 - Rent Calculation . Assume the following for a floor in a multistory office building: total usable area: 36,000
Part 1 - Rent Calculation . Assume the following for a floor in a multistory office building: total usable area: 36,000 sq ft: Total common area: 4,000 sq ft: total rentable area: 40,000 sq ft: Tenant A's usable area: 6,500 sq ft. Tenant A's annual rental rate is $22 per sq ft. How much total rent does Tenant A pay per year? Part 2 - CAM An office complex has the following operating expenses in year one janitorial $14.500 insurance $14.500 maintenance $12,015 property taxes $7.653 landscaping $7.282 The following tenants have agreed to reimburse for CAM expenses according to the following lease terms Office 1(4,800 sq ft) Up to $3.25 psf Office 2 (4.600 sq ft) Up to $2.85 psf Office 3 (4.300 sq ft) Up to $2.90 psf Office 4 (3,000 sq ft) Up to $3.07 psf Deli (1,500 sq ft) Up to $1.75 psf Please show me your work to answer these questions, highlight your answers. 1. What is the Op Ex for year one? 2. What will each tenant reimburse in year one? 3. At the end of year one, what will be the unreimbursed amount? Please show your work/calculations in an Excel file. search o
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
