How to Compare Auto Loan Offers: APR, Fees, Term, and Total Interest Worksheet
auto loanscar financingAPRloan comparisoncar buying

How to Compare Auto Loan Offers: APR, Fees, Term, and Total Interest Worksheet

ddealership.page Editorial Team
2026-11-08
6 min read

Compare auto loans accurately by reviewing APR, fees, term, amount financed, payment, prepayment rules, and total interest.

Comparing auto loan offers is about more than finding the lowest advertised rate. This guide shows how to evaluate APR, amount financed, fees, term, payment, total interest, prepayment rules, and required products using a repeatable worksheet you can use with a bank, credit union, dealership, or refinance lender.

Overview

A loan offer can look affordable because of a low monthly payment while costing more over time. A longer term may reduce the payment but increase the total interest. Similarly, a slightly lower interest rate may not be the better offer if it comes with a large origination fee or requires products you do not need.

Compare offers using the same vehicle price, down payment, trade-in credit, taxes, fees, and loan term whenever possible. The most useful comparison usually includes:

  • APR: The annualized cost of borrowing, generally reflecting the interest rate and certain finance charges.
  • Interest rate: The rate used to calculate interest on the outstanding loan balance.
  • Amount financed: The amount borrowed after adding eligible costs and subtracting the down payment and credits.
  • Loan term: The number of scheduled payments, such as 48, 60, or 72 months.
  • Monthly payment: The scheduled principal-and-interest payment, excluding costs that are billed separately.
  • Total of payments and total interest: The clearest way to see the long-term cost of each offer.

Do not compare a bank preapproval with a dealer offer until you confirm that both use the same amount financed and term. For the vehicle’s full purchase cost, also compare dealer out-the-door figures using the out-the-door cost worksheet.

How to estimate

Start by building one loan scenario. Write down the negotiated vehicle price, taxes, registration, dealer fees, optional products, down payment, and trade-in credit. Then calculate the amount financed:

Amount financed = vehicle and purchase costs − down payment − trade-in credit + financed fees or products

Use an auto loan calculator or payment estimator to calculate the scheduled payment. For a standard amortizing loan, the payment depends on the amount financed, periodic interest rate, and number of payments. A calculator is usually more practical than doing the formula manually, but the basic inputs should be visible so you can check that each lender is using the same assumptions.

Next, estimate the total scheduled payments:

Total scheduled payments = monthly payment × number of payments

For a simple comparison, estimate interest and financed charges by subtracting the amount financed from the total scheduled payments:

Estimated interest and financed charges = total scheduled payments − amount financed

This estimate does not include insurance, maintenance, fuel, registration renewals, or other ownership costs. Review the car ownership cost comparison separately when setting your full vehicle budget.

Use this loan-offer worksheet

InputOffer AOffer B
Lender
APR
Interest rate
Amount financed
Term in months
Monthly payment
Origination or documentation fee
Required products or membership costs
Prepayment restriction or penalty
Total scheduled payments
Estimated interest and financed charges

Ask each lender for a written explanation of every blank. A dealer may present financing from several lenders, while a bank or credit union may issue a direct preapproval. Either can be useful; the comparable terms matter more than the source.

Inputs and assumptions

APR versus interest rate

The interest rate helps determine the periodic payment. APR is intended to represent the broader cost of credit and may include certain finance charges. Because the treatment of fees can vary, read the loan disclosure rather than assuming the lower nominal rate is automatically cheaper.

Fees and required products

Record origination fees, application fees, documentation charges, membership requirements, and any product that must be purchased to receive the quoted terms. Ask whether each cost is paid upfront or added to the amount financed. A financed fee also accrues interest over the life of the loan.

Term and prepayment rules

Compare offers at the same term first. Then test a shorter term if the payment fits your budget. Confirm whether extra principal payments are allowed without a penalty, whether payments are applied to principal as requested, and whether any special conditions apply to early payoff. Terms and disclosures vary by lender and location, so verify them directly.

Credit, vehicle, and down-payment assumptions

Quoted terms can change after the lender reviews credit, income, loan-to-value, vehicle age, mileage, and other underwriting details. Used vehicles, certified pre-owned vehicles, and new vehicles may qualify for different programs. Keep the vehicle price and trade-in assumptions fixed while comparing lenders. For trade-in planning, see the trade-in value and offer comparison guide.

Worked examples

Assume you are comparing two hypothetical five-year loans for the same $25,000 amount financed. Taxes, insurance, and ownership costs are excluded. The figures below are rounded estimates for comparison, not quotes.

  • Offer A: 8% interest rate, 60 months, no additional financed fee. The payment is approximately $507 per month. Total scheduled payments are approximately $30,420, with about $5,420 above the original amount financed.
  • Offer B: 7.5% interest rate, 60 months, plus a $600 fee financed into the loan. The amount financed becomes $25,600. The payment is approximately $512 per month, and total scheduled payments are approximately $30,720.

Offer B has a lower rate but a slightly higher payment because the financed fee increases the balance. In this illustration, it still produces a lower total cost over the term, but the difference is much smaller than the rate comparison alone suggests. If the fee were paid upfront instead, the payment and total interest would change again. This is why amount financed, not just APR or payment, belongs in the worksheet.

Also test a shorter term. A 48-month loan may have a higher monthly payment but could reduce total interest. Do not choose that option unless the payment remains comfortable after insurance, fuel, maintenance, and an emergency reserve. The total ownership cost guide can help you assess the broader budget.

When to recalculate

Recalculate whenever any major input changes, including the vehicle price, trade-in value, down payment, taxes, dealer fees, optional products, lender rate, credit profile, or loan term. Recheck the worksheet when you receive a formal preapproval, after a dealer proposes financing, and before signing final documents.

It is also useful to revisit the calculation when refinancing. Compare the new loan’s APR, remaining balance, new term, fees, and total payments from the refinance date. A lower payment is not necessarily a lower total cost if the new loan extends repayment substantially.

Before accepting an offer, take these practical steps:

  1. Get the purchase price and out-the-door amount in writing.
  2. Complete one worksheet for every lender or dealer financing option.
  3. Match the amount financed and term before comparing payments.
  4. Ask about every fee, required product, and prepayment rule.
  5. Confirm the final contract matches the offer you evaluated.

Repeat this process whenever lending conditions or your vehicle-shopping assumptions change. A current worksheet makes it easier to compare local dealer financing with a bank or credit union preapproval and keeps the decision focused on the total cost you can actually afford.

Related Topics

#auto loans#car financing#APR#loan comparison#car buying
d

dealership.page Editorial Team

Automotive Finance 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.