Please use excel function Or appropiate calculations

$1.$ Pay back period$/$method $($assume cash inflows occur eventllu throughout the year$)$

$2.$ Unadjusted rate of return $($also called simple rate of return and accounting rate of return$)$

$3.$ NPV $($assume that cash inflows occur at year$-$end$)$

$4.$ Internal rate of return $($IRR$)$

$5.$ Presen Value index

Please show all work