In: Operations Management
You just won the $100 million Ultimate Lotto jackpot. Your winnings
will be paid as $4,000,000 per year for the next 25 years. If the
appropriate interest rate is 7.3 percent, what is the value of your
windfall?
SOLUTION:
Below table shows the total amount of windfall i.e Jackpot amunt + Interest earned
| Year |
Winning Payout (a) |
Cumulative Balance (b) |
Interest Rate (c) |
Interest Amount (b*c) |
| 1 | 4000000 | 4000000 | 7.30% | 292000 |
| 2 | 4000000 | 8000000 | 7.30% | 584000 |
| 3 | 4000000 | 12000000 | 7.30% | 876000 |
| 4 | 4000000 | 16000000 | 7.30% | 1168000 |
| 5 | 4000000 | 20000000 | 7.30% | 1460000 |
| 6 | 4000000 | 24000000 | 7.30% | 1752000 |
| 7 | 4000000 | 28000000 | 7.30% | 2044000 |
| 8 | 4000000 | 32000000 | 7.30% | 2336000 |
| 9 | 4000000 | 36000000 | 7.30% | 2628000 |
| 10 | 4000000 | 40000000 | 7.30% | 2920000 |
| 11 | 4000000 | 44000000 | 7.30% | 3212000 |
| 12 | 4000000 | 48000000 | 7.30% | 3504000 |
| 13 | 4000000 | 52000000 | 7.30% | 3796000 |
| 14 | 4000000 | 56000000 | 7.30% | 4088000 |
| 15 | 4000000 | 60000000 | 7.30% | 4380000 |
| 16 | 4000000 | 64000000 | 7.30% | 4672000 |
| 17 | 4000000 | 68000000 | 7.30% | 4964000 |
| 18 | 4000000 | 72000000 | 7.30% | 5256000 |
| 19 | 4000000 | 76000000 | 7.30% | 5548000 |
| 20 | 4000000 | 80000000 | 7.30% | 5840000 |
| 21 | 4000000 | 84000000 | 7.30% | 6132000 |
| 22 | 4000000 | 88000000 | 7.30% | 6424000 |
| 23 | 4000000 | 92000000 | 7.30% | 6716000 |
| 24 | 4000000 | 96000000 | 7.30% | 7008000 |
| 25 | 4000000 | 100000000 | 7.30% | 7300000 |
| Total | 100000000 | 94900000 |
Total Windfall amount = Jackpot Amount + Total Interest earned = 100,000,000 + 94,900,000 = 194,900,000