$-$please answer in excel and show work please

You have just won the lottery! You can either receive $$186,555$ per year for $20$ years or $$2,200,000$ as a lump sum payment today. What is the interest rate on the annuity option?

Multiple Choice

$4\mathrm{.}94\%$

$3\mathrm{.}88\%$

$5\mathrm{.}66\%$

$4\mathrm{.}85\%$

$5\mathrm{.}28\%$