need to figure out the time value function for gain

You win a lottery and can either receive $50,000 3 years from today (option 1), or $60,000 7 years from today (option 2). If you could earn 4.0% on savings for the next 7 years, what is the correct choice to make? How much do you gain by making the correct choice? PV option 1 PV option 2 Rate: 44.449.82 45,595,07 50,000.00 60,000.00 gain: choice: 4.0% Option 2 Option1 Option 2 Use the Excel functions taught in the text All calculations should result in POSITIVE numbers Do not round any calculations Reference the values in the gray cells in your formulas You win a lottery and can either receive $50,000 3 years from today (option 1), or $60,000 7 years from today (option 2). If you could earn 4.0% on savings for the next 7 years, what is the correct choice to make? How much do you gain by making the correct choice? PV option 1 PV option 2 Rate: 44.449.82 45,595,07 50,000.00 60,000.00 gain: choice: 4.0% Option 2 Option1 Option 2 Use the Excel functions taught in the text All calculations should result in POSITIVE numbers Do not round any calculations Reference the values in the gray cells in your formulas