Question: Please show work with Excel if possible! You just won the Power Ball Lottery worth $550,000,000. Upon reading the fine print, you learn that you

Please show work with Excel if possible!

You just won the Power Ball Lottery worth $550,000,000. Upon reading the fine print, you learn that you have two options: Option A: take the cash value of $266 million today (before taxes) Option B: The winner is guaranteed to receive 30 graduated payments over 29 years; the first payment is made today. These payments will increase by 5% per year until the final payment. The first payment, received today, equals $18,333,333.33 Assuming a required rate of return of 10%, calculate the present value of option B. (Round to 2 decimals)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

You just won the Power Ball Lottery worth $70,000,000. Upon reading the fine print you learn, that you have two options: Option A: take the cash value of $47.6 million today (before taxes) Option B:...

You just won the Power Ball Lottery worth $350,000,000. Upon reading the fine print you learn, that you have two options: Option A: take the cash value of $35 million today (before taxes) Option B:...

You just won the Power Ball Lottery worth $572,000,000. Upon reading the fine print, you learn that you have two options: Option A: take the cash value of $308 million today (before taxes) Option B:...

You just won the Power Ball Lottery worth $340,000,000. Upon reading the fine print you learn, that you have two options: Option A: take the cash value of $175.5 million today (before taxes) Option...

you just won the power ball lottery worth 340,000,000. upon Reading the fine print you learn. that you have two options: Option A: take the cash value of 175.5 million today before taxes; :Option B:...

You just won the Power Ball Lottery worth $150,000,000. Upon reading the fine print you learn, that you have two options: Option A: take the cash value of $35 million today (before taxes) Option B:...

You just won the Power Ball Lottery worth $350,000,000. Upon reading the fine print you learn that you have two options: Option A take the cash value of 535 million today before taxes) Option B. The...

16. You have 35 years left until retirement, and you want to retire with $1,000,000 saved. You plan to deposit 250 dollars into the account each month beginning one month from today. You currently...

The elasticity of the property tax base for the town of Elderberry is estimated to be 22. Assuming that this estimate is correct, what effect would a 10 percent increase in the property tax have on...

Chemistry Look at the given sugar cyclization reaction and use the letter codes to fill in the appropriate compound. The beta-furanose of the original sugar is Compound. The beta-pyranose of the...

Which of the following is not an accurate statement about performance - based fees? Select one A they are also called "investment - based fees." B . They can be calculated as a portion of total...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

In the Meteor case study, identify how Sarahs traditional approach could be enhanced by using technology in the recruitment process.

Compare and contrast the human resources profession with that of law and medicine in respect of characteristics such as professional knowledge, ethical considerations, local expertise required,...

Relate how process reengineering is used to review and redesign HRM practices. page 680