please include excel functions and or steps taken to solve. Thank you!!

6-18. Chico Manufacturing must choose between two methods of producing a new product. The outlays and yeastind benefits are as follows: Year Method A Method B 0 -$1,000,000 -$2,000,000 1 200,000 800,000 2 250,000 600,000 3 300,000 500,000 4 350,000 400,000 5 400,000 400,000 Assuming the required return is 10 percent, compute the net present value and internal rate of return for each production method. Which production method should be used? Why