show excel formulas.

Gardial Fisheries is considering two mutually exclusive investments. The projects expected net cash flows are as follows: s was 0 in earlier editions. a. If each project's cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project is the proper choice? (5 points) 30 Choose which project to select with WACC 12%, which with WACC 18% 6 Before we can graph the NPV profiles for these projects, we must create a data table of project NPVs relative to differing 7 costs of capital. \begin{tabular}{l|l|} \hline & Project A \\ \hline 0% \\ 2% \\ 4% \\ 6% \\ 8% \\ 10% \\ 12% \\ 14% \\ 16% \\ 18% \\ 20% \\ 22% \\ 24% & Project B \\ 26% \\ 28% & \\ 30% \\ \hline \end{tabular} c. What is each project's IRR? (3 points) We find the internal rate of return with Excel's IRR function: IRRA=IRRB= Note in the graph above that the X-axis intercepts are equal to the two Crossover rate = e. What is the regular payback period for these two projects? (3 points)