Car Loan Calculator Spreadsheet
Use this car loan calculator spreadsheet in Microsoft Excel or Google Sheets. It lets you enter a vehicle price, down payment, sales tax, financed fees, annual interest rate, and loan term. The file then shows your monthly payment, total scheduled interest, amount financed, and a month-by-month payment table.
You can download the Excel workbook or open the matching Google Sheets template. Both use the same example figures and work in dollars. The yellow cells are the ones to change; the payment results and amortization schedule update from those entries.
Excel workbook:
Google Sheets: Open the Google Sheets template
These are working-file links for review. Before publishing this page publicly, host the Excel file on the website and check that the Google Sheet is shared as view-only. Update the buttons to those public links.
Download the Excel or Google Sheets Car Loan Template
The two versions use the same three tabs and the same calculation method. Pick the file type you use most often, then save your own copy so you can change the figures without changing the original template.
Excel car loan calculator download
Choose the Excel workbook if you want a downloadable .xlsx file that you can open in Microsoft Excel. Save the file to your computer, open it, and go to the Loan Calculator tab. Enter your own numbers in the yellow cells. You can use Save As to keep a separate copy for each set of loan terms.
The Excel template includes the payment summary and all scheduled monthly rows. You do not need to add a formula or build a table before using it. It is ready for editing.
Car loan calculator for Google Sheets
Choose Google Sheets if you prefer working in a browser or keeping a copy in Google Drive. Open the template, select File, then Make a copy, and save that copy to your Drive. Edit the yellow cells in your copy. Google lists File > Make a copy as its standard way to duplicate a spreadsheet.
If the menu looks different, see Google’s instructions for making a copy.
You can also download a Google Sheet in other file formats if you need to use it outside Google Sheets. Our Excel .xlsx file is already provided, so there is no need to export the online version just to get an Excel copy.
Which version should you choose
Neither version changes the loan figures by itself. The better choice is the one you can open and keep updated. Use the same inputs when checking both files.
| Need | Excel workbook | Google Sheets |
|---|---|---|
| How to start | Download the .xlsx file | Open the online template |
| Save your own version | Save As in Excel | File > Make a copy |
| Edit loan inputs | Yellow cells on Loan Calculator tab | Same yellow cells on Loan Calculator tab |
| Read the schedule | Amortization tab | Amortization tab |
What Is Included in the Spreadsheet
I kept the workbook to three tabs, so it is easy to follow. The first tab is where you enter and read the numbers. The second shows how the balance changes each month, while the third explains how to use the file.
| Tab | What you will find |
|---|---|
| Loan Calculator | Six editable inputs, input check, amount financed, monthly payment and totals |
| Amortization | One row per scheduled payment with opening balance, interest, principal and ending balance |
| Instructions | Steps for editing, copying and reading the spreadsheet, plus its limits |
Editable vehicle and loan details
The Loan Calculator tab has six yellow cells in column C. They are vehicle price (C5), down payment (C6), sales tax rate (C7), other fees financed (C8), annual contract interest rate (C9), and loan term in months (C10). Type amounts as numbers and rates as percentages. For example, enter 7% as 7%, not 7.
The input check at C12 tells you when the entries are ready or need attention. The template accepts whole loan terms from 1 to 120 months. When an entry is missing or outside its allowed range, the results are held back until the inputs are fixed.
Payment results and monthly schedule
The payment summary is below the inputs. It shows estimated sales tax (C15), amount financed (C16), monthly payment (C17), total scheduled interest (C18), total loan payments (C19), and total paid with your down payment (C20). These are calculated fields, so leave them as they are.
The Amortization tab shows the interest and principal part of each monthly payment. It also shows what is still owed after that payment. The schedule fills only the months you entered, so a 60-month loan shows 60 active payment rows, not 120 payments.
How to Use the Car Loan Calculator Spreadsheet
You do not need to know spreadsheet formulas to use this template. Work from top to bottom on the first tab, check the result, then open the payment schedule if you want more detail.
Step 1 Open the template and keep a copy
Download the Excel file and save it under a name you will recognize, such as “My Car Loan Estimate.” For Google Sheets, make a copy in your own Drive before editing. A separate copy lets you return to the original example if you make a mistake.
Step 2 Enter the vehicle price and down payment
Start with the agreed selling price of the vehicle, not an estimated monthly payment. Then enter the cash down payment. If the dealer already subtracted money from the quoted price, check the paperwork so you do not subtract it again.
Step 3 Add tax and fees that will be financed
Enter the sales tax percentage in C7. The template estimates tax as the vehicle price multiplied by that rate. Enter only fees you plan to put into the loan in C8. If you will pay a fee separately in cash, do not add it to the financed-fee cell.
Tax treatment can differ by state and local area. Some purchases also have trade-in tax credits or special rules that this simple price-based tax calculation does not include. Use the amount on your actual purchase or loan papers when you have it.
Step 4 Enter the contract interest rate and months
Type the fixed annual contract interest rate in C9 and the payment term in months in C10. A five-year loan has 60 monthly payments. Use the rate that the lender applies to the unpaid balance. An APR that includes certain loan fees may not be the same number.
Once the entries are valid, C12 says “Ready.” The main figures will appear in the payment summary. If it says “Check input values,” review the yellow cells before using the result.
Step 5 Read the payment table and save your work
Look at the monthly payment in C17 first. Then open the Amortization tab to see the payment number, starting balance, monthly payment, interest, principal, and ending balance. Save the file after entering your own numbers so you can open the same estimate later.
I would keep one untouched copy of the template. If I want to check a different set of loan terms, I would make a new copy with a clear file name. That avoids mixing two sets of inputs in one saved file.
Example Car Loan Spreadsheet With Completed Results
Here is the example already filled into the template. These are sample numbers used to show the file working, not a loan offer or a suggested rate. You can replace every yellow value with your own.
| Spreadsheet field | Example value |
|---|---|
| Vehicle price | $30,000 |
| Down payment | $5,000 |
| Sales tax rate | 7% |
| Other fees financed | $750 |
| Annual contract interest rate | 6% |
| Loan term | 60 months |
| Amount financed | $27,850.00 |
| Monthly payment | $538.42 |
| Total scheduled interest | $4,455.11 |
| Total loan payments | $32,305.11 |
| Total paid with down payment | $37,305.11 |
How the amount financed is shown
The file starts with the $30,000 vehicle price. It subtracts the $5,000 down payment, adds $2,100 of estimated sales tax, and adds $750 of financed fees. That leaves $27,850 financed. The amount financed in C16 is the starting balance in the Amortization tab.
$30,000 − $5,000 + $2,100 + $750 = $27,850 financed
How to read the first payment row
For this example, the first monthly payment is about $538.42. The Amortization tab shows about $139.25 of first-month interest and $399.17 toward principal, leaving about $27,450.83 owed. By the final row, the displayed remaining balance is $0.00. The table lets you see that change without filling in each month by hand.
The total scheduled interest of $4,455.11 comes from the interest column. Total loan payments of $32,305.11 come from the payment column. The last figure, $37,305.11, adds the $5,000 down payment to those loan payments; it is not another amount due at the end.
Which Excel and Google Sheets Formulas Does the Template Use
The workbook already contains the formulas needed for its results. I would leave those cells alone unless I were making a separate copy to study or change the spreadsheet itself. The short notes below help you check the cell links; the full car loan payment formula is covered in our How to Calculate Car Loan Payments guide.
Monthly payment formula in C17
Cell C17 uses the amount financed in C16, the annual contract rate in C9, and the number of months in C10. It includes a separate calculation for a 0% loan. The normal monthly-payment formula is built into the file, so you only have to enter the six inputs.
If you want to check the same fixed-payment result with a built-in spreadsheet function, both Microsoft Excel and Google Sheets support PMT. With this template’s cell layout, the check can be written as shown below. It is a check formula, not an extra field you need to add to the file.
=PMT(C9/12, C10, -C16)
Microsoft explains the PMT function for Excel, including the rate, number of payments and principal inputs.
Interest and balance formulas in the schedule
Each active schedule row uses the balance from the previous row, applies the monthly interest rate, and divides that payment between interest and principal. The new ending balance becomes the next row’s opening balance. The final row is highlighted when the loan balance reaches zero.
The summary totals are sums of the schedule’s payment and interest columns. This makes it easier to check that the headline numbers agree with the monthly rows. You can read the figures without changing any of those formulas.
What This Car Loan Spreadsheet Does Not Include
The template is made for one fixed-rate purchase loan with payments every month. It does not try to handle every possible loan agreement or car purchase charge. These limits are important when the amount on the worksheet differs from a lender’s written figure.
Sales tax is a simple estimate
The sales tax cell uses one percentage against the full vehicle price. It does not apply different tax bases, trade-in tax reductions, rebates or local fees automatically. If the tax on your invoice is different, do not assume the spreadsheet knows your state’s rules. Use the paperwork to check what should actually be financed.
The monthly model may differ from your lender
This file assumes a fixed annual contract rate, one payment each month, and no late or extra payments. Some auto loans calculate interest using the number of days between payments. A lender’s final payment can also differ by a few cents because of rounding or payment dates.
If you need a payoff date with extra payments, a refinance comparison, or a lease calculation, use the matching tools on our site. Those are separate questions. This page stays focused on using an Excel or Google Sheets car loan template.
Common Spreadsheet Mistakes to Check
Most problems come from entries in the yellow cells or from changing a formula cell by mistake. Before saving your estimate, run through these checks.
- Enter tax and interest as percentages, such as 7% and 6%, rather than the numbers 7 and 6.
- Use whole months for the term. Enter 60 for five years, not 5.
- Put in only fees you are financing. Leave fees paid separately in cash out of the financed-fee input.
- Check that the down payment has not already been subtracted from the price you entered.
- Keep the calculated cells and amortization formulas unchanged. Use a new copy if you want to edit the model.
- Compare the final estimate with the amount financed and payment schedule in your written loan offer.
The Consumer Financial Protection Bureau explains that the amount financed, finance charge, and total of payments are separate figures shown in loan disclosures. Compare the same figures when you check the worksheet against an offer.
See the CFPB guide to auto loan disclosures for the terms used on the paperwork.
Frequently Asked Questions
These are the questions people usually have after opening the template. The answers refer to the files offered on this page, not to every car loan spreadsheet online.
Is the Excel car loan calculator ready to use
Yes. Download the .xlsx workbook, open Loan Calculator, and replace the yellow sample figures. The payment summary and Amortization tab are already connected by formulas. You do not need to build a spreadsheet first.
Can I use this template in Google Sheets instead of Excel
Yes. The Google Sheets version has the same inputs, results, and schedule. Open its link and use File > Make a copy to save an editable version in your Google Drive. The source copy should remain unchanged.
Does the spreadsheet include car sales tax and fees
Yes. Enter the sales tax percentage and any fees that will be financed. The tax amount is estimated from the vehicle price. Check local rules and your purchase documents because tax and registration amounts are not the same in every state.
Does changing the interest rate update the amortization schedule
Yes. Changing the annual contract interest rate in the yellow C9 cell updates the monthly payment and every active row in the schedule. The payment summary then updates its total interest and total payments. Keep the term and other fields correct for the estimate you want.
Can I calculate a 0% car loan in the spreadsheet
Yes. Enter 0% in the annual interest rate field. The workbook divides the amount financed across the selected number of months. The scheduled interest total will be zero in this model, although separate purchase charges may still apply.
How long can the loan term be
The template supports whole-number terms from 1 to 120 months. It shows only the number of active months you enter. The unused rows stay blank, and the last scheduled payment row ends at a zero balance under the model’s assumptions.
Why is my lender quote different from the spreadsheet
First check the amount financed, contract interest rate, months, and fees. Your lender may include charges that you left out or count interest using actual dates. The spreadsheet is an estimate. The signed loan agreement and payment schedule control what you owe.
Keep Your Spreadsheet Copy for Future Reference
A car loan calculator spreadsheet is useful when you want a saved record of the inputs, monthly payment, and amortization table. Pick the Excel or Google Sheets version above, enter your figures, and save your own copy. You can open it again without re-entering everything.
For an instant payment estimate without a file, use our main Car Loan Calculator. For a longer explanation of the payment math, see How to Calculate Car Loan Payments. This page is the download and instructions page for the spreadsheet itself.