How to calculate car loan payments – Use microsoft excel to determine the monthly payment. Cash rebate value of your trade in amount owed on your trade in down payment annual interest rate term of loan months use our car