Skip to main content
All Tools

Car Affordability Spreadsheet

A free spreadsheet that shows what a car loan really costs against your take-home pay. Download it, type in your own numbers, and keep it.

Car Affordability Calculator (.xlsx)

Three sheets: Calculator, Term comparison and Underwater. No email, no sign-up.

Download the spreadsheet

What is in the file

  • Calculator

    You type in the price, down payment, trade-in value, taxes and fees, APR, term in months, your monthly take-home pay, and other monthly car costs such as insurance and fuel. It works out the amount financed, the monthly payment, the total of all loan payments, the total interest, the payment as a share of take-home pay, and all car costs as a share of take-home pay. Then it runs a 20/4/10 check and gives a pass or fail verdict.

  • Term comparison

    The same loan at 36, 48, 60, 72 and 84 months. For each term it shows the monthly payment, the total paid, the total interest, and the extra interest compared with 48 months. It reads its numbers from the Calculator sheet.

  • Underwater

    A rough check of whether you would owe more than the car is worth, year by year for six years. You set how much value the car loses in the first year and in each year after (20% and 15% to start). It compares that rough value with the loan balance left and marks each year OK or UNDERWATER. Real values depend on the car, the miles and the market.

Have a dealer quote already?

The spreadsheet tells you what you can carry. A quote can still hide fees and add-ons. OTD Shield reads the quote and flags lines to question. You can try a free scan first.

Check a quote free

Information only. This is not financial advice. The sheet does arithmetic on the numbers you enter.

How It Works

  1. 1

    Download the file

    One click. No email, no sign-up. Open it in Excel, Google Sheets or LibreOffice.

  2. 2

    Enter your numbers

    Change the input cells on the Calculator sheet: price, down payment, trade-in, taxes and fees, APR, term and your take-home pay.

  3. 3

    Read all three sheets

    See the 20/4/10 verdict, what a longer term costs in interest, and a rough year-by-year underwater check.

Free
No sign-up
3
Sheets
0
Macros

Affordability Spreadsheet FAQ

Do I need to sign up or give an email?

No. The button downloads the file directly. There is no form.

What is the 20/4/10 check?

A common rule of thumb. The sheet checks three things: a down payment of at least 20% of the price, a term of 48 months or less, and all car costs (the payment plus the other monthly costs you enter) at 10% of take-home pay or less. It is a rule of thumb, not a law or a lender requirement.

Will it open in Excel, Google Sheets or LibreOffice?

It is a standard .xlsx file with no macros. The formulas use only common functions (PMT, FV, IF, AND, MIN, MAX), which Excel, Google Sheets and LibreOffice all support. We opened it and checked the results in LibreOffice.

Is this financial advice?

No. It is information only. The sheet does arithmetic on the numbers you type in. Your lender's figures and your own contract are what count.