Question

You won the lottery when the advertised prize was $1,000,000. If you choose the "lump sum"...

You won the lottery when the advertised prize was $1,000,000. If you choose the "lump sum" option you will be paid $500,000 immediately. Instead, you choose to recieve ten annual payments in the amount of $100,000. What is the implied rate of return?

(Please provide formula to solve this problem, if an excel method exists that will work too).

The answer to this question is 15.10, but here were the answers given:
A. 13.22
B. 15.10
C. 16.78
D. 12.34
E. None of the above

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Congratulations! You have just won the State Lottery. The lottery prize was advertised as an annuitized...
Congratulations! You have just won the State Lottery. The lottery prize was advertised as an annuitized $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. You now have up to 60 days to determine whether to take the cash prize or the annuity. a. If you were to choose the annuitized prize, how much would you receive each year? b. The cash prize...
You have just won the $1,000,000 in the lottery. You have the option of taking a...
You have just won the $1,000,000 in the lottery. You have the option of taking a lump sum payout or equal annualized payments over 20 years. Ignoring any tax consequences; how much should you expect from the annualized payments. What target interest rate would make the annualized payments more valuable than the lump sum. In your response, you may want to consider such issues as inflation, investing lump sum in stock market (What have been the long-term historic returns?) to...
Congratulations, you just won the lottery!! The award was for $40,000,000. The lottery company has offered...
Congratulations, you just won the lottery!! The award was for $40,000,000. The lottery company has offered to either pay you the entire amount over 40 years at $1,000,000 per year, or they have offered you a chunk of money today (a lump sum) instead of receiving the $1,000,000 per year for 40 years. assuming a rate of 6%, what dollar amount does the lump sum need to be to be worth taking over the 1,000,000 per year for 40 years?
The Lottery Question Congratulations: you have won the lottery and you have several decisions to make...
The Lottery Question Congratulations: you have won the lottery and you have several decisions to make but you need information to make the correct decision.  The advertised value is a total value $500,000,000 payable equally over 20 years.  Lotteries that are paid over a fixed time period are generally contracted as an annuity purchased with an insurance company. Another option for the payout is to take a lump sum payment.  If the lump sum payout is $220,526,250, what is the interest rate being...
Dana just won $1,000,000 in the state lottery. Her prize can be taken either in the...
Dana just won $1,000,000 in the state lottery. Her prize can be taken either in the form of $40,000 at the end of each of the next 26 years (annuities), or as a single amount of $500,000 paid immediately. If the discount rate is 3% annually, which alternative she should take? and why? Select one: a. She should take the $500,000 because it's value today is higher than the value of the $40,000 payments for the next 26 years b....
Dana just won $1,000,000 in the state lottery. Her prize can be taken either in the...
Dana just won $1,000,000 in the state lottery. Her prize can be taken either in the form of $40,000 at the end of each of the next 26 years (annuities), or as a single amount of $500,000 paid immediately. If the discount rate is 3% annually, which alternative she should take? and why? Select one: a. She should take the $500,000 because it's value today is higher than the value of the $40,000 payments for the next 26 years b....
You have just won a jackpot of $15,000,000 in the lottery and must choose between a...
You have just won a jackpot of $15,000,000 in the lottery and must choose between a lump sum payment today of $10,000,000 or equal installments of $750,000 per year with the first installment coming today and the remainder coming at the end of each of the next 19 years. If you can invest the proceeds and earn 5 percent, which option should you choose? At what interest rate would you be indifferent between the cash and annual payment options. You...
Congratulations!!!!!! You just won a lottery. It will pay you $1,000,000 ten years from today. You...
Congratulations!!!!!! You just won a lottery. It will pay you $1,000,000 ten years from today. You were watching TV late last night and heard an ad for one of those companies willing to buy your lottery prize in ten years for an immediate single cash payment: a. What is the least you would sell the claim for if you can earn 6% on an investment of comparable risk? b. If 6 percent is the appropriate interest rate and the settlement...
7.         You have just won the Virginia Lottery and they have offered you two different payout...
7.         You have just won the Virginia Lottery and they have offered you two different payout arrangements. Option A: You can choose to receive $1,000,000 per year for the next ten years paid at the end of each year. Option B: You can receive $750,000 per year for the next ten years paid at the end of each year, along with a $1,500,000 payment today. If the interest rate is 10% which option will you prefer and why? Show Calculations....
Your plans for the future have finally materialized because you have won the lottery. Congratulations! The...
Your plans for the future have finally materialized because you have won the lottery. Congratulations! The lottery marketing material says you have won $20,000,000 but a more careful examination of the terms and conditions means that you have won twenty $1,000,000 beginning-of-the-year cash flows with the first cash flow today. Further, the lottery contract says that instead of waiting for so many years to collect your winnings, you could accept a lump sum check today in the amount of $12,000,000....