Alex Kelton recently won the jackpot in the Colorado lottery while he was visiting his parents. When he arrived at the lottery office to collect his winnings, he was offered the following three payout options: Receive $100,000,000 in cash today. Receive $25,000,000 today and $9,000,000 per year for eight years, with the first payment being received one year from today. Receive $15,000,000 per year for 10 years, with the first payment being received one year from today. Assuming that the effective rate of interest is 7%, which payout option should Alex select?

Alex Kelton recently won the jackpot in the Colorado lottery while he was visiting his parents. When he arrived at the lottery office to collect his winnings, he was offered the following three payout options: Receive $100,000,000 in cash today. Receive $25,000,000 today and $9,000,000 per year for eight years, with the first payment being received one year from today. Receive $15,000,000 per year for 10 years, with the first payment being received one year from today. Assuming that the effective rate of interest is 7%, which payout option should Alex select?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 7E

See similar textbooks

Similar questions

Alex Kelton recently won the jackpot in the Colorado lottery while he was visiting his parents. When he arrived at the lottery office to collect his winnings, he was offered the following three payout options: Receive $100,000,000 in cash today. Receive $25,000,000 today and $9,000,000 per year for eight years, with the first payment being received one year from today. Receive $15,000,000 per year for 10 years, with the first payment being received one year from today. Assuming that the effective rate of interest is 7%, which payout option should Alex select? Use the present value tables in Appendix A. Explain your answer and provide any necessary supporting calculations.
Alex Kelton recently won the jackpot in the Colorado lottery while he was visiting his parents. When he arrived at the lottery office to collect his winnings, he was offered the following three payout options:a. Receive $100,000,000 in cash today.b. Receive $25,000,000 today and $9,000,000 per year for eight years, with the first payment being received one year from today.c. Receive $15,000,000 per year for 10 years, with the first payment being received one year from today.Assuming that the effective rate of interest is 7%, which payout option should Alex select? Use the present value tables in Appendix A. Explain your answer and provide any necessary supporting calculations.
The Caldwell Herald newspaper reported the following story: Frank Ormsby of Caldwell is the state’snewest millionaire. By choosing the six winning numbers on last week’s state lottery, Mr. Ormsby has wonthe week’s grand prize totaling $1.6 million. The State Lottery Commission has indicated that Mr. Ormsbywill receive his prize in 20 annual installments of $80,000 each.Required:1. If Mr. Ormsby can invest money at a 12% rate of return, what is the present value of his winnings?2. Is it correct to say that Mr. Ormsby is the “state’s newest millionaire”? Explain your answer.
Michael won a lottery that will pay him $ 480000 at the end of each of the next twenty years. Blue Spruce has offered to purchase the payment stream for $ 5505600. What interest rate (to the nearest percent) was used to determine the amount of the payment? 9%. 8%. 7%. 6%
Gary won a lottery that will pay him $700000 at the end of each of the next twenty years. Blue Spruce has offered to purchase the payment stream for $7413000. What interest rate (to the nearest percent) was used to determine the amount of the payment?
Sima has won the Wisconsin lottery with a jackpot of $10,000,000. She will be paid out in 20 equal annual installments with the first payment made immediately. If she had the money now she could invest it in an account that generates 9% compounded annually. What is the present value of the stream of payments? Present value of the lottery winnings (round up to the nearest dollar):
A man who won 730,000 pesos in a lottery decided to place 50% of his winnings in a trust fund for the college education of his son. If the money will earn 14% a year compounded quarterly, how much will the man have at the end of 6 years, when his son will be starting his college education?
You are the lucky winner of the Ohio Lottery ! Congratulations. The Lottery tells you that you have won a $20,000,000 prize that will be paid in annual installments of $1,000,000 for 20 years. If interest rates on alternative investments in the market are 8%, what is the actual value (PV) of your prize? Round to the nearest 1,000, and show your work.
Jason just won the Island Luck grand prize give away of $1,200,000. He is offered $100,000 a year for twelve (12) years or receive a lump sum of $725,000 right away. If he can earn 7%, which alternative is better? Include the working
The top prize for the state lottery is $105,000,000. You have decided it is time for you to take a chance and purchase a ticket. Before you purchase the ticket, you must decide whether to choose the cash option or the annual payment option. If you choose the annual payment option and win, you will receive $105,000,000 in 20 equal payments of $5,250,000—one payment today and one payment at the end of each of the next 19 years. If you choose the cash payment, you will receive a one-time lump sum payment of $63,830,111.58. You can invest the proceeds and earn 7%. At what interest rate would you be indifferent between the cash and annual payment options? (Round factor values to 3 decimal places, e.g. 1.521 and final answer to 0 decimal places, e.g. 15%.)Click here to view the PV Table. Interest rate %
The top prize for the state lottery is $115,700,000. You have decided it is time for you to take a chance and purchase a ticket. Before you purchase the ticket, you must decide whether to choose the cash option or the annual payment option. If you choose the annual payment option and win, you will receive $115,700,000 in 25 equal payments of $4,628,000—one payment today and one payment at the end of each of the next 24 years. If you choose the cash payment, you will receive a one-time lump sum payment of $53,355,093.34. If you can invest the proceeds and earn 9 percent, which option should you choose? (Round factor values to 3 decimal places, e.g. 1.521.) Lump sum paymentAnnual payment
Kerry Bales won the state lottery and was given four choices for receiving her winnings. Receive $1,000,000 right now. Receive $1,080,000 in 1 year. Receive $180,000 at the end of each year for eight years. Receive $90,000 at the end of each year for 30 years. Assuming Kerry can earn interest of 8% compounded annually, (a) calculate each option and (b) determine which option Kerry should choose?Use Excel or a financial calculator for computation. Round your answer to nearest dollar. (a) 1. Answer (a) 2. Answer (a) 3. Answer (a) 4. Answer (b) Answer