This must be done on excel using formulas. I understand option 1 however for option 2 and 3 I don't know how to get the PV factor percentage in order for me to complete the problem.

E26-23 Using the time value of money Congratulations! You have won a state lottery. The state lottery offers you the follow- ing (after-tax) payout options: Option #1: Option #2: Option #3: $12,000,000 after five years $2,150,000 per year for five years $10,000,000 after three years Assuming you can earn 6% on your funds, which option would you prefer