Solve all steps

Use MS Excel to: 1) Here are cash flows for three different Investment Opportunities, Year Investment Investment Investment 1 2 3 1 100,000,000 80,000,000 50,000,000 2 100,000,000 80,000,000 75,000,000 3 100,000,000 150,000,000 70,000,000 4 100,000,000 90,000,000 130,000,000 5 100,000,000 100,000,000 130,000,000 Discount Rate 10% 12% 11% In all these cases original investment is equal to your ID/10. Please analyze them and Rank them from Best to Worst where possible with Pay Back, PV,NPV and IRR File in MS Word, please show all steps for Pay Back, PV and NPV, if really needed you can use MS Excel also