Determine the break even point and label it on the Excel worksheet.

A company is considering replacing its asphalt parking lots with concrete at first cost of $12000 Show more A company is considering replacing its asphalt parking lots with concrete at first cost of $1200000 and an annual maintenance cost of $15000. Another option is also available which is resurfacing the parking lots with asphalt with a first cost of $1000000 and an annual maintenance cost of $50000. 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 break even 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. Show less

“Get 15% discount on your first 3 orders with us” Use the following coupon FIRST15

Posted in Uncategorized