Juan has just won a lottery. He can get $13 million now (after-tax, lumpsum or one-time option), or he can get $1 million annually for 25 years starting today (after-tax, 25 payments of $1 million each). Whichever option he chooses, he can save his money at a local bank, which is offering a 7% per year return on deposits.

Juan is not sure if he should pick a lumpsum option or 25-payments option. He comes to you for help. What is the benefit (or loss) of choosing the lumpsum option in todays dollars?

Q3, Juan $ $ Lottery Prize (millions) Annuity (millions) APR(R) N(begin now) in years 13.00 1.00 7.00% 25.00 7) Benefit of lumpsum option (Excel) 8) Benefit of lumpsum option (VBA) 9) Benefit of lumpsum (Math) Gain/Loss of Gain/Loss of Gain/Loss of