You just won the lottery. Congratulations! The jackpot is $85,000,000 paid in eight equal annual payments....

You just won the lottery. Congratulations! The jackpot is $85,000,000 paid in eight equal annual payments. The first payment on the lottery jackpot will be made today. In present value terms, you really won ______ assuming annual interest rate of 11.00%. Show work or formula in excel.

Expert Solution

Amount of jackpot	85,000,000
Annual payment	10,625,000

Year	Payment	Present Value Factor	Present Value
0	10,625,000	1.00000	10,625,000
1	10,625,000	0.90090	9,572,072
2	10,625,000	0.81162	8,623,488
3	10,625,000	0.73119	7,768,908
4	10,625,000	0.65873	6,999,017
5	10,625,000	0.59345	6,305,420
6	10,625,000	0.53464	5,680,559
7	10,625,000	0.48166	5,117,621
		Present Value	60,692,085

Amount really won = $60,692,085

Formulae are:

jeff jeffy answered 6 months ago

Congratulations, you just won the lottery! In one option presented to you, you will be paid...

Congratulations, you just won the lottery! In one option presented to you, you will be paid one million dollars a year for the next 25 years. You can deposit this money in an account that will earn 5% each year. a. Let M(t) be the amount of money in the account (measured in millions of dollars) at time t (measured in years). Set up a differential equation that describes the rate of change in the amount of money in the...

Congratulations! You have just won $1,000,000 in the New York Lottery. You will receive payments of...

Congratulations! You have just won $1,000,000 in the New York Lottery. You will receive payments of $40,000 per year (at the end of each year) for the next 25 years. If the discount rate is 14 percent, what are your winnings worth today?

Congratulations! You have just won the State Lottery. The lottery prize was advertised as an annualized...

Congratulations! You have just won the State Lottery. The lottery prize was advertised as an annualized $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. Instead you could take a one lump cash prize of the present value of all the annuity payments using a 4.5% discount rate. You now have up to 60 days to determine whether to take the cash prize...

3. Congratulations, you just won the lottery! In one option presented to you, you will be...

3. Congratulations, you just won the lottery! In one option presented to you, you will be paid one million dollars a year for the next 25 years. You can deposit this money in an account that will earn 5% each year. (a) Let M(t) be the amount of money in the account (measured in millions of dollars) at time t (measured in years). Set up a differential equation that describes the rate of change in the amount of money in...

The millionaire lottery winner won the $ 175,000,000 jackpot and has the option of receiving payments...

The millionaire lottery winner won the $ 175,000,000 jackpot and has the option of receiving payments of $ 7,000,000 annually for 25 years beginning in year 1 or taking $ 109,355,000 today. At what interest rate? Are the two options equivalent?

1. You have just won a Colorado Lottery prize that will pay annual payments $7,573 forever....

1. You have just won a Colorado Lottery prize that will pay annual payments $7,573 forever. You would rather have a lump sum today rather than the future payments. If you wanted o discount those payments by 11.0%, the value of that prize in todays dollars would be $__.__. 2. Suppose that you were to receive $105 at the end of year one, $230 at the end of year 2, and $352 at the end of year three. If the...

You just won the lottery and you were told that you'd receive 10 annual after-tax payments...

You just won the lottery and you were told that you'd receive 10 annual after-tax payments of $325,385 each. The first payment will be received today (and the last payment will be received at the beginning of the 10th year). The payments will be deposited into a bank account that pays 7.66% interest rate compounded annually. What do you expect to have at the end of year 10 (if you do not withdraw any money from the account throughout 10...

Congratulations, you have won the California State Lottery. Lottery officials are giving you a choice of...

Congratulations, you have won the California State Lottery. Lottery officials are giving you a choice of payment options. You will need to choose from one of the following streams. Assume at 5% interest rate for all scenarios. Option 1 Immediate payment of $1,000,000 Option 2 10 annual installments of $120,000 Option 3 $2,650,000 paid at the end of 20 years Option 4 20 annual installments of $80,000 Option 5 5 annual installments of $100,000 plus a lump sum of $750,000...

Congratulations, you just won the lottery. Now you must decide between two alternatives to receive your...

Congratulations, you just won the lottery. Now you must decide between two alternatives to receive your winnings. The first option is to take the lump sum amount offered today. The second option is to accept a series of equal payments over the next 20 years. Explain how you would set up your calculations that would allow you to select the best alternative .

You just won the $55 million Ultimate Lotto jackpot. Your winnings will be paid as $2,200,000...

You just won the $55 million Ultimate Lotto jackpot. Your winnings will be paid as $2,200,000 per year for the next 25 years. If the appropriate interest rate is 5.5 percent, what is the value of your windfall? $30,494,340.24 $31,133,737.70 $29,510,651.84 $28,933,737.70 $28,035,119.25

Question