Data table

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

$\backslash$table$[[$Initial investment $(C{F}_0),$Project A$,$Project B$,$Project C$],[$Year $(t),$$$30,000,$$$30,000,$$$30,000$

Payback and NPV Neil Corporation has three projects under consideration. The cash flows for each of them are shown in the following table:

a$.$ Calculate each project's payback period. Which project is preferred?

b$.$ Calculate each project's net present value $($NPV$)$ assuming a$($n$)13\%$ cost of capital. Which project is preferred according to this method?

c$.$ Comment on your findings in parts a and $b,$ and recommend the best project.

a$.$ The payback period of project $A$ is $$ years. $($Round to two decimal places.$)$

The payback period of project $B$ is $3\mathrm{.}00$ years. $($Round to two decimal places.$)$

The payback period of project $C$ is $2\mathrm{.}00$ years. $($Round to two decimal places.$)$

According to the payback method, which project should the firm choose? $($Select the best answer below.$)$

A$.$ Project C

B$.$ Project B

C$.$ Project $A$

b$.$ 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$],[$Initial investment $(C{F}_0),$$$30,000,$$$30,000,$$$30,000$