Free Car Comparison Spreadsheet (Excel): Compare Cars on True Cost to Own

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.

Free car comparison spreadsheet in Excel comparing three cars on out-the-door price and true cost to own

Lotwise Lite: Free Car Comparison Spreadsheet

XLSX · 211.7 KB · Free

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.

Enter your email and the file downloads straight away. Up to 3 free downloads a day. Privacy policy

Car Buying Spreadsheet & Auto Loan Calculator | Lotwise Excel Car Comparison Template

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 version

The 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

  1. 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.
  2. 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.
  3. Get your loan rate first. A preapproval from a bank or credit union gives you an APR to enter and a benchmark to beat.
  4. Get insurance quotes. Premiums vary a lot between models. A quick online quote for each car makes the comparison far more accurate.
  5. 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.

Lotwise car buying spreadsheet dashboard comparing cars on total cost of ownership

Full version

Lotwise Car Buying Spreadsheet & Auto Loan Calculator

Compare up to 10 cars on true cost to own, with a dashboard that picks the winner for you.

  • Loans, leases and cash compared on equal terms
  • Budget check for every car against your income
  • Negotiation tracker, dealer log and 31-step checklist

See the full version

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.

Lotwise auto loan calculator and lease vs buy calculator in Excel

Upgrade

Get the complete Lotwise workbook

Everything in the free spreadsheet, plus the tools you need at the dealership.

  • Auto loan payoff schedule with extra payments
  • Lease vs buy calculator
  • Weighted test drive scorecard and 4 charts

See the full version

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.

Scroll to Top