For this assignment use Excel to solve the following Time Value of Money (TVM) problems. Submit one Excel with two tabs, one for each problem. You should show your work to gain credit. 1- You wish to save $1,000,000 for your retirement. If you could open an investment account which has an annual return for 8% with $20,000.00 initial investment, how much do you need to add to your investment account every year to achieve your goal. You're currently 25 years. 2- You wish to purchase a new car for $65,000. The dealer offers you a loan with an interest rate of 5% APR. If you wish to finance the car for five years with $2,000 down payment. How much is your monthly payment?

I just need help solving this it does not need to put into excel I can put it myself to excel.