Question: I need help solving this problem? Could you please show how you slove it in excel. a Using equivalent annual cost to compare equipment replacement


a Using equivalent annual cost to compare equipment replacement options A business can continue to use a machine that costs $ 7,900.00 per year in operating and maintenance costs today. In 5 years the old machine will be worthless and will be replaced Alternatively, the company can purchase a new more efficient machine today for $ 11,500.00 that today costs $ 4,500.00 per year in operating and maintenance The new machine will last 10 years with a salvage value of zero. The company's cost of capital is 12.3% The rate of inflation is exected to be 20% per year Which option should the firm choose explain your answer Old Machine New Machine Purchase cost NA $ 11,500.00 Annual operating cost today- $ 7,900.00 $ 4,500.00 Time horizon- 5 10 Cost of capital 12.3% Cash flows Year 1 N 4 6 15 16 17 18 19 20 21 22 23 24 25 26 3 4 5 6 7 8 9 CO 10 Equivalent annual costs Type your answer here 27
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
