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. Use the Auto Loan Calculator worksheet to calculate the amount you will need to finance, based on the sales price of the car, destination charges, 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 auto loan amount, annual interest rate, term of the loan, and payment frequency. See how making extra payments can help you pay off your car loan early and reduce the amount of total interest paid. Quickly analyze different loan options using the third worksheet, which takes the inputs from the Payment Calculator and creates graphs showing you how different interest rates, number of payments, or the amount of down payment affect the monthly payment and total amount of interest. 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