Profitability Index

$\backslash$table$[[$Year$,$DF @ $10\%,\backslash$table$[[$CF of$],[$Project A$]],\backslash$table$[[$CF of$],[$Project B$]],\backslash$table$[[$PV of CF of$],[$Project A$]],\backslash$table$[[$PV of CF of$],[$Project B$]]],[1,0\mathrm{.}9091,14,000,28,000,,],[2,0\mathrm{.}8265,14,000,12,000,,],[3,0\mathrm{.}7513,14,000,10,000,,],[4,0\mathrm{.}6830,14,000,10,000,,],[5,0\mathrm{.}6209,14,000,10,000,,],[$Total$,53,070,55,924]]$

$\backslash$table$[[$NPV of Project A$,=,$PV of Net Cash Flows $-$ Initial Investment$],[$PI of Project A$,=,],[$NPV of Project B$,=,$PV of Net Cash Flows $-$ Initial Investment$],[$PI of Project B$,=,]]$

As per NPV as well as PI$,$ Project A is recommendable than Project B$,$ although, Project A and B are acceptable according to both Criteria