Please type out formula

please do math in excel

if any number is missing fill it in with a number you think is best.

CH. 9 - WHICH RENT IS BETTER - . Three options for you as a landlord for the next five years with expenses per sq ft starting at $20 and a discount rate of 6% Option 1: Base rent of $40 per sq ft Expenses will increase $1 per year Option 2: Base rent of $38 per sq ft There is a stop on expenses above $20 per sq ft (i.e. reimbursement for expenses above $20 per sq ft) Option 3: Base rent of $40 per sq ft, but six months for free in the first year Expenses will increase $1 per year Rent will increase to $49 for the last three years