The following table contains information about four potential investment projects that Castle Corporation is considering.

$\backslash$table$[[$Project$,\backslash$table$[[$Required$],[$Investment$]],$Project Life,ARR,$\backslash$table$[[$Payback$],[$Period$]],,$NPV$,$Profitability,Index$],[$A$,$$$560,000,5,13\mathrm{.}50\%,3\mathrm{.}5,$$$,122,250,,1\mathrm{.}88],[$B$,$$$810,000,4,16\mathrm{.}75\%,3\mathrm{.}1,$$$,119,062,,1\mathrm{.}14],[$C$,$$$1,060,000,4,11\mathrm{.}75\%,2\mathrm{.}8,$$$,215,670,$a$,1\mathrm{.}27],[$D$,$$$1,560,000,5,9\mathrm{.}45\%,3\mathrm{.}4,$$$,245,008,,1\mathrm{.}22]]$

Required:

Rank the four projects in order of preference under each method indicated by the headers:

Which method is the best for evaluating the investments?

Complete this question by entering your answers in the tabs below.

Required $1$

Rank the four projects in order of preference under each method indicated by the headers:

$\backslash$table$[[,\backslash$table$[[$Accounting$],[$Rate of Return$]],\backslash$table$[[$Payback$],[$Period$]],\backslash$table$[[$Net Present$],[$Value$]],\backslash$table$[[$Profitability$],[$Index$]]],[1$st preferred,,,,$],[2$nd preferred,,,,$],[3$rd preferred,,,,$],[4$th preferred,,,,$]]$