NEED PART B ONLY!!! PLEASE SHOW THE EXCEL FORMULAS.

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 capital

At 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 profles 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.