1. You just won the Virginia lottery. To receive your winnings, you must select only one of the following choices: (2 points) next 20 years 2. You receive $12,890,000 at the end of the second year 3. You can receive a one-time payment of $11,470,000 today. Assuming that the current interest rate is 6%. Which option is most valuable? Show the formulas in the orange section referencing the cells in turquoise. Make the calculations in the turquoise cells. 1,000,000 PMT 11,470,000 PMT Rate No of Periods 12,890,000 6% 6% Rate NPER PMT Rate No pf Periods 20 1. You just won the Virginia lottery. To receive your winnings, you must select only one of the following choices: (2 points) next 20 years 2. You receive $12,890,000 at the end of the second year 3. You can receive a one-time payment of $11,470,000 today. Assuming that the current interest rate is 6%. Which option is most valuable? Show the formulas in the orange section referencing the cells in turquoise. Make the calculations in the turquoise cells. 1,000,000 PMT 11,470,000 PMT Rate No of Periods 12,890,000 6% 6% Rate NPER PMT Rate No pf Periods 20