You have just won the lottery and have two choices with regard to the payout:
a: $1 million today, or
b: $40,000 per year for 40 years.
Which one would you prefer assuming you can invest at 5% per year?
please show all work and formulas.
do not use excel.