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)

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

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

Formulae

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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?
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...
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. /
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...
On November 16, 2015 your client won $31.25 million in the lottery. The lottery commission gave...
On November 16, 2015 your client won $31.25 million in the lottery. The lottery commission gave them the option of receiving a lump sum or a 25-year annuity paying $1,250,000 each year, with the first payment received on November 16, 2015 and the last payment to be received on November 16, 2039. Your client decided to take the annuity option and has received four payments so far. The annuity payments are made annually by Canada Life Assurance on November 16...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT