A machine purchased 3 years ago for $140,000 is now too slow to satisfy the demand of customers. It can be upgraded now for $79,000 or sold to a smaller company internationally for $40,000. The upgraded machine will have an annual operating cost of $85,000 per year and a $30,000 salvage value in 3 years. If upgraded, the presently owned machine will be retained for only 3 more years, then replaced with a machine to be used in the manufacture of several other product lines. The replacement machine, which will serve the company now and for a maximum of 8 years, costs $220,000. Its salvage value will be $50,000 for years 1 through 5; $20,000 after 6 years; and $10,000 thereafter. It will have an estimated operating cost of $45,000 per year.

Your boss asks you to perform an economic analysis at 15% per year using a specified 3-year planning horizon

(a) To determine if the current machine should be replaced now or 3 years from now, and

(b) Once decided, to determine the equivalent AW for the next 3 years. 

(c) Write the spreadsheet functions that determine the AW values.

(d) After you return to your office, your boss texts the following question and wants an answer immediately. What do you tell her and what is the spreadsheet function used to determine the answer? “Hi, what is the equivalent annual worth of the replacement machine if we keep it for its maximum expected life and how much does this reduce the capital recovery each year?”