Auto Loan Calculator is a free Microsoft Excel workbook that lets you (1) estimate the amount you'll need to finance when purchasing a car, (2) create a loan payment schedule with optional extra payments, and (3) analyze different loan options.

The Auto Loan Calculator worksheet helps you estimate the amount you will need to finance, based on the sales price, destination charge, state sales tax, registration and other fees, down payment, manufaturer rebate, and value of your trade-in auto.

The Payment Calculator worksheet creates an amortization schedule based on the loan amount, interest rate, term (e.g. 3 years), and frequency of payments (e.g. monthly). Use the spreadsheet to see how extra payments may help you reduce the total interest paid and pay off your loan earlier.

Quickly analyze different loan options using the third worksheet, which contains graphs showing you how different interest rates, down payment, or number of payments affect the total amount of interest and your monthly payment.

Features:
- No installation, no macros, no ads
- Save your results as different workbooks for comparing options
- Get help with terminology using the many cell comments
- Detailed calculator helps you see the "hidden" costs of purchasing a car
- Complete flexibility in making extra payments