1. If you win the lottery $1 million prize, which is the better option taking the money now, or accepting an annual end-of-year payment of $80,000 for 15 years? Use a discount rate of 3% in your calculation of which option is more financially beneficial. Show your work in reaching your conclusion. Please use Excel. Show the formulas, work used.