20% Discount rate NPV Data table NAME: 2. The following investment that costs 300 and has the following cash flows 400, 300, 200, 100 and -800. Show the formulas in the orange section referencing the cells in green. Calculate the NPV and IRR? (2 points) Make the calculations in the turquoise cells. Year 0 1 0% 4% Use the Excel Data Table to draw a chart of the NPV of these cash flows as a function of the discount rate. Cash flow -300 400 300 200 100 -800 Would you invest in this investment opportunity if the discount rate is 5%, 35%, 100%? 5 Could you please comment? Why? 5% 35% 12% 16% 20% 24% 28% 32% 36% 40% 44% 48% 52% 56% 60% 64% 68% 72% 76% 80% 84% 88% 92% 100%