Assume you win a lottery, and you are offered the following stream of payments by the lottery commission: $25,000 today, $32,000 one year from now, another $32,000 two years from now, and a final payment of $55,000 three years from now. You accept the offer. If you invest all of these proceeds at 6% compounded annually and extract nothing from the investment, how much will you have at the end of the fourth year? Excel Formula Please

Assume you win a lottery, and you are offered the following stream of payments by the lottery commission: $25,000 today, $32,000 one year from now, another $32,000 two years from now, and a final payment of $55,000 three years from now. You accept the offer. If you invest all of these proceeds at 6% compounded annually and extract nothing from the investment, how much will you have at the end of the fourth year? Excel Formula Please

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 22P

See similar textbooks

Similar questions

If you invest $15,000 today, how much will you have in (for further instructions on future value in Excel, see Appendix C): A. 20 years at 22% B. 12 years at 10% C. 5 years at 14% D. 2 years at 7%
How much would you invest today in order to receive $30,000 in each of the following (for further Instructions on present value In Excel, see Appendix C): A. 10 years at 9% B. 8 years at 12% C. 14 years at 15% D. 19 years at 18%
How much would you invest today in order to receive $30,000 in each of the following (for further instructions on present value in Excel, see Appendix C): A. 20 years at 22% B. 12 years at 10% C. 5 years at 14% D. 2 years at 7%
Assume you win a lottery, and you are offered the following stream of payments by the lottery commission: $25,000 today, $32,000 one year from now, another $32,000 two years from now, and a final payment of $55,000 three years from now. You accept the offer. If you invest all of these proceeds at 6% compounded annually and extract nothing from the investment, how much will you have at the end of the fourth year?
You have just won 50 million in the lottery, payable in equal yearly installments over the next 20 years (first payment to be made immediately). Instead of taking the annual payments, you also have the option of receiving a lump sum amount immediately. If the interest rate is 6% per year, what is the minimum lump sum amount you would except in place for the payments? What if the interest rate is 10% per year? Please show the formula and answer.
You just won the TVM Lottery. You will receive $1 million today plus another 10 annual payments that increase by $450,000 per year. Thus, in one year, you can receive $1.45 million. In two years, you get $1.9 million, and so on. If the appropriate interest rate is 6.2 percent, what is the value of your winnings today? (Please also provide financial calculator calculations if possible)
You have Just won the lottery and will receive $490,000 in one year. You will receive payments for 29 years, and the payments will increase 4 percent per year. If the appropriate discount rate is 12 percent, what is the present value of your winnings?
you have just won the lottery and will receive $460,000 in one year. you will receive payments for 21 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? Please explain how to solve using the financial calculator to show and explain steps thanks
The prize in last week’s lottery was estimated to be worth $90 million. If you were lucky enough to win, the payment will be $3.6 million per year over the next 25 years. Assume that the first installment is received immediately. If interest rates are 6%, what is the present value of the prize? If interest rates are 6%, what is the future value after 25 years? How would your answers change if the payments were received at the end of each year? How would your answers change if the interest rate was higher?