Calculate Car Loan

how do I calculate how I would save if I paid my car loan balance in full?
Is there a way to do it in Excel?For example, if my balance is 9,000 and my APR is 6.950, if I wanted to pay it off how much interest would I save?
9000 * .06950 will give you 1 year.