Auto Loan Calculator

The free Auto Loan Calculator for Excel, published by Vertex42, helps you plan your next car purchase. Calculate the amount you will need to finance, based on sales price, destination charge, fees, sales tax, down payment, cash rebate, and trade-in value of an older auto. Use the Payment Calculator worksheet to create an amortization table based on the amount you've financed. Analyze different loans to choose a suitable monthly payment and minimize the total interest.