Excel for these questions show formulas

1.You have just won the lottery. At the end of each of the next 20 years, you will receive a payment of 50,000. If the cost of capital is 10 percent per year, what is the present value of your lottery winnings?

2. A perpetuity is an annuity that is received forever. If I rent out my house and, at the beginning of each year, I receive $14,000, what is the value of this perpetuity? Assume an annual 10 percent cost of capital. (Hint: Use the PV function and let 20 the number of periods be many!)

3.I now have $250,000 in the bank. At the end of each of the next 20 years, I withdraw $15,000. If I earn 8 percent per year on my investments, how much money will I have in 20 years?

4.I deposit $2,000 per month (at the end of each month) over the next 10 years. My investments earn 0.8 percent per month. I would like to have $1 million in 10 years. How much money should I deposit now?

5. A Premier League soccer player is receiving $15 million at the end of each of the next seven years. He can earn 6 percent per year on his investments. What is the present value of his future revenues?