The following screenshot from the Missouri Lottery website estimates a $$26$ million prize for the July $2,2022$ drawing. The $$26$ million is to be paid as an annuity due with $30$ annual payments. What$$s different than in our notes is that Powerball payments increase by $5\%$ each year.

For a $1\%$ interest rate, how would this increasing annuity amount affect the setup in a spreadsheet and in the Present Value of Annuity Due formula?

All these considered, would you take the annuity or the $$15\mathrm{.}1$ million lump sum? Justify your answer in the discussion.