The table below shows present worth calculations of the costs associated with using a presently owned machine (defender) and a possible replacement (challenger) for different numbers of years. Determine when the defender should be replaced using an interest rate of 10% per year and a 5-year study period. Show solutions

(a) By hand

(b) Byspreadsheet.

Transcribed Image Text:

PW If Kept/Used Stated Number of Years, $ Number of Years Kept/Used Defender -36,000 -75,000 一125.000 - 166,000 -217,000 Challenger -89,000 -96,000 -102,000 -113,000 -149,000