Out-the-Door Car Price Worksheet: How to Compare Used-Car Offers
out-the-door pricedealer feesused-car buyingcar buying worksheetmarketplace comparison

Out-the-Door Car Price Worksheet: How to Compare Used-Car Offers

BBuy-SellCars Editorial Team
2026-11-17
6 min read

Compare used-car offers with an out-the-door worksheet covering dealer fees, taxes, add-ons, trade-ins, shipping, and financing.

An advertised vehicle price is only one part of what you may pay. This out-the-door car price worksheet shows how to compare used-car offers line by line, identify required and optional charges, account for trade-ins and financing, and request a complete written quote before visiting or buying.

Overview

The most useful number for comparing dealer car listings is the out-the-door price: the total amount required to complete the purchase, excluding costs you choose later, such as future maintenance or insurance. Depending on the transaction, that total may include the vehicle selling price, dealer fees, taxes, title and registration charges, selected add-ons, delivery or shipping, and the effect of a trade-in or deposit.

Two vehicles with similar advertised prices can produce different totals if one quote includes accessories, a larger documentation charge, delivery, or a different tax treatment. Comparing only the monthly payment can also hide differences in the loan term, interest rate, amount financed, and optional products. A written, itemized worksheet makes those differences visible.

Before comparing offers, decide whether you are comparing the same type of transaction. A local purchase, an online purchase with delivery, and a trade-in deal may have different charges. Keep the vehicle price, transaction costs, financing, and trade-in calculations in separate lines rather than combining them into one negotiated number.

How to estimate

Use this basic formula for a cash or financed purchase:

Estimated out-the-door total = selling price + dealer fees + required taxes and government charges + selected add-ons + delivery or shipping − deposit or trade-in credit.

Then calculate financing separately:

Amount financed = out-the-door total − cash down payment − other credits.

The amount financed is not the same as the total cost of the loan. Interest depends on the annual percentage rate, loan term, and lender calculation. Ask for the amount financed, APR, term, scheduled payment, and total of payments. If you are comparing loans, use the same down payment and the same vehicle total in each calculation.

For each offer, follow these steps:

  1. Record the advertised price. Note whether it depends on a financing requirement, trade-in, rebate, membership, or other condition.
  2. Request the selling price in writing. Ask whether it includes dealer-installed equipment or mandatory packages.
  3. List every dealer charge. Record documentation, preparation, administrative, electronic filing, destination, or other descriptions exactly as shown.
  4. Separate government charges. Taxes, title, registration, plate, and similar charges may depend on location and vehicle details. Confirm the applicable amount with the dealer and, when necessary, the relevant motor vehicle authority.
  5. Remove or identify optional products. Mark service contracts, protection products, theft devices, accessories, maintenance packages, and other add-ons as optional unless you have independently confirmed otherwise.
  6. Apply credits last. Show a deposit, down payment, rebate, or trade-in allowance on its own line. Do not confuse a trade-in allowance with the payoff on an existing loan.
  7. Check the final purchase order. Compare it with the quote before signing. Ask about any new, renamed, duplicated, or increased charge.

Inputs and assumptions

Build a worksheet with one column for each vehicle or dealer offer. Use the following fields:

Line itemOffer AOffer B
Vehicle selling price$_____$_____
Dealer documentation or administrative fee$_____$_____
Other dealer fees$_____$_____
Taxes$_____$_____
Title, registration, and plate charges$_____$_____
Optional products you accept$_____$_____
Delivery or shipping$_____$_____
Trade-in allowance−$_____−$_____
Deposit or other credit−$_____−$_____
Estimated out-the-door total$_____$_____

For every fee, add a short note: required, optional, negotiable, already included, or needs verification. The same charge can be described differently by different sellers, so the label alone is not enough. Ask what the fee covers and whether a related service appears elsewhere in the quote.

Tax and registration estimates are location-sensitive. The buyer’s address, registration state, vehicle type, purchase method, and transaction structure may affect the calculation. Treat an online estimate as provisional until the written purchase documents show the applicable amount. Rules and dealer practices can change, so avoid relying on an old worksheet for a new purchase.

If you have a trade-in, record four separate numbers: the trade-in allowance, the current loan payoff, any remaining equity or negative equity, and the resulting cash effect. A higher trade-in allowance does not automatically mean a better deal if the vehicle selling price or fees are also higher. For a broader comparison, see our guide to trading in versus selling privately.

Worked examples

Assume two used vehicles meet your needs. Offer A has a lower advertised selling price, while Offer B includes a different set of dealer charges and delivery. Enter the actual amounts from each written quote rather than estimating from a listing page.

ItemOffer AOffer B
Selling price$18,400$18,850
Dealer fees$650$400
Taxes and government charges$1,520$1,555
Accepted optional product$0$600
Delivery or shipping$0$450
Deposit or trade-in credit−$2,000−$2,000
Estimated amount due before financing$18,570$19,855

In this illustration, Offer A has the lower estimated amount due even though the difference in advertised selling price is not the only factor. Offer B may still be appropriate if its equipment, condition, warranty, location, or delivery convenience justifies the additional cost. The worksheet does not choose the vehicle; it shows what you are paying for each choice.

Use this message to request comparable quotes:

Please send an itemized out-the-door quote for the vehicle identified by stock number or VIN. Include the selling price, every dealer fee, taxes, title and registration charges, optional products, delivery or shipping, and any conditions attached to the advertised price. Please show my trade-in or deposit separately and provide the amount due before financing. If financing is included, also provide the APR, term, amount financed, scheduled payment, and total of payments.

Before accepting a quote, confirm the vehicle’s condition and history separately. A price comparison should not replace an inspection or history review. You can use the used-car inspection checklist and vehicle history report guide to evaluate whether the two vehicles are genuinely comparable.

When to recalculate

Recalculate the out-the-door price whenever an input changes. That includes a revised selling price, a different trade-in value, a changed loan payoff, a new delivery charge, an added product, a different registration location, or a financing offer with a new APR or term. Recalculate if the dealer replaces a quote with a purchase order, because that is when omitted or renamed charges may appear.

Refresh your worksheet when you compare a new vehicle, move from local pickup to shipping, or return to a saved listing after a delay. Tax, registration, lender, and dealer inputs are not permanent. For ownership decisions beyond the purchase, compare fuel, insurance, repairs, and depreciation using our used-car ownership cost guide.

Before signing, complete a final five-minute check:

  • Match the VIN or stock number to the vehicle you inspected.
  • Confirm the selling price and every fee against your latest quote.
  • Ask why any new charge appears and whether it is required or optional.
  • Verify the trade-in allowance, loan payoff, deposit, and amount due.
  • Review financing figures separately from the cash out-the-door total.
  • Keep a copy of the signed purchase documents and payment records.

A complete comparison is not about finding the lowest advertised number. It is about identifying the total cost, understanding each assumption, and making sure the final paperwork matches the offer you agreed to.

Related Topics

#out-the-door price#dealer fees#used-car buying#car buying worksheet#marketplace comparison
B

Buy-SellCars Editorial Team

Automotive Marketplace Editors

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.