Question: ***Can someone please walk through how to get this answer and please show it in excel and the formulas used. Market Top Investors, Inc., is

***Can someone please walk through how to get this answer and please show it in excel and the formulas used.
Market Top Investors, Inc., is considering the purchase of a $340,000 computer with an economic life of five years. The computer will be fully depreciated over five years using the straight-line method, at which time it will be worth $72,000. The computer will replace two office employees whose combined annual salaries are $88,000. The machine will also immediately lower the firm's required net working capital by $77,000. This amount of net working capital will need to be replaced once the machine is sold. The corporate tax rate is 22 percent. The appropriate discount rate is 10 percent. Calculate the NPV of this project. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Answer is complete and correct. NPV $ 40,985.96 Is it worthwhile to buy the computer? Yes
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
