?i need a formula on excel to get these answers can someone help me. thanks?i

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? A perpetuity is an annuity that is received forever. If I rent my house and at the beginning of each year I receive $14,000, what is the value of this perpetuity? Assume an annual cost of capital of 10 percent. I now have $250,000 in the bank. At the end of each of the next 20 years, I withdraw $15,000 to five on. If I earn 8 percent per year on my investments, how much money will I have in 20 years