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 set up 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?