Amazon is considering entering the online pharamceutical business. The company estimates entering the pharaceutical business will require

an initial investment of $$300,000,000.$ The company believes it will ramp up quickly, and can earn the following cash flows:

Year $1$ $$25,000,000$

Year $2$ $$58,000,000$

Year $3$ $$90,000,000$

Year $4$ $$180,000,000$

Year $5$ $$250,000,000$

Amazon has a $20\%$ tax rate and its cost of capital is $9\%.$

What is the NPV$,$ IRR, MIRR, Payback Period and Discounted Payment Period?

provide excel spreadsheet with formulas and answers