Question

In: Finance

You have just won $1,000,000 in the Tennessee Lottery. You will receive payments of $40,000 per...

You have just won $1,000,000 in the Tennessee 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 8 percent, what are your winnings worth today? How would I input this information using a financial calculator?

Solutions

Expert Solution

Inputs required for a financial calculator

FV = 1000000

PMT = 40000

Nper = 25

Rate (I/Y) = 8%

Using PV function of the excel :

=PV(0.08,25,40000.1,0)

= 426992.12

We can input the same thing on a financial calculator and we will get the same present value.


Related Solutions

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?
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...
You have just won the lottery and will receive $500,000 in one year. You will receive...
You have just won the lottery and will receive $500,000 in one year. You will receive payments for 25 years, and the payments will increase 4 percent per year. If the appropriate discount rate is 11 percent, what is the present value of your winnings? 5,511,586 $29,258,112 $36,804 $29,258,112 $5,741,235
You have just won the lottery and will receive $1,500,000 in one year. You will receive...
You have just won the lottery and will receive $1,500,000 in one year. You will receive payments for 30 years, and the payments will increase by 2.5 percent per year. If the appropriate discount rate is 7 percent, what is the present value of your winnings?
You have just won the lottery and will receive $610,000 in one year. You will receive...
You have just won the lottery and will receive $610,000 in one year. You will receive payments for 19 years, which will increase 5 percent per year. The appropriate discount rate is 12 percent. Required: What is the present value of your winnings?
You just won $1,000,000 in the lottery. This lottery will pay you $1 a year for...
You just won $1,000,000 in the lottery. This lottery will pay you $1 a year for a million years. Using a martket discount rate of 5% compound annually, what is the current value of this prize? $20 $67 $24.67 $16.66 $12
Time Value of Money COLLAPSE You have just won the $1,000,000 in the lottery. You have...
Time Value of Money COLLAPSE 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...
You have just won the Kryshak lottery and you are given the following options to receive...
You have just won the Kryshak lottery and you are given the following options to receive your winnings: 1. A lifetime annuity of $480,000 per year, with the first payment occurring one year from today. Your life expectancy is 40 years. (You will receive 40 payments) 2. A payment of $461,050 per year for 30 years (30 payments) with the first payment made immediately. 3. $7,945,000 five years from now. If your opportunity cost is 9%, which should you pick...
You have just won a lottery entitling you to receive, starting today, a series of 21 quarterly payments of $25,000 each
You have just won a lottery entitling you to receive, starting today, a series of 21 quarterly payments of $25,000 each, followed, one year after this series of payments ends, by a second series of annual payments of $30,000 each forever! (The first $30,000 payment is to be received exactly one year after the last $25,000 payment is received.) If the appropriate discount rate is r = 10 percent compounded continuously, what is the present value of all these future...
You recently won $80 million in lottery. You will receive 20 payments of $4 million per...
You recently won $80 million in lottery. You will receive 20 payments of $4 million per year (starting from today). If the interest rate is 6.5%, what is your lottery payment worth today?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT