NEED ASSISTANCE WITH F$,$G$,$ AND H$.$

PLEASE SHOW EXCEL WORK AS WELL.

Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as follows:

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?

@ $12\%$ cost of capitalAt a cost of capital of $12\%,$ Project A should be selected. However, if the cost of capital rises to $18\%,$ then the choice is

reversed, and Project B should be accepted.

b$.$ Construct NPV profiles for Projects A and B$.$

Before we can graph the NPV profiles for these projects, we must create a data table of project NPVs relative to differing costs

of capital.

Project A

Project B

c$.$ What is each project's IRR?

We find the internal rate of return with Excel's IRR function:

IRR ${?}_A=$

$\begin{array}{cc}18\mathrm{.}64\%& 23\mathrm{.}92\%\end{array}$