Create an excel plot of the two pw curves

Reference no: EM13186279

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.

Reference no: EM13186279

Questions Cloud

What is the total dollar amount to be repaid on the loan : The annual interest rate for a customers loan of $675 is 19.25%. What is the total dollar amount to be repaid on the loan, including principle and interest, for the year.

Determine the sublimation of mothballs : Consider the sublimation of mothballs at 27 C in a room having dimensions 7.5ft x 11.0ft x 7.1ft. Assume that the mothballs are pure solid naphthalene (density 1.16 g/cm3) and that they are spheres with a diameter

Does vehicle type vary by mall location : A student team examined parked cars in four different suburban shopping malls. One hundred vehicles were examined in each location. Research question: At α = .05, does vehicle type vary by mall location?

Avoid entering a cold war with the soviet union : The United States and the Soviet Union had been on the same side during WWII. Why was the United States unable to avoid entering a Cold War with the Soviet Union?

Create an excel plot of the two pw curves : 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 co..

How many boys are in the class : A high school graduating class is made up of 360 students. There are 118 more girls than boys . How many boys are in the class?

Sells appliances to less educated consumers : U-Can-Own-It Corporation sells appliances to less educated consumers, including Viv, on installment plans. U-Can-Own-It files a suit against Viv when she stops making payments. Viv claims that the deal is unconscionable.

Determine the digits corresponding to each letter : Determine the digits corresponding to each letter. Digits may not be used for more than one letter. What problem solving strategy did you use in solving this problem? DAN+NAN=NORA

Implementing wireless technologies : it is critical that organizations adopting wireless technologies develop the appropriate security policies governing wireless technologies and operations within their organization.

User Account

All Pages