A collection company has an antiquated high-capacity printer that needs to be updated. The company is faced with two alternatives: the system either can be overhauled or replaced with a new system. The following data has been gathered concerning these two alternatives (ignore income taxes).

The company uses a 10% discount rate and the total-cost approach to capital budgeting analysis. The working captial required under the new system would be released for use elsewhere at the conclusion of the project. Both alternatives are expected to have a useful life of ten years.

Please use excel format with formulas or explained solutions.

1. Calculate the net present value for each alternative. 2. Calculate the profitability index for each alternative. 3. Would you suggest that the company continue with one of the alternatives? If so, which alternative and why?

Overhaul Present Purchase New System System Purchase cost when new $ 300,000 $ 400,000 Accumulated depreciation $ 220,000 Overhaul costs needed now $ 250,000 Annual cash operating costs $ 120,000 $ 90,000 Salvage value now $ 90,000 Salvage value in ten years $ 30.000 $ 80,000 Working capital required $ 50.000