NPV$,$ with rankings

Botany Bay, Inc., a maker of casual clothing, is considering four projects shown in the following table, Because of the company's risk profile, it has a high $14\mathrm{.}4\%$ cost of capital.

a$.$ Calculate the NPV of each project, using a cost of capital of $14\mathrm{.}4\%.$

b$.$ Rank acceptable projects by NPV$.$

c$.$ Calculate the IRR of each project and use it to determine the highest cost of capital at which all of the projects would be acceptable.

a$.$ Calculate the NPV of each project, using a cost of capital of $14\mathrm{.}4\%.$

The NPV of project $A$ is $ $($Round to the nearest cent.$)$

Data table

$($Click on the icon here in order to copy the contents of the data table below into a spreadsheet.$)$

$\backslash$table$[[,$Project A$,$Project B$,$Project C$,$Project D$,,],[$Initial investment $(C{F}_0),$$$50,900,$$$99,800,$$$79,400,$$$180,100,,],[$Year $(t),,$Cash inflows $(C{F}_t),],[1,$$$19,900,$$$36,800,$$$20,000,$$$99,300,,],[2,$$$19,900,$$$50,600,$$$40,100,$$$80,000,,],[3,$$$19,900,$$$50,600,$$$60,400,$$$59,400,,]]$