Finandal maths

$\backslash$table$[[$Initial investment:,E$,25,000],[$Year $1$ retum:,E$,8,000],[$Year $2$ return:,E$,15,000],[$Year $3$ return:,E$,10,000],[$Year $4$ retum:,E$,5,000]]$

$($i$)$ Enter appropriate formulae in the shaded cells in the table below to calculate the NPV for interest rates of $5\%,10\%15\%,20\%$ and $25\%.$

$($D$)$ Use the NPVs calculated in part $(1)$ to produce a scatterplot from which to estimate the Internal Rate of Return of the project. Enteryour answer in cell E$27$

$($a$)$ Calculate the IRR by entering an appropriate formula in cell E$28.$

$\backslash$table$[[3,5,$Present value$],[$Year$,\backslash$table$[[$Investments$/],[$Retums $($f$)]],5\%$ interest,$10\%$ interest,$15\%$ interest,$20\%$ interest,$25\%$ interest$],[,25000,,,,$il$.,7],[-,8000,,,,,-],[-,15000,$cdots,,,,$],[,\mathrm{.}10000,,,,,-],[,5000,,4,-,,],[$a$,,,,?,3,],[,$NPV:$,,,,,],[,,,,,2,],[,,,,,\%,],[,$Internal rate of return,,Estimate from scatterplot,$],[6.,,,,$Excel function,,$]]$