Spreadsheet Problem. Rent tab in the Excel workbook provided on the website.
a. Suppose expenses increase by $2 per square foot each year instead of $1. Does this change which lease alternative has the lowest effective rent?
b. How much lower would the first year rent have to be on the gross lease with free rent and steps option for it to have the lowest effective rent?