Question: please do in excel 4 A paper mill is considering two types of pollution A control equipment. Neutralization Precipitation Initial cost Annual chemical cost Salvage


4 A paper mill is considering two types of pollution A control equipment. Neutralization Precipitation Initial cost Annual chemical cost Salvage value Useful life, in years $850,000 55,000 200,000 5 $625,000 125,000 150,000 5 b) Solve for individual ROR's and the Incremental ROR. b) Calculate and plot the net present worth of each alternative over a range of 0 - 100% (use increments of 1% for NPW calculations and increments of 5% on the x-axis of the plot). Be sure to label each axis as well as provide a title for the plot. Please remove the markers and just use lines on the plots. c) Construct a choice table and identify the range of MARR's over which each alternative should be chosen
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
