A company is considering replacing its asphalt parking lots with concrete, at first cost of $1,200,000, and an annual maintenance cost of $15,000. Another option is also available, which is resurfacing the parking lots with asphalt with a first cost of $1,000,000 and an annual maintenance cost of $50,000. MARR is 15% per year.

(a) Using Excel and appropriate function(s) for a PW analysis, complete the PW calculations each year from zero years through 16 years. Show these in a column on your Excel worksheet.

(b) Using Excel and appropriate function(s), determine the breakeven point and label it on the Excel worksheet.

(c) Create an Excel plot of the two PW curves over the 16 year time horizon and include it in your Excel worksheet.