SOLVE $$N EXCEL.Consider there are two projects Project A and Project B$,$ Both projects' economic life and initial investment outlays are same, and yearly expected net cash flows from them are given as follows: If the cost of capital is $20\%,$ answer the following questions:

a$.$ Calculate the payback period, discounted payback period, NPV and Profitability index for Project A$.$ Would you accept or reject Project A$?$ Explain why. Solve in Excel

b$.$ Calculate the payback period, discounted payback period, NPV and Profitability index for Project B$.$ Would you accept or reject Project B$?$ Explain why.Solve in Excel

$\backslash$table$[[,$Project A$,$Decision$+$Explanation,Project B$,\backslash$table$[[$Decision$+],[$Explanation$]]],[$PP$,$If criteria is $2$ years,,$\backslash$table$[[$If cretia is $2],[$years$]],],[$DPP$,$If criteria is $2$ years,,$\backslash$table$[[$If criteria is $2],[$years$]],],[$NPV$,,,,],[$PI$,,,,]]$

c$.$ Based on the results of a and $b$ above, which project would you choose? Project $A$ or Project B$?$ Explain. Solve in Excel

d$.$ Which of the projects would you choose according to internal rate of return$($urr$)$ criteria? Explain why. Solve in Excell