we have to use information from pb 2 to complete pb 3 plz

Problem #2 Ashley decides to go to the Nissan dealership to purchase a 2018 Altima. The cost of the car is $23,390.32. She puts down a $2,000 down payment, gets an additional $500 credit for being a recent college graduate and finances the remainder of the cost at a 4.75% anmal interest rate for 5 years. She will be making equal monthly payments on the car. Create an amortization table for this situation. The "Car loan problem" sheet in your Excel template should be used for this problem. Fill in the information given and use autofill to complete the amortization table, following the same procedure as in the example. 5. (3 points) Upload a copy of your completed Excel table to the dropbox on D2L. 6. (2 points) In what month will Ashley have paid off half of the principal? 7. (8 points) Suppose that, starting with her 25th payment, Ashley increases her payment amount to $450. To change this in your table, change cell 037 and all cells below it to "450" 3 points) Upload a copy of the updated Excel table to the dropbox on D2L. b. (2 points) in what month will Ashley finish paying off the car? c. (3 points) What should ber final payment be in order to pay off the principal and the interest owed (it should be less than $450) Problem #3 Ashley, being a recent college graduate, has also begun paying off her student loans. She has the following loans when she begins repayment: Set 1: $18,600, interest rate 4.45%, paid off over 10 years, monthly payments Set 2: 89,230, interest rate 6.23%, paid off over 10 years, monthly payments Use the "Student loans problem" worksheet for this question. Assume that she only makes the minimum payments to both loans (the monthly payment amounts are calculated using the same formula as in the last two problems). Complete both tables using the same procedure as in the previous problems. When finding the total interest and total payments, make sure to add amounts for BOTH loans. 8. (3 points) Upload this table to the Dropbox in D2L. 9. (2 points) How much total interest will Ashley pay over 10 years if she only makes minimum payments! 10. Ashley decides to pay $500 total to her student loans ench month. She continues the minimum payment on the lower interest loan, and puts the rest of the $500 towards the higher interest loan until it's paid off. Then she puts all 8500 towards the lower interest tonn until it is paid off (1) (3 points) Upload the updated table to the dropbox in D2L. (b) (2 points) How much total interest will Ashley pay in this scenario? (c) (2 points) How much does she save by increasing her payments in this way