Question

Suppose you have just won a lottery. You will receive a total of 27 annual payment,...

Suppose you have just won a lottery. You will receive a total of 27 annual payment, and each payment is $3,371. You will receive the first payment today. If you can earn 6% annual rate of return each year, how much is this lottery worth to you today? (round to the nearest dollar. )

PLEASE INCLUDE EXCEL FORMULA

Homework Answers

Answer #1

- Annual periodic payment starting from today is $3371 for 27 years

Calculating the Present Value of periodic annual payments using excel "PV" function:-

So, lottery worth to you today is $47,205

If you need any clarification, you can ask in comments.    

If you like my answer, then please up-vote as it will be motivating       

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Suzie just won the lottery! As her prize, she will receive $2500 a month for the...
Suzie just won the lottery! As her prize, she will receive $2500 a month for the next 10 years. The first payment will be paid today. At 6%, compounded monthly, what is her prize worth today?
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)
1.) You just won the $85 million lottery. You will receive $2.6 million a year for...
1.) You just won the $85 million lottery. You will receive $2.6 million a year for the next 30 years plus an additional payment of $7 million at the end of 30 years. The interest rate is 6 percent. How much is your lottery prize worth today? 2.)If you owe $51,000 payable at the end of eight years, what amount should your creditor accept in payment immediately if the interest rate on the loan is 13 percent? 3.) You have...
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...
Suppose you have just won the first prize in a lottery. The lottery offers you two...
Suppose you have just won the first prize in a lottery. The lottery offers you two possibilities for receiving your prize. The first possibility is to receive a payment of $16,000 at the end of the year, and then, for the next 10 years this payment will be repeated, but it will grow at a rate of 4%. The interest rate is 12% during the entire period. The second possibility is to receive $100,000 right now. Which of the two...
1. Suppose you have just won the first prize in a lottery. The lottery offers you...
1. Suppose you have just won the first prize in a lottery. The lottery offers you two possibilities for receiving your prize. The first possibility is to receive a payment of $16,000 at the end of the year, and then, for the next 10 years this payment will be repeated, but it will grow at a rate of 4%. The interest rate is 12% during the entire period. The second possibility is to receive $100,000 right now. Which of the...
You have just won a jackpot of $15,000,000 in the lottery and must choose between a...
You have just won a jackpot of $15,000,000 in the lottery and must choose between a lump sum payment today of $10,000,000 or equal installments of $750,000 per year with the first installment coming today and the remainder coming at the end of each of the next 19 years. If you can invest the proceeds and earn 5 percent, which option should you choose? At what interest rate would you be indifferent between the cash and annual payment options. You...
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?
You just won the Florida lottery. To receive your winnings, you must select one of the...
You just won the Florida lottery. To receive your winnings, you must select one of the two following choices: You can receive $1,000,000 a year at the end of each of the next 30 years; OR You can receive a one time payment of $15,000,000 today. Assume that the current interest rate is 5 %. Which option is most valuable?
Myrna Loy has just won a lottery. The payout is $51,293 a year for 20 years....
Myrna Loy has just won a lottery. The payout is $51,293 a year for 20 years. Myrna will receive the first payment in one year. If the appropriate discount rate is 6% per year with annual compounding, what is the present value of Myrna’s winnings? Do not round at intermediate steps in your calculation. Round your answer to the nearest dollar. Enter your answer without the $ symbol.