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. Whats 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.1 million lump sum? Justify your answer in the discussion.