answer yellow parts

820 you are interested purqhasing a Si,OOO new car. You are your options regarding down payment and payment schedule. Your credit score indicates that you can secure a loan with a 6.9% interest rate for a a-year loan. I The facts are summarized below. Car Price Down payment Annual Interest Rate: 'Loan years o Answer the questions below. 24,000 6.90% . If you pay as a down payment (so Only need to borrow 800f the car price), use an EXCEL formulas and functions to corn*te the foumving table 4 assuming you ma\e ANNUAL payments. fayrnent amount : Total repayment Total interest: Format with S, and as a positive number # Of payments X Payment amount Jota! amount borrowed 21 If you pay as a down payment(sp only need to borrow d the car 22 vriqe). use an EXCEL formuAas 9 nd functions to compk!ethe following table 23 ypymake MONTHVY pgyrnents. Payment amount: PTOtaI repayment: , Total interest: 30 3. Use an Excei formula to calculate the difference (subtraction) between. the 31 : total interesvpaid between ghe tv.o Options. j Difference: Ready