Congratulations! You have just won the State Lottery. The lottery prize was advertised as an annualized...

Congratulations! You have just won the State Lottery. The lottery prize was advertised as an annualized $105 million paid out in 30 equal annual payments beginning immediately. The annual payment is determined by dividing the advertised prize by the number of payments. Instead you could take a one lump cash prize of the present value of all the annuity payments using a 4.5% discount rate. You now have up to 60 days to determine whether to take the cash prize or the annuity. Which option is better and why. Be sure to cite sources and provide any calculations that can help in determining the best outcome.

Expert Solution

Lottery
Advertised amount	105,000,000.00	$
Installements (beginning of year)	30
Annual payment	3,500,000.00	$

Lumpsum Cash amount at 4.5% rate	59,576,609.85	Calculated as below

	a	b	a*b
Year	Cashflow	PV factor 4.5% [1/(1+r)]^n	PV
0	3,500,000.00	1.000	3,500,000.00
1	3,500,000.00	0.957	3,349,282.30
2	3,500,000.00	0.916	3,205,054.83
3	3,500,000.00	0.876	3,067,038.11
4	3,500,000.00	0.839	2,934,964.70
5	3,500,000.00	0.802	2,808,578.66
6	3,500,000.00	0.768	2,687,635.08
7	3,500,000.00	0.735	2,571,899.60
8	3,500,000.00	0.703	2,461,147.94
9	3,500,000.00	0.673	2,355,165.50
10	3,500,000.00	0.644	2,253,746.89
11	3,500,000.00	0.616	2,156,695.59
12	3,500,000.00	0.590	2,063,823.53
13	3,500,000.00	0.564	1,974,950.74
14	3,500,000.00	0.540	1,889,905.02
15	3,500,000.00	0.517	1,808,521.55
16	3,500,000.00	0.494	1,730,642.63
17	3,500,000.00	0.473	1,656,117.35
18	3,500,000.00	0.453	1,584,801.29
19	3,500,000.00	0.433	1,516,556.26
20	3,500,000.00	0.415	1,451,250.01
21	3,500,000.00	0.397	1,388,755.99
22	3,500,000.00	0.380	1,328,953.10
23	3,500,000.00	0.363	1,271,725.45
24	3,500,000.00	0.348	1,216,962.16
25	3,500,000.00	0.333	1,164,557.09
26	3,500,000.00	0.318	1,114,408.70
27	3,500,000.00	0.305	1,066,419.81
28	3,500,000.00	0.292	1,020,497.42
29	3,500,000.00	0.279	976,552.56
	Present value		59,576,609.85

Let us consider bank is providing a minimum of 6% interest
So present value of these annual payments will be	51,067,523.57

Calculation as below

	a	b	a*b
Year	Cashflow	PV factor 6% [1/(1+r)]^n	PV
0	3,500,000.00	1.000	3,500,000.00
1	3,500,000.00	0.943	3,301,886.79
2	3,500,000.00	0.890	3,114,987.54
3	3,500,000.00	0.840	2,938,667.49
4	3,500,000.00	0.792	2,772,327.82
5	3,500,000.00	0.747	2,615,403.61
6	3,500,000.00	0.705	2,467,361.89
7	3,500,000.00	0.665	2,327,699.90
8	3,500,000.00	0.627	2,195,943.30
9	3,500,000.00	0.592	2,071,644.62
10	3,500,000.00	0.558	1,954,381.72
11	3,500,000.00	0.527	1,843,756.34
12	3,500,000.00	0.497	1,739,392.77
13	3,500,000.00	0.469	1,640,936.58
14	3,500,000.00	0.442	1,548,053.38
15	3,500,000.00	0.417	1,460,427.71
16	3,500,000.00	0.394	1,377,761.99
17	3,500,000.00	0.371	1,299,775.47
18	3,500,000.00	0.350	1,226,203.27
19	3,500,000.00	0.331	1,156,795.54
20	3,500,000.00	0.312	1,091,316.54
21	3,500,000.00	0.294	1,029,543.91
22	3,500,000.00	0.278	971,267.84
23	3,500,000.00	0.262	916,290.41
24	3,500,000.00	0.247	864,424.92
25	3,500,000.00	0.233	815,495.21
26	3,500,000.00	0.220	769,335.10
27	3,500,000.00	0.207	725,787.83
28	3,500,000.00	0.196	684,705.50
29	3,500,000.00	0.185	645,948.59
	Present value		51,067,523.57

