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 |