A free car comparison spreadsheet is the quickest way to stop guessing which car is the better deal. Instead of comparing sticker prices or monthly payments, you line up a few cars and compare what each one will really cost you, from the out-the-door price to fuel and insurance. Below you can download our free spreadsheet, Lotwise Lite, and learn exactly how to use it to choose your next car.


Lotwise Lite: Free Car Comparison Spreadsheet
Compare 3 cars on out-the-door price, monthly payment and true cost to own, plus a free car loan calculator. Excel file, also opens in Google Sheets.

Want everything unlocked?
Car Buying Spreadsheet & Auto Loan Calculator | Lotwise Excel Car Comparison Template
The free file is a sample. The full version has every page, tab and feature, plus the user guide.
See the full versionThe download is free. You just enter your email address to get the file, and free downloads are limited to 3 per day.
What is in the free car comparison spreadsheet
Lotwise Lite is an Excel workbook with three working tabs:
- Compare 3 Cars: enter price, fees, sales tax, down payment, APR, loan term, fuel economy, insurance and maintenance for up to three cars. It works out the out-the-door price, amount financed, monthly payment, total loan interest, yearly fuel cost, estimated resale value, total cost to own and a true monthly cost. The cheapest car lights up in orange.
- Loan Calculator: enter a price, fees, tax rate, trade-in, down payment, APR and term to see your monthly payment, total interest and total of all payments.
- Settings: set your currency symbol, ownership period, yearly mileage, fuel price and a default depreciation rate.
Orange cells are for typing and the calculated cells are locked, so you cannot break a formula by accident. It opens in Microsoft Excel and in Google Sheets.
Why compare cars on total cost, not price
Two cars with the same sticker price can cost thousands of dollars apart over five years. The price you pay at the dealership is only the start. After that come interest on the loan, sales tax and fees, fuel or charging, insurance, maintenance and repairs, and depreciation, which is the value the car loses while you own it. Depreciation is usually the biggest cost of all, and it never shows up on a bill.
That is why a cheaper car is not always the cheaper choice. A low-priced model with poor fuel economy, a high insurance premium or a high APR can end up costing more than a car with a higher price tag. A spreadsheet that adds all of these together gives you one number to compare: the true monthly cost of owning each car.
How to use the spreadsheet, step by step
- Set your defaults. On the Settings tab, choose your currency, how many years you expect to keep the car, how far you drive each year and what you pay for fuel.
- Get real numbers for each car. Ask each dealer for a written out-the-door quote. It should list the sale price, documentation fee, title and registration, any add-ons and sales tax.
- Get your loan rate first. A preapproval from a bank or credit union gives you an APR to enter and a benchmark to beat.
- Get insurance quotes. Premiums vary a lot between models. A quick online quote for each car makes the comparison far more accurate.
- Enter everything in the orange cells and read the results. Look at the true monthly cost first, then the out-the-door price.
The numbers that matter when you buy a car
Out-the-door price
This is the total you pay to drive the car away: sale price plus dealer add-ons, fees and sales tax, minus rebates. It is the only fair way to compare quotes from different dealers, because some advertise a low price and add the money back in fees. Always negotiate on this number.
APR and loan term
The annual percentage rate decides how much interest you pay. On a loan of around $28,000 over five years, every extra percentage point adds roughly $750 to $800 in interest. Longer terms lower the monthly payment but raise the total interest, and they leave you owing more than the car is worth for longer.
Depreciation and resale value
Most new cars lose a large share of their value in the first few years. The free spreadsheet estimates resale value from a yearly depreciation rate you can change on the Settings tab. If you have a better estimate from a pricing guide, use it.
Running costs
Fuel, insurance and maintenance happen every month for as long as you own the car. Over five years they often add up to more than the interest on your loan. Fuel economy differences between a hybrid and a regular gas model can be worth thousands of dollars.
A quick example
Say you are choosing between three compact SUVs. One is a hybrid with a slightly higher price and a 5.9% loan. One has a promotional 4.9% APR. The third is a gas model with a big discount and a 3.9% loan but much lower fuel economy. In our sample numbers the gas model had the lowest out-the-door price and the lowest true monthly cost, even after its higher fuel bill, because the discount and low APR outweighed the extra fuel. Change the fuel price or the miles you drive and the answer can flip. That is exactly why it pays to run the numbers rather than trust a gut feeling.
Tips for getting the best deal
- Negotiate the price of the car, the value of your trade-in and your financing as three separate deals.
- Do not tell the dealer what monthly payment you want. Talk about the out-the-door price.
- Say no to add-ons you did not ask for, such as paint protection or nitrogen-filled tires.
- For a used car, run a vehicle history report and pay for an independent pre-purchase inspection.
- Read the buyer’s order line by line before you sign, and check the APR and term match what you agreed.
- Follow the 20/4/10 rule of thumb as a starting point: 20% down, a loan of 4 years or less, and car payment plus insurance under 10% of your gross income.
When you need more than three cars
The free version is great for a quick comparison of three loan offers. If you are still shopping, comparing a lease, trading in a car you still owe money on, or want to know what you can afford before you start, the full version of Lotwise does all of that for up to 10 cars. It adds an affordability check against your income, a lease vs buy calculator, a 96-month payoff schedule with extra payments, a weighted test drive scorecard, a negotiation tracker, a dealer contact log, a 31-step buying checklist and a dashboard with four charts.
Frequently asked questions
Is the car comparison spreadsheet really free?
Yes. Lotwise Lite is free to download. You enter your email address to receive it, and you can download up to 3 free files per day.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. It also works in Microsoft Excel.
Can I compare a cash purchase?
Yes. Enter 0% APR and a 1-month term for the car you plan to pay for in cash, and the loan lines will show no interest.
How accurate are the results?
The results are only as good as the numbers you enter. Use written quotes, a real insurance quote and your actual loan offer, and treat the resale value as an estimate.
What does the full version add?
The full version of Lotwise compares up to 10 cars with loans, leases or cash, trade-ins and negative equity, a six-part total cost of ownership breakdown, an affordability check for every car, an auto loan calculator with a 96-month payoff schedule, a lease vs buy calculator, a test drive scorecard, a negotiation tracker, a dealer log, a 31-step checklist, a dashboard with charts and a full user guide.
