Uploaded August 2023 | Updated November 2026, 1 day ago
Just a quick time value of money problem to solve for the discount rate on a major lottery. Uses Excel goal seek and the internal rate of return methods. The same method can be used for Powerball, although this was done on the current Mega Millions jackpot.
=== Timestamps ===
0:00 Introduction
0:15 Annuity Payments
1:19 Excel Cash Flows
2:20 Goal Seek Method
4:25 IRR Method
6:50 They are basically using a Treasury rate
7:15 Conclusion
Just a quick time value of money problem to solve for the discount rate on a major lottery. Uses Excel goal seek and the internal rate of return methods. The same method can be used for Powerball, although this was done on the current Mega Millions jackpot.
=== Timestamps ===
0:00 Introduction
0:15 Annuity Payments
1:19 Excel Cash Flows
2:20 Goal Seek Method
4:25 IRR Method
6:50 They are basically using a Treasury rate
7:15 Conclusion










