RES 334 Week 4 Lease Evaluation Assignment To complete the following assignment, go to this week’s Assignment link in the left navigation. Lease Evaluation Evaluate different lease options: Chapter 9 Problem #1 A building owner is evaluating the following alternatives for leasing space in an office building in for the next five years: Net lease with steps. Rent will be $15 per square foot the first year and will increase by $1.50 per square foot each year until the end of the lease. All operating expenses will be paid by the tenant. Net lease with CPI adjustments. The rent will be $16 per square foot for the first year. After the first year, the rent will be increased by the amount of any increase in the CPI. The CPI is expected to increase 3% per year. Gross lease. Rent will be $30 per square foot each year with the lessor response will for payment of all operating expenses. Expenses are estimated to be 9 dollars during the first year in decreased by 1 dollar per year thereafter. Cruise lease with expense stop and CPI adjustment. Rent will be $22 the first year and increased by the full amount of any change in the CPI after the first year with the expense stop at $9 per square foot. The CPI and operating expenses are assumed to change by the same amount as outlined above. Â· Calculate the effective rent to the owner (after expenses) for each lease alternative using a 10% discount rate. Â· How would you rank the alternatives in terms of risk to the property owner? Â· Considering your answers to part (A) and (B), how would you compare the four alternatives? You are expected to provide a detailed solution to the above referenced problems. Since this assignment is based on calculations only an Excel is required. Make sure to complete all work in your spreadsheet for full credit.