Consider the following two mutually exclusive projects:

Year Cash Flow $($A$)$ Cash Flow $($B$)$

$0$$$421,000$$$38,000$

$146,00020,000$

$260,00013,700$

$377,00016,600$

$4536,00013,400$

The required return on these investments is $12$ percent.

a$.$ What is the payback period for each project? $($Do not round intermediate calculations and round your answers to $2$ decimal places, e$.$g$.,32\mathrm{.}16.)$

b$.$ What is the NPV for each project? $($Do not round intermediate calculations and round your answers to $2$ decimal places, e$.$g$.,32\mathrm{.}16.)$

c$.$ What is the IRR for each project? $($Do not round intermediate calculations and enter your answers as a percent rounded to $2$ decimal places, e$.$g$.,32\mathrm{.}16.)$

d$.$ What is the profitability index for each project? $($Do not round intermediate calculations and round your answers to $3$ decimal places, e$.$g$.,32\mathrm{.}161.)$

e$.$ Based on your answers in $($a$)$ through $($d$),$ which project will you finally choose? Using Excel Functions