A

B

C

D

E

F

H

What is the profitability index for the following set of cash flows if the relevant

$2$ discount rate is $10$ percent? What if the discount rate is $15$ percent? If it is $22$ percent?

Input area:

$\backslash$table$[[$Year $0,($$$14\mathrm{.}800)],[$Year $1,$$$8,400],[$Year $2,$$$7,600],[$Year $3,$$$4,300],[$Discount rate,$10\%],[$Discount rate,$15\%],[$Discount rate,$22\%]]$

$14$

$15$

$($Use cells A$6$ to B$13$ from the given information to complete this question. You must use the built$-$in Excel function to

$16$ answer this question.$)$

$17$

$18$ Output area:

$19$

$20$

Profitability index at $10\%$

$1\mathrm{.}159$

$21$

Profitability index at $15\%$

$1\mathrm{.}073$

Profitability index at $22\%$

$0\mathrm{.}970$