Car Deal Pricing Calculator, by Ketchy Templates

Out-the-door-

Financed-

Payment-

Vehicle

Starting price / MSRP Selling price Dealer discount Rebates / incentives

Trade-in & down

Trade-in value Trade-in payoff Down payment

Tax & fees

Sales tax %set your local rate Tax after trade credit Title fee Registration / plate Doc fee Other fees

Add-ons

Breakdown

Financing

APR % (main) Term (months) APR option 2 % APR option 3 %

Payment grid

Savings

1 Price

2 Trade

Out-the-door

Financed

3 Down

4 Payment

Implied result of each counter

Counter price = selling price after dealer discount, before rebates. Blank counters carry forward.

Copy for spreadsheet

Copies values in the same order as the yellow input cells of the Car Deal Pricing Calculator v1.0 spreadsheet (Salesperson Worksheet). Click the named cell, then paste. Pasting skips the sheet's input checks, so glance at the STATUS line after pasting.

Pro PRO

Free forever: everything on the Deal, Payments and Four Square tabs, the always-visible summary, Copy for spreadsheet, offline use and auto-save.

Pro adds: saved deals (keep up to 25 named deals on this device and reopen them) and export all saved deals as one CSV.

Pro is unlocked with a code included with a Ketchy Templates car-deal spreadsheet purchase. The code is checked on this device; nothing is sent anywhere.

Unlock code

Want the full spreadsheet?

The Excel / Google Sheets version adds a printable Deal Sheet, a Four Square print-out and (Manager Edition) store rules for desk managers.

Ketchy Templates on Etsy →

Add to home screen

Install this calculator for one-tap access. It still runs entirely on your device.

Privacy

No data leaves your device. Entries are saved only in this browser's local storage. No account, no tracking, no ads. Clearing your browser data erases them.

Estimates only. Not a financing offer, credit approval or contract, and not financial, tax or legal advice. Actual price, taxes, fees, APR and payment depend on the lender and the rules where you live. By Ketchy Templates.