Please see the attached document. Also, please show all work i need to know and be able to figure out how you arrived at your calculations.

An office building has three floors of rentable space with a single tenant on each floor. The first floor has 20,000 square feet of rentable space and is currently renting fo years remain on the lease. The lease has an expense stop at $4 per square foot. The second floor has 15,000 square feet of rentable space and is leasing for $15.50 per years remaining on the lease. This lease has an expense stop at $4.50 per square foot. The third floor has 15,000 square feet of leasable space and a leasejust signed for rate of $17 per square foot, which is the current market rate. The expense stop at $5 per square foot, which is what expenses per square foot are estimated to be during managment). Managemnet expenses are expected to be 5 percent of the effective gross income and are not included in the expense stop. Each lease also has a CPI adju base rent to increase at half the increase in the CPI. The CPI is projected to increase 3 percent per year. Estimated operating expenses for the next year include the follo Property taxes insurance utilities Janitorial Maintenance 100000 10000 75000 25000 40000 total 250000 All expenses are projected to incrase 3 percent per year. The market rental rate at which leases are expected to be renewed is also projected to increase 3 percent per year. When a lease is renewed, it will have an expense stop equal to operating expenses per square foot during the first year of the lease. To account for any time that may be necessary to find new tenants after the first leases expire, vacancy is estimated to be 10 percent of EGI for the last tow years (years 4 and 5). a. b. c. d. e. Project the effective gross income (EGI) for the next five years. Project the expense reimbursments for the next five years. Project the net operating (NOI) for the next five years. How much does the NOI increase the (average compound rate) over the five years? Assuming the property is purchased for $5 million, what is the overall capitalization rate ("going-in" rate)? g for $15 per square foot. Thre er square foot and has four for the next five years at a rental ring the next year (excluding djustment that provides for the ollowing