3. Consider the following cash flows for Projects A and B. Both require a 14% annual return. Year 0 1 Project A -950,000 370,000 510,000 420,000 Project B -1,850,000 900,000 800,000 750,000 2 3 | a. Compute the NPV of the projects. b. Calculate the IRR of each project. C. Graph the NPV of both projects over differing required rates. Start with 0% and go up to 30% in increments of 5%. (Easiest to do this in Excel)