Question

In: Finance

You just won the TVM Lottery. You will receive $80 million today plus another 20 annual...

You just won the TVM Lottery. You will receive $80 million today plus another 20 annual payments that increase by $4,000,000 per year. starting from this year. If the appropriate interest rate is 6.5 percent, what is the value of your winnings today?

Solutions

Expert Solution

HI

Below are the excel formulas and values for finding the value of winning:


hence Value of winning is $1,334,327,942.25

Thanks


Related Solutions

You just won the TVM Lottery. You will receive $1 million today plus another 10 annual...
You just won the TVM Lottery. You will receive $1 million today plus another 10 annual payments that increase by $375,000 per year. Thus, in one year, you receive $1.375 million. In two years, you get $1.75 million, and so on. If the appropriate interest rate is 6.5 percent, what is the value of your winnings today?
You have just won the TVM Lottery. You will receive $1 million today plus another 10...
You have just won the TVM Lottery. You will receive $1 million today plus another 10 annual payments that increase by $670,000 per year. Thus, in one year you receive $1.67 million. In two years, you get $2.34 million, and so on. If the appropriate interest rate is 7.7 percent, what is the value of your winnings today?
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?
you just won a lottery entitling you to receive, starting today, a series of 21 quarterly...
you 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 end, by a second series of annual payments of $30,000 each forever! (This $30,000 payment is to be recieved exactly one year after the last $25,000 payment is received) if the appropriate discount rate is =10% compounded continuously, what is the present value of all these future lottery payments? please show how...
You have just won a lottery entitling you to receive, starting today, a series of 21...
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 have just won the lottery and will receive a lump sum payment of $22.53 million...
You have just won the lottery and will receive a lump sum payment of $22.53 million after taxes. Instead of immediately spending your money, you plan to deposit all of the money into an account that will earn 4.81 percent. If you make equal annual withdrawals for the next 25 years, how much can you withdraw each year starting exactly one year from now? Fancy Cat Products has a project that will cost $250,100 today and will generate monthly cash...
You just won the lottery and will receive $14,000 at the end of each of the...
You just won the lottery and will receive $14,000 at the end of each of the next 10 years. Your friend offers to give you a flat $100,000 for the 10 years' worth of income flows right now. If you expect a return of 7% on any surefire investment, how much do you think these lottery winnings are worth to you today? (FORMAT: XX,XXX.XX    DO NOT INCLUDE A DOLLAR SIGN)
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?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT