please calculate the numbers and write down the formula functions that were used (first column a, second b......)

Year 3 Year 4 Year 5 Year 6 1 2 3 Year 1, Amazon invests into a facility in the US that costs $20M. 4 Year 2. The facility generates $100M in sales per year for 5 Years 5 The profitability of the operations are 10% 6 For purposes of this exercise cathprofit Year 1 Year 2 $20.000.000 Investment Sales Earnings from Operations Cash from Operations $100,000,000 100.000.000.0 $100,000,000 100,000,000.0 $100.000.000 100,000,000 0 $100.000.000 100,000,000.0 $100,000,000 100,000,0000 8 What is the Net Present Value of the cash flows assuming the discount rate is 8? 9 What is the Internal Rate of Return of the investment? 10 11 You may use excel formulas for NPV and All Cash Transactions Net Present Value Internal Rate of Return 24