please include excel functions for steps. Thank you!

7-15. Colorado Springs Technology must choose between two methods of producing a new product. The initial costs and year-end cash benefits are as follows: Year 0 1 2 3 5 Method A -$1,000,000 200,000 250,000 300,000 350,000 400,000 Method B -$2,000,000 1,000,000 600,000 500,000 300,000 200,000 Assume all cash flows occur at year-end and the company's required return is 10 percent, which production method should be used