A financial analyst has estimated the net operating cash flows for four projects, as shown in the Excel file. The projects are of about the same risk, requiring a rate of return is $12\mathrm{.}0\%.$ The corporation's planning horizon for investment policy is eight years. For each project, find the NPV$,$ IRR, MIRR, PI$,$ and Payback Period. Period Project $1$ Project $2$ Project $3$ Project $4$

$0-100-100-100-100$

$150050-10046$

$24005046$

$330205046$

$42030046$

$51040046$

$6050046$

$7060046$

$8070046$

Rate of Return $12\%$

Project $1$ Project $2$ Project $3$ Project $4$

NPV

IRR

MIRR

PI

Payback Period