Search here for Tutorials

If the Data is different in your question, please send your questions to homeworksolutionsnow@gmail.com. The questions will be answered at the same price.

E9-11 Use incremental analysis for retaining or replacing equipment decision. - EXCEL TEMPLATE

E9-11 Use incremental analysis for retaining or replacing equipment decision.
E9-11 Twyla Enterprises uses a computer to handle its sales invoices. Lately, business has been so good that it takes an extra 3 hours per night, plus every third Saturday, to keep up with the volume of sales invoices. Management is considering updating its computer with a faster model that would eliminate all of the overtime processing.
  Current Machine New Machine
Original purchase cost $15,000 $25,000
Accumulated depreciation $ 6,000 —
Estimated annual operating costs $24,000 $18,000
Useful life  5 years  5 years
If sold now, the current machine would have a salvage value of $5,000. If operated for the remainder of its useful life, the current machine would have zero salvage value. The new machine is expected to have zero salvage value after five years.
 
Instructions
Should the current machine be replaced?
SOLUTION PREVIEW [The Solution is done in EXCEL TEMPLATE]
EXERCISE 9-11
Decision
Net Income
Retain
Replace
Increase
Machine
Machine
(Decrease)
Operating costs
$120,000
90,000
$30,000
5 year period
File name: E9-11-Twyla1.xls File type: application/vnd.ms-excel Price: $5