Question

Show steps Congratulations! You have just won $20 million lottery. You will be paid $1 million...

Show steps

Congratulations! You have just won $20 million lottery. You will be paid $1 million a

      year for the next 20 years – and you receive your first check today. Ignoring, for the

      moment, the taxes you’ll have to pay, what are your winnings really worth today?

            Assume an 7% discount rate.  

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Ans:- we will use the PV function of excel to find the Present Value.

For PV, Rate=7%, Nper=20, Pmt=-$1000,000, FV=0, TYPE=1 (since the withdrawal is at the beginning of the period).

Note:- In the excel function, we put TYPE=0, when investment or withdrawal is done at the end of every period (ordinary annuity) and TYPE=1 when it is done at the beginning of every period. (annuity due).

Therefore, the Present Value of the lottery today is $11,335,595.24.

Note:- If this answer helps you pls give thumbs up.

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
You just won a $1 million lottery today, and the rule of the lottery is to...
You just won a $1 million lottery today, and the rule of the lottery is to pay you $40,000 per year for the next 10 years, followed by $60,000 per year for the following 10 years. The first payment starts one year from now. You estimated the appropriate interest rate is 10% pa, what is the winnings worth today?
Congratulations! You have just won the lottery ,which will pay you an annuity of $50,000 per...
Congratulations! You have just won the lottery ,which will pay you an annuity of $50,000 per year for the rest of your life. If you are 21 today and will die with certainty at 90, this means you will receive 70 payments of $50,000. Let’s say someone offers to give you $1,000,000 today in exchange for this annuity. If the interest rate is 5%, should you take this deal? Why or why not?
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...
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....
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?
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...
Congratulations, you just hit the lottery jackpot for one million dollars. You now have an option...
Congratulations, you just hit the lottery jackpot for one million dollars. You now have an option to receive $50,000 each year for 20 consecutive years, or you can receive $700,000 upfront on day one. Ignoring tax implications, what would you select, and why? How does current and future value of money enter into your calculations? How does inflation, and future cost of items factor into your calculations?
You have just won the Georgia Lottery with a jackpot of $53,000,000. Your winnings will be...
You have just won the Georgia Lottery with a jackpot of $53,000,000. Your winnings will be paid to you in 26 equal annual installments with the first payment made immediately. If you feel the appropriate annual discount rate is 14%, what is the present value of the stream of payments you will receive?
You have just won $10 million in the lottery! However, the actual payment will be made...
You have just won $10 million in the lottery! However, the actual payment will be made in 20 equal annual installments, the first one to be recieved immediately. In present value terms, how much have you really won, assuming that you can earn 8 percent per year on your money? (Show Calculations)
You have just won the lottery and will receive $600,000 in one year. You will receive...
You have just won the lottery and will receive $600,000 in one year. You will receive payments for 16 years, and the payments will increase 5 percent per year. If the appropriate discount rate is 12 percent, what is the present value of your winnings?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT