THIS QUESTION SHOULD BE ANSWERED IN AN EXCEL FILE. WHEN YOU HAVE ANSWERED THE QUESTION, NAME YOUR FILE YOUR LAST NAME_#6
Posted: Thu May 05, 2022 8:21 am
Please do on excel and show formulas, thank you.
THIS QUESTION SHOULD BE ANSWERED IN AN EXCEL FILE. WHEN YOU HAVE ANSWERED THE QUESTION, NAME YOUR FILE YOUR LAST NAME_#6 AND UPLOAD IT TO CANVAS. 6) A merchant recognizes that it cannot keep up with customer orders. The company's technology is too old, too slow. The owner has an opportunity to buy an upgraded system for $300,000. Here are the assumptions about the new machine: • process more customer orders so revenue will increase by $90,000 a year • since the new system is more efficient, costs would reduce by $20,000 a year • new machine will last 5 years ● on the 5th year, the machine can be sold for $10,000 The merchant's borrowing rate is 7% Should the company make this purchase? Use the NPV method to make this determination
THIS QUESTION SHOULD BE ANSWERED IN AN EXCEL FILE. WHEN YOU HAVE ANSWERED THE QUESTION, NAME YOUR FILE YOUR LAST NAME_#6 AND UPLOAD IT TO CANVAS. 6) A merchant recognizes that it cannot keep up with customer orders. The company's technology is too old, too slow. The owner has an opportunity to buy an upgraded system for $300,000. Here are the assumptions about the new machine: • process more customer orders so revenue will increase by $90,000 a year • since the new system is more efficient, costs would reduce by $20,000 a year • new machine will last 5 years ● on the 5th year, the machine can be sold for $10,000 The merchant's borrowing rate is 7% Should the company make this purchase? Use the NPV method to make this determination