In: Finance
You've won the lotto jackpot of $1,000,000. They wnt to pay it to you at $50,000 a year for 20 years. You ask them what kind of discount rate they would use if you wanted a lump sum today instead and tell you 6%. What would your lump sum payment be?
| Year | Cash Flow | PVF at 6% | Present Value |
| 1 | 50,000.00 | 0.9434 | 47,169.81 |
| 2 | 50,000.00 | 0.8900 | 44,499.82 |
| 3 | 50,000.00 | 0.8396 | 41,980.96 |
| 4 | 50,000.00 | 0.7921 | 39,604.68 |
| 5 | 50,000.00 | 0.7473 | 37,362.91 |
| 6 | 50,000.00 | 0.7050 | 35,248.03 |
| 7 | 50,000.00 | 0.6651 | 33,252.86 |
| 8 | 50,000.00 | 0.6274 | 31,370.62 |
| 9 | 50,000.00 | 0.5919 | 29,594.92 |
| 10 | 50,000.00 | 0.5584 | 27,919.74 |
| 11 | 50,000.00 | 0.5268 | 26,339.38 |
| 12 | 50,000.00 | 0.4970 | 24,848.47 |
| 13 | 50,000.00 | 0.4688 | 23,441.95 |
| 14 | 50,000.00 | 0.4423 | 22,115.05 |
| 15 | 50,000.00 | 0.4173 | 20,863.25 |
| 16 | 50,000.00 | 0.3936 | 19,682.31 |
| 17 | 50,000.00 | 0.3714 | 18,568.22 |
| 18 | 50,000.00 | 0.3503 | 17,517.19 |
| 19 | 50,000.00 | 0.3305 | 16,525.65 |
| 20 | 50,000.00 | 0.3118 | 15,590.24 |
| Present Value/Lumpsum amount | 573496.06 | ||