The Internal rate of Return $($IRR$)$ in cell B$9$ will be $q,$ the Required Return in $B7.$

$\backslash$table$[[,$A$,8],[1,$Year,Cash Flows$],[2,0,(60\mathrm{.}000)$