Rita Gonzales won the $41 million lottery. She is to receive $1.5 million a year for the next 19 years plus an additional lump sum payment of $12.5 million after 19 years. The discount rate is 14 percent. What is the current value of her winnings? Use Appendix B and Appendix D for an approximate answer, but calculate your final answer using the formula and financial calculator methods. (Do not round intermediate calculations. Round your final answer to 2 decimal places.)

Rita Gonzales won the $41 million lottery. She is to receive $1.5 million a year for the next 19 years plus an additional lump sum payment of $12.5 million after 19 years. The discount rate is 14 percent. What is the current value of her winnings? Use Appendix B and Appendix D for an approximate answer, but calculate your final answer using the formula and financial calculator methods. (Do not round intermediate calculations. Round your final answer to 2 decimal places.)

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

Jane Bauer has won the lottery and has the following four options for receiving her winnings: Receive $100,000 at the beginning of the current year Receive $108,000 at the end of the year Receive $20,000 at the end of each year for eight years Receive $10,000 at the end of each year for 30 years Jane can invest her winnings at an interest rate of 8% compounded annually at a major bank. Use the appropriate present or future value table: FV of $1, PV of $1, FV of Annuity of $1 and PV of Annuity of $1 Calculate the Present value for each of the above options. Round all answers to the nearest dollar. Present Value Option 1 $fill in the blank 1 Option 2 $fill in the blank 2 Option 3 $fill in the blank 3 Option 4 $fill in the blank 4 Which of the payment options should Jane choose?
A lottery winner will receive $1 million at the end of each of the next twelve years. What is the future value (FV) of her winnings at the time of her final payment, given that the interest rate is 8.1% per year? A. $19.09 million B. $30.54 million C. $26.73 million D. $15.27 million
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?
the lottery commission wants to be able to withdraw $400,000 at the beginning of each year for twenty years to cover annual payments due to Randy who won 8 million. How much does the commission need to invest today in an account paying 3.6% compounded annually to provide these payments?
Marcus has won a $6,000,000 state lottery. He can take his prize as either 15 yearly payments of $400,000 or a lump sum of $2,725,000. Which is the better option? Assume an interest rate of 12%.
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):
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: 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?
You won the state lottery and took the payout as a $1,823,475 lump sum today. Your spouse has decided that you need to invest this money for the next 9 years and can expect it to earn an average annual rate of return of 8.00%. If this comes to pass, how much money will be in the account at the end of the period?
Gabrielle just won $2.7 million in the state lottery. She is given the option of receiving a of $1,200,000 now, or she can elect to receive $90,000 at the end of each of the next 30 years. If Gabrielle can earn 5% annually on her investments, which option should she take? If Gabrielle takes the prize as an annuity, the present value of the 30-year ordinary annuity is? Can you do it in an excel format?
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.
You have won the lottery, and you must choose between three award options. You can select one of the following options: To receive a lump sum today of $75 million, To receive 10 end-of-year payments of $12 million, to receive 30 end-of-year payments of $8 million. If you expect to earn 9% annually: What is the present value of alternative ii? What is the present value of alternative iii? Which one you must choose?