Explain and show your work please!
3. Your division is considering two investment projects, each ofwhich requires an up-front expenditure of 20 million. You estimatethat the investment will produce the following net cash flows: YearProject A Project B 1 $5,000,000 $20,000,000 2 10,000,00010,000,000 3 20,000,000 6,000,000 a. What are the two project’s netpresent values, assuming the cost of capital is 5%? 10%? 15%? b.What are the two projects’ IRRs at these same costs of capital?Show your work.
yes excel works
