Please help me with the calculations and parts A through F! included in the second photo is the format.

Calculations: Formulas: You will compare 2 different amortization schedules when buying a car. The purchase price is $17,500 Bank A requires a 20% down payment (2 pts) and has an annual interest rate of 3.6%. Bank B wants only 10% down payment (2 pts) but the annual interest rate is 4.8%. In both banks, the loan will be paid off in 3 years. A. Calculate the Loan amount first, subtracting the down payment for each bank. Don't use your calculator and then input the amounts. Use formulas in the Excel format (4 pts). Next you need to set up the formulas to find the monthly payments for each bank (22 points). For this use the PMT function under FINANCIAL FORMULAS. B. After calculating the monthly payment, set up the formulas for the Monthly interest (10 pts), Balance reduction (10 pts), and Loan balance (10 pts). Finally, calculate the total interest paid on the loan under the interest payment column (5 pts) and the total under the Balance reduction (5 pts), which should match the loan amount borrowed. Use the Autosum formula. C. To fill out the entire table calculate the first row using the initial loan amount for the calculation of the Monthly interest. The second row should use the Loan Balance from row one. Once you have the formulas for the second row, highlight it and drag the arrow down to fill out all the remaining rows (10 pts). Remember that in Excel you need to enter"=before the formulas so it knows to compute the formula in the cell and doesn't think it's just a heading or label. D. You may also adjust the number of decimal places by clicking on the "increase decimals" or "decrease decimals" tab under NUMBER on the HOME page. E. Your formulas should only have cell references. The only numbers you're allowed to type in are the Beginning Balances, the interest rates and the years. F. Lastly, have Excel calculate the total amount paid for the car if you choose Bank A and Bank B. Make sure you add the down payment, interest and loan amount. Years Cost XXXX.XX Down payment Loan amount Int rate xxxxxxx XXCXX.XX x.xx% Xxxxx.xx XXXXX.XX x.xx% Bank A Bank B Monthly Payment $xx.xx Sxx.xx . Loan Bal Monthly Int Balance reduct XX.XX XXXX.XX XOX.XX XXXX.XX xxx.xx xxx.xx Xxx.xx Xox.xx XXX. XX XX.XX xx.xx XX.XX XX.XX XX.XX Loan Bal como XXXXXX XO00.xx XOCXL.XOK XUOULD XXXX.XX XXXX Xxxx.xx Xxxx.xx xxxxxx XXXX.XX XXXXXX xxx.xx XOOX.XX xx.xx XOOOOO XOOOC XOOX.XX XX.XX Xox.xx XXX.XX XOXOXOXOXO XXXX.XX XOX.XX XOOX.XX X000.xx Xoco.xx XXXX XX xx.xx XOXOX.XX XOOX.XX xx.xx XX.XX XXXX.XX XXXX.XX Xxxx.xx Xxx.xx XOOX.Xox xx.xx XX.XX xx.xx XXX.XX Xxx.xx XX.XX XODOCX XOOX.XX XOCO.XX XOOOXX XOOX.XX XOOXX.XOX xx.xx Month Monthly Int Balance reduct 1 XX.XX XXX.XX 2 XX.XX XXX.XX 3 XX.XX XXX.XX 4 XX.XX . 5 XX.XX XXX.XX 6 XX.XX XXX.XX 7 XX.XX xxx.xx 8 XX.XX . 9 XX.XX XXX.XX 10 XX.XX . 11 XX.XX XXX.XX 12 xx.xx XXX.XX 13 XX.XX XXX.XX 14 XX.XX xxx.xx 15 XX.XX XXX.XX 16 XX.XX Xxx.xx 17 XX.XX Xox.xx 18 XX.XX xxx.xx 19 XX.XX XOX.XX 20 XX.XX XXX.XX 21 . XXX.XX 22 XX.XX xxx.xx 23 XX.XX xxx.xx 24 XXXX XXX.XX 25 XX.XX XXX.XX 26 xx.xx XXX.XX 27 XX.XX . 28 XX.XX XXX.XX 29 XX.XX XXX.XX 30 XXXX XOOX.XX 31 xx.xx XOOX.XX 32 XX.XX XXX.XX 33 XX.XX XXX. XX 34 XX.XX XOOXXX 35 XOX.XX XXX.XX 36 XX.XX XXX.XX Total xxxxxx XOXOX.XX XXX.XX XOXCXXX xox.xx XOOOOXX XOOXX.XX Xxx.xx XXXX.XX xx.xx XOXOX.XX XOCOCXOX xx.xx XOOX.XOX XOOOOXX Xocox xox XX.XX XOXOX.XOK XXXX.XX XXXX.XX XXXX XOOXXX XOO000 XXXX.XX XX.XX XCX.XX XOX.XX XOXO xx.xx xx.xx XOCOCOK XXXX.XX XXXX.XX XXXX.XX XXXX.XX XOOXXXX XXX.XX XXX.XX XXX.XX XXX. XX Xooo XX.XX xx.xx xx.xx XX.XX XXXX.XX Xxx.xx Xxxx.xx Xxx.xx OOOX.XX XOOX.XX XX. XX xoxox_xox XOCOCOK XOOOOXX XXXX XXX.XX XOOXX.XX XXX. XX XX.XX XXXX XOOXXXX XOCK. XX XOOOO.OK XOXOX. XX XOOXXXX XXXXXX xxxx.xx XX.XX xx.xx xxx xx XOCOCOK xxxoxox XX.XX XOOOC.XOX XXXXX XXCX.XX XXXX.XX Total Paid XXCXX.XX XXOOOXXX