Start with the partial model in the file Ch$12$ P$25$ Build a Model.xlsx$.$ Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as follows:

The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations.

$x$

Download spreadsheet Ch$12$ P$25$ Build a Model$-5$fd$3$b$8.$xlsx

a$.$ If each project's cost of capital is $10\%,$ which project should be selected? Round your answers to the nearest cent.

NPV $($Project A$)$: $

NPV $($Project B$)$: $

$]$ should be selected.

If the cost of capital is $17\%,$ what project is the proper choice? Round your answers to the nearest cent.

NPV $($Project A$)$: $

NPV $($Project B$)$: $

$]$ should be selected.

b$.$ Construct NPV profiles for Projects A and B$.$ Choose the correct graph,

A$.$

B$.$

D$.$

NPV Profiles

c$.$