need a function on excel to get these answers if someone can help me

You have a liability of $1,000,000 (FV = $1M) due in 10 years. Your re-investment rate is 4% per year. What amount of money would you need to set aside at the end of each of the next 10 years to meet this liability. You graduated! You are going to buy a new car. The cost of the car is $50,000. You have been offered two payment plans: A 10 % discount on the cost of the car followed by 60 monthly payments financed at 9 percent per year There is no discount on the cost of the car, but the 60 monthly payments are financed at only 2 percent per year. If you believe your annual cost of capital is 9 percent, which payment plan is a better deaf? Assume all payments occur at the end of the month. (P.S. Just kidding, you didn't graduate, yet.) I currently have $10,000 in the bank. At the beginning of each of the next 20 years, I am going to invest $4,000 and I expect to earn 6 percent per year on my investments. How much money will I have in 20 years