PlAn office building has three floors of rentable space with a single tenant on each floor. The first floor has $20,120$ square feet of rentable space and is currently renting for $$15$ per square foot. Three years remain on the lease. The lease has an expense stop at $$4$ per square foot. The second floor has $15,120$ square feet of rentable space and is leasing for $$15\mathrm{.}50$ per square foot and has four years remaining on the lease. This lease has an expense stop at $$4\mathrm{.}50$ per square foot. The third floor has $15,120$ square feet of leasable space and a lease just signed for the next five years at a rental rate of $$17$ per square foot, which is the current market rate. The expense stop is at $$5$ per square foot, which is what expenses per square foot are estimated to be during the next year $($excluding management$).$ Management expenses are expected to be $5$ percent of effective gross income and are not included in the expense stop. Each lease also has a CPI adjustment that provides for the 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 following:

$\backslash$table$[[$Property taxes,$$100,300$

PLEASE SHOW EXCEL FORMULAS!!