Please show all calculations with formulas on excel for positive review and thumbs up. Thank you!

Problem Four (20 marks) AMS is debating the purchase of a new digital scanner. The scanner they acquired 3 years ago for $1,200,000 is worth $800,000 today and will have a salvage value of $215,000 after 5 more years. The scanner generates revenues of $460,000 per year. The costs of operating the scanner are $190,000 per year. The company currently has $80,000 invested in operating net working capital. The new scanner will cost $1,585,000. The new scanner will generate revenues of $635,000 per year. In addition, the costs of operating the new scanner will be $245,000 per year. The new scanner will allow the company to reduce its investment in operating net working capital to $45,000. At the end of 5 years, the new machine will have a salvage value of $320,000. The company's corporate tax rate is 32%, the CCA rate is 20% and the required rate of return is 10%. Assume the asset class remains open. Using net present value (NPV) calculation, determine if the company should purchase the new scanner. Show all work. Problem Four (20 marks) AMS is debating the purchase of a new digital scanner. The scanner they acquired 3 years ago for $1,200,000 is worth $800,000 today and will have a salvage value of $215,000 after 5 more years. The scanner generates revenues of $460,000 per year. The costs of operating the scanner are $190,000 per year. The company currently has $80,000 invested in operating net working capital. The new scanner will cost $1,585,000. The new scanner will generate revenues of $635,000 per year. In addition, the costs of operating the new scanner will be $245,000 per year. The new scanner will allow the company to reduce its investment in operating net working capital to $45,000. At the end of 5 years, the new machine will have a salvage value of $320,000. The company's corporate tax rate is 32%, the CCA rate is 20% and the required rate of return is 10%. Assume the asset class remains open. Using net present value (NPV) calculation, determine if the company should purchase the new scanner. Show all work