Solve using excel

(a) Construct a choice table for interest rates from 0% to 100%. (b) The firm wants a 12% rate of return on any avoidable increments of investment. Which equipment should be purchased? (Answer: neutralization with 26% incremental RoR)

A paper mill is considering two types of pollution control equipment. Neutralization Precipitation $700,000 $500,000 Initial Cost 40,000 Annual Chemical Cost 110,000 Salvage Value 175,000 125,000 Useful life, in years