Question

Johnson won a lottery with an option of receiving funds by one of the following methods:...

Johnson won a lottery with an option of receiving funds by one of the following methods: Johnson can receive a lump sum of $2,000,000, OR, $ 3,000,000 in five years, OR, $1,000,000, now, with $700K next year and $ 850K  in both year 6 and in year 7.

Which option is best for Johnson with a rate of 7% a year? Solve in Excel, if possible, please make a column for labels. (Such as column a has the labels and column b has the numeric values)

Homework Answers

Answer #1

So the best option is option 3 as it has the highest PV among the alternatives.

Formulae

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
your friend just won the lottery. he has a choice of receiving $214,403 a year for...
your friend just won the lottery. he has a choice of receiving $214,403 a year for the next 23 years or a lump sum today. the lottery uses a 14% discount. What would be the lump sum your friend receives
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?
Shaun’s uncle, Mike, has won a lottery prize. He was given a the choice of receiving...
Shaun’s uncle, Mike, has won a lottery prize. He was given a the choice of receiving a lump sum of R 1 million today, or receiving five equal payments of R 250 000 per annum, with the first payment being received today. His required rate of return is 12% per annum. Mike asked Shaun to evaluate his two options in order to determine which option will be more beneficial to him. /
Alex Meir recently won a lottery and has the option of receiving one of the following...
Alex Meir recently won a lottery and has the option of receiving one of the following three prizes: $64,000 cash immediately, (2) $20,000 cash immediately and a six-period annuity of $8,000 beginning one year from today, or (3) a six-period annuity of $13,000 beginning one year from today. Assuming an interest rate of 6%, which option should Alex choose?
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...
Oxana recently won $100,000 in the lottery. She has the option of receiving the entire $100,000...
Oxana recently won $100,000 in the lottery. She has the option of receiving the entire $100,000 today or she can receive two payments of $51,500 one year apart, with the first one today (so $51,500 today and another $51,500 in one year). For simplicity, assume that lottery winnings are not taxed and that there is no inflation. Suppose the interest rate is 4%. Which option should Oxana choose? Suppose the interest rate is 0%. Which option should Oxana choose? What...
Alex Meir recently won a lottery and has the option of receiving one of the following...
Alex Meir recently won a lottery and has the option of receiving one of the following three prizes: (1) $70,000 cash immediately, (2) $24,000 cash immediately and a six-period annuity of $8,100 beginning one year from today, or (3) a six-period annuity of $14,500 beginning one year from today. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) 1. Assuming an interest rate...
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...
Alex Meir recently won a lottery and has the option of receiving one of the following...
Alex Meir recently won a lottery and has the option of receiving one of the following three prizes: (1) $82,000 cash immediately, (2) $30,000 cash immediately and a six-period annuity of $9,000 beginning one year from today, or (3) a six-period annuity of $17,000 beginning one year from today. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) 1. Assuming an interest rate...
You win the lottery and are given the option of receiving $250,000 now or an annuity...
You win the lottery and are given the option of receiving $250,000 now or an annuity of $25,000 at the end of each year for 30 years. Which of the following is correct? a. If you know the interest rate, you can calculate the present value of each option, and pick the one with the lower present value b. You will always choose the annuity c. You will choose the lump sum payment if the interest rate is 7%, compounded...