So if we opt for annual payments at bank interest rate of 6%, present value of our inflow is only 51,067,523.57

That is it is less than than the lumpsum cash amount

So the lumpsum cash price is the best option

jeff jeffy answered 2 hours ago

1. You have just won the prize in the State lottery. A recent innovation is to...

1. You have just won the prize in the State lottery. A recent innovation is to offer prize winners a choice of payoffs. You must choose one of the following prizes: a. $1,000,000 paid immediately b. $600,000 paid exactly one year from today, and another $600,000 paid exactly 3 years from today c. $70,000 payment at the end of each year forever (first payment occurs exactly 1 year from today) d. An immediate payment of $600,000, then beginning exactly 5...

Congratulations! You have won the $ 1 million lottery grand prize. You have been presented with...

Congratulations! You have won the $ 1 million lottery grand prize. You have been presented with several payout alternatives, and you have to decide which one to accept. The alternatives are as follows: $1 million today $1.2 million lump- sum in two years. $1.5 million lump-sum in five years. $2 million lump-sum in eight years. Your cousin, s stockbroker, advises you that over the long-term you should be able to earn ten percent on an investment portfolio. You are intrigued...

Congratulations, you have won the California State Lottery. Lottery officials are giving you a choice of...

Congratulations, you have won the California State Lottery. Lottery officials are giving you a choice of payment options. You will need to choose from one of the following streams. Assume at 5% interest rate for all scenarios. Option 1 Immediate payment of $1,000,000 Option 2 10 annual installments of $120,000 Option 3 $2,650,000 paid at the end of 20 years Option 4 20 annual installments of $80,000 Option 5 5 annual installments of $100,000 plus a lump sum of $750,000...

Assume that you just won the state lottery. Your prize can be taken either in the...

Assume that you just won the state lottery. Your prize can be taken either in the form of $40,000 at the end of each of the next 25 years or as a single payment of $500,000 paid immediately. If you expect to be able to earn 5% annually on your investments over the next 25 years, which alternative should you take?

Manuel just won the lottery and the prize was $ 1 million. You have the option...

Manuel just won the lottery and the prize was $ 1 million. You have the option of receiving a lump sum of $ 312,950 or $ 50,000 per year for the next 20 years. If Miguel can invest the single amount at 9% or invest the annual payments at 7%; Which one should I choose? a. one-time amount of 312,950 b. b. annual payments of 50,000

Congratulations! You have just won $1,000,000 in the New York Lottery. You will receive payments of...

Congratulations! You have just won $1,000,000 in the New York Lottery. You will receive payments of $40,000 per year (at the end of each year) for the next 25 years. If the discount rate is 14 percent, what are your winnings worth today?

3. Congratulations, you just won the lottery! In one option presented to you, you will be...

3. Congratulations, you just won the lottery! In one option presented to you, you will be paid one million dollars a year for the next 25 years. You can deposit this money in an account that will earn 5% each year. (a) Let M(t) be the amount of money in the account (measured in millions of dollars) at time t (measured in years). Set up a differential equation that describes the rate of change in the amount of money in...

1. You have just won a Colorado Lottery prize that will pay annual payments $7,573 forever....

1. You have just won a Colorado Lottery prize that will pay annual payments $7,573 forever. You would rather have a lump sum today rather than the future payments. If you wanted o discount those payments by 11.0%, the value of that prize in todays dollars would be $__.__. 2. Suppose that you were to receive $105 at the end of year one, $230 at the end of year 2, and $352 at the end of year three. If the...

You just won the lottery. Congratulations! The jackpot is $85,000,000 paid in eight equal annual payments....

You just won the lottery. Congratulations! The jackpot is $85,000,000 paid in eight equal annual payments. The first payment on the lottery jackpot will be made today. In present value terms, you really won ______ assuming annual interest rate of 11.00%. Show work or formula in excel.

6. You won the big prize in the California lottery and you have to choose one...

6. You won the big prize in the California lottery and you have to choose one of the following two payment plans: Payment Plan 1: If you choose this payment plan, you will receive semiannual payments for a fixed period of time. The first payment of Rs. 150,000 will be paid on January 01, 2007 and it will grow by 2% every six months. You will receive the last payment on January 01, 2016 Payment Plan 2: If you choose...

Question