Information is given. Solve for Part 2. Please show excel work.

E This project requires you to compute the effective rent for five alternatives for a fiveyear lease on 15,000 square feet of rentable space. Assume a discount rate of 8 percent. In your report, mention which rent type should be chosen to maximize the price per square foot. Part 1: Gross lease Rent will be $30.00 per rentable square foot each year. The lessor (owner) will be responsible forthe payment of all operating expenses. Expenses are estimated to be $10.00 during the first year and will increase by 52.00 per year thereafter. (16 Points] Part 2: Gross lease with expense Rent will be $28.00 per rentable square foot per year with the lessor responsible for payment of recoverable operating expenses as identified in the lease, up to an expense stop of $10.00 per square foot. Lessee pays all expenses _i_r]__e_xc_e__9_f $10.00 per square foot. Expenses are estimated to be $10.00 during the first year and will increase by $2.00 per year thereafter. [16 Points] Part 3: Gross lease with step up rents Rent will be $15.00 per rentable square foot and will increase by $7.00 per square foot each year thereafter. Operating expense will be $10.00 per square foot and will increase by $0.50 per year. {16 Points] Part 4: Gross lease with step up rents and expense stop Rents will be $22.00 per square foot and will increase by $2 per year. Operating expenses will be $10.00 and will increase by $2.00 per year. The tenant will pay [the owner will recover) all increases in operating expense above a $10.00 expense stop. [16 Points} Part 5: Gross lease with expense stop and CPI adiustment Rent will be $20.00 per rentable square foot the first year and will increase by the full amount of any change in the CPI after the first year with an expense stop at 510.00 per square foot. The CPI is estimated to be 5% in year 2 and is estimated to increase at a rate of 25% per year (2g it will be 6.25% in year 3]. Operating expenses are assumed to be $3 per square foot and will increase by $3 per year thereafter. (15 Points] 20 21 Part 2: Gross lease with expense stop 22 23 Year 1 2 3 4 5 24 Gross Rent 25 Operating Expenses 26 Recoveries 27 Net Rent 28 29 Present Value 30 Effective Net Rent 31 32