Please use excel functions for NPV and IRR or the appropiate calculations to show

$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.$ Present calue index

Please show all work And answers