Suppose you win a 100 million lottery and you can choose the following two payment options:
1) receive 25 equal payments of $4,000,000- one payment today and one payment at the end of each of next 24 years.
2) one time lump sum payment of $59 million.
Question 1: If you can invest your proceeds and earn 6 percent, which payment option you will choose?
Questions 2: At what rate of return, would you be indifferent between the lump sum and annual payment options?
Answer 1:
Option 1: Equal annual payments of $4,000,000 for 25 years starting today
Rate of return = 6%
Option 2: One time lump sum payment = $59 million = $59,000,000
PV of option 2 = $59,000,000
To get PV of option 1, we will use PV function of excel:
PV (rate, nper, pmt, fv, type)
PV (6%, 25, 4000000, 0, 1)
= $54,201,430.11
Since $59,000,000 > $54,201,430.11, we will choose option 2 (One time lump sum payment of $59 million)
We will choose option 2
Answer 2:
The rate of return will be rate at which PV of option 1 = PV of option 2
PV = $59,000,000
Annual payments each year at the start of year = $4,000,000
Period = 25 years
RATE (nper, pmt, pv, fv, type)
RATE (25, 4000000, -59000000, 0, 1)
= 5.03634%
= 5.04%
The rate of return, at which you would be indifferent between the lump sum and annual payment options = 5.03634%
or 5.04%
Suppose you win a 100 million lottery and you can choose the following two payment options:...
Suppose you have just won a $5 million lottery today. When you win the lottery, you generally receive payments of the lottery jackpot over twenty years. Therefore, your $5 million lottery winnings consist of twenty annual payments of $250,000 each. But wait! Don’t forget about the taxes. The IRS will take 25 percent of each check, so you are left with $187,500 each year. Assume that the annual interest rate is 3%. So, if someone offered you a lump-sum of...
Suppose you have just won a $5 million lottery today. When you win the lottery, you generally receive payments of the lottery jackpot over twenty years. Therefore, your $5 million lottery winnings consist of twenty annual payments of $250,000 each. But wait! Don’t forget about the taxes. The IRS will take 25 percent of each check, so you are left with $187,500 each year. Assume that the annual interest rate is 3%. So, if someone offered you a lump-sum of...
You win a $314.9 million dollar Powerball jackpots. You are scheduled to get 30 equal annual payments that add up to $314.9 million, with the first payment comes today. However, you are given options of getting a lump-sum payment of $150 million today. If the interest rate was 4.31%, which option would you choose?
2. Kelsey just won the lottery, and she must choose among three award options .She can elect to receive a lump sum today of $62 million, to receive end-of-month payments of $0.8 million for 10 years or to receive end-of month payments of $0.47 million for 30 years. If she can earn 8% annually (i.e., the discount rate is 8% per year), which is the best choice based on the PV of the three award options? a) PV of 1st...
Congratulations, you won a lottery of $10 million! You are offered three options to receive your windfall: A) A lump sum of $10 million received immediately B) An annual payment of $500,000 for 30 years C) A monthly payment of $50,000 for 30 years a. If the discount rate is 7%, which option would you choose? Show your work. b. Calculate the effective annual rate for option C.
Suppose you won $2 million in a lottery and it is to be paid in 25 equal annual installments starting today. An alternative to the installment plan is to receive a lump sum payment today. If the applicable discount rate was 7% per year, how large would the lump sum payment have to be? Round to the nearest cent. (Hint: The lump sum needs to equal the present value of the installments)
Sandy wins $2 million in the lottery and she has to choose between the following options: Option 1) $2,000,000 today Option 2) 10 annual payments of $245,000 per year starting today. Option 3) $80,000 per year every year forever starting one year from today. Option 4) 10 payments of $255,000 per year starting 2 years from today. Regardless of the option she chooses, she would invest the funds in an investment earning 4% compounded quarterly. Which option would she choose? Show...
q61. You win the lottery, which pays $1 million in 20 annual $50,000 payments. Your friends ask you how much that would be if you received a single lump-sum payment today. You do not have your calculator but you show them a (correct) equation to help solve it themselves, assuming the interest rate is 10 percent: Which equation did you show them?
Mary Alice just won the lottery and is trying to decide between the options of receiving the annual cash flow payment option of $300,000 per year for 25 years beginning today, or receiving one lump-sum amount today. Mary Alice can earn 5% investing this money. At what lump-sum payment amount would she be indifferent between the two alternatives? (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s)...
Suppose you win a small lottery and have the choice of two ways to be paid: You can accept the money in a lump sum or in a series of payments over time. If you pick the lump sum, you get $3,103 today. If you pick payments over time, you get three payments: $1,100 today, $1,100 1 year from today, and $1,100 2 years from today. At what interest rate would you consider either choice to be equal? (Write your...