using this formula and creating a amortization sheet for the first photo.

create an amortization sheet for

the second photo, making sure you reach the balance of 0 dollars for your auto loan.

USE EXCEL ONLY

Amount borrowed 14,845.08 APR 0.062 Rate 0.00516667 Months 4 8 Monthly payment $350.00 Payment Nmber Payment APR 0062 Rate 0.005166667 1 2 4 5 10 Applied to Internet Applied to Outstandin Balance Outstanding Balance 14,845.08 $76.70 $273.30 $14,571.78 $75.29 $274.71 $14,297.07 $73.87 $276.13 $14,020.94 $72.44 $277.56 $13,743.38 $7101 $278.99 $13,464.38 $69.57 $280.43 $13 183.95 $68.12 $281.88 $12.902.07 566 66 $283 34 $12.618.73 $65 20 $284.80 $12.333.92 563.73 $286.27 $12,047.65 $6225 $287.75 $11,259.90 $60.76 $289.24 $11,470.66 $59.27 $290.73 $11,179.92 $57.76 $292.24 $10.887.68 $56.25 $293.75 $10,593.94 S54.74 $295.26 $10,298.67 $53.21 $296.79 $10.00188 $51.68 $298.32 59.703.56 S50.14 $299.86 $9.403.69 548 59 $201.41 $9,102.28 $47.03 S202 97 $8,799 31 $45.46 $304.54 $8,494.77 $43.89 $306.11 $8.188.66 542.31 $307.69 SZBRO 97 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 $250.00 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 $350.00 12 13 14 15 16 AUTO LOAN Details 20.000.00 Number of Payments Rate (per period) Payment Per Period Total Interest Total Payment Total For Extra Payments Total Interest Amount Last Payment 8. SON A Loans Auto Loan Amount Annual Interest Rate Term of loan in Years First Payment Due date Frequency of payment 36 0.71% 631.35 2,728.63 22,728.63 22,274 01 2,274.01 June 2nd 2018 3 years October 2nd 2016 Monthly