please show all work for questions through excel spaced out

5- Suppose you borrowed S45,000 to purchase a new car. The leader charges 4.5% annually and the loan is for 5 years. What is the monthly payment? 6- You sign up for a 401k plan at work and contribute $1,000 each month beginning today. What is account's value on 2/18/2071 if you earn 7% per year and make the last contribution on 1/18/2071? 7. You win the lottery and a $1,000,000 prize. The prize pays monthly installments for 10 years and you discount them at 8%. What is the present value of the prize? 8. You just signed a 39 month lease on a 2021 BMW X-7. The car costs $70,000 and has a residual value of $40,000. If the lease carries a 5% interest rate, what are the monthly payments