finance-business · personal-finance · vehicles-big-purchases

Auto Loan Payment Calculator

Works out the monthly payment on a car loan built from the whole deal: the sales tax charged under your state's own rules for a trade-in and a rebate, dealer and government fees, a trade-in with any debt still owed on it, and a manufacturer's rebate set against a promotional rate. Use it to see what the loan really costs, how many months you would owe more than the car is worth, and what the 2025 car-loan interest deduction is worth at your own tax rate and income.

Last updated

Calculator overview

Inputs and outputs

This summary comes from the calculator's published input and output contract.

Inputs

Promo APR
When omitted Blank
About this input

Optional. A manufacturer's promotional rate offered instead of the cash rebate, often 0 percent. Leave it blank for no comparison. When it is entered, the same deal is priced a second time at this rate with no rebate, and the cheaper of the two offers is named. An entered 0 is a real 0 percent offer, not a blank. Few buyers get one: Edmunds reported 1.2 percent of new-car buyers did in the second quarter of 2026.

Unit fraction Default Not set Range 0 to 0.06
Rebate Tax Rule (required)
About this input

Whether your state charges sales tax on the price before a manufacturer's rebate comes off, or after it. Virginia's motor vehicle agency says on its own page that it taxes the price after the rebate; how other states treat a rebate could not be confirmed from their own pages, and no official table covers every state, so the choice is yours to make.

Default Tax the price before the rebate Allowed Tax the price before the rebate, Tax the price after the rebate
Loan Term Months (required)
About this input

How many monthly payments the loan runs for. A longer term lowers the payment and raises the interest every time, and it keeps you owing more than the car is worth for longer. It must be a whole number of months; the table at the foot prices terms either side of yours, a few of them longer than this input allows.

Unit months Default 72 Range 12 to 96
MAGI
When omitted Blank
About this input

Optional. Your modified adjusted gross income for the year. Leave it blank if it is at or below the level where the car-loan interest deduction starts to shrink, and the full deduction is counted. Above that level the final regulations take 200 off the deduction for each 1,000 or part of 1,000 of income, so it is worth far less than its 10,000 headline to many buyers. The slider moves in steps of 1,000, so enter your income rounded up to a whole 1,000 (an income of 113,500 is entered as 114,000): because part of 1,000 counts as a whole 1,000, rounding up always gives the exact reduction, while rounding down can show a deduction the rule does not leave.

Unit $/year Default Not set Range 0 to 300000
Sales Tax Rate (required)
About this input

The combined state and local rate charged on a vehicle sale, entered as a percentage, so 7.5 percent is 7.50%. Several states tax vehicles at a rate or on a base of their own, so use the rate your state charges on a vehicle; the base it is charged on follows the two state rules.

Unit fraction Default 0.075 Range 0 to 0.12
Trade In Value
When omitted Blank
About this input

Optional. What the dealer allows for the car you trade in. Leave it blank if there is none, and it reads as nothing. It comes off the amount financed, and it also comes off the taxed price when your state credits a trade-in.

Unit $ Default Not set Range 0 to 60000
Vehicle Price (required)
About this input

The price agreed with the seller for the car itself, before sales tax, fees, any rebate or any trade-in. Everything else is built from it: the sales tax is charged on it under the two state rules, the loan starts from it, and the car's estimated value starts from it and falls from the first month.

Unit $ Default 46500 Range 3000 to 150000
Trade In Owed
When omitted Blank
About this input

Optional. The payoff still owed on the car you trade in, as its lender quotes it, to the dollar. Leave it blank if nothing is owed, and it reads as nothing. Any amount above the trade-in's value is negative equity: it is added to this loan, it is not taxed, and under the final regulations its interest does not count toward the car-loan interest deduction.

Unit $ Default Not set Range 0 to 60000
Trade In Tax Rule (required)
About this input

Whether your state charges sales tax on the price less the trade-in's value, or on the full price. California and Virginia say on their own agencies' pages that they do not credit a trade-in. Choose the rule that matches your state: it is not looked up, because your state's own revenue agency is the authority on it.

Default Tax the price less the trade-in Allowed Tax the price less the trade-in, Tax the full price
Later Depreciation
When omitted Blank
About this input

Optional. How much of its remaining value the car loses in each later year. Leave it blank to use 14 percent, the rate that, after a first year of 20, loses the 56.2 percent over five years that AAA's 2026 driving-cost study implies. An entered 0 means no loss after the first year. Like the first-year rate it moves the value line, not the loan.

Unit fraction Default Not set Range 0 to 0.25
Dealer Fees
When omitted Blank
About this input

Optional. The dealer's documentation fee and any other charge the dealer adds to the price. Leave it blank if there is none, and it reads as nothing. These fees are taxed with the price, as the states that address them say, and are financed with it.

Unit $ Default Not set Range 0 to 1000
Deduction Tax Rate
When omitted Blank
About this input

Optional. Your federal income tax bracket rate, entered only if this car qualifies for the 2025 law's car-loan interest deduction: bought new, with final assembly in the United States, for personal use, with a loan secured by the car. Leave it blank and the deduction is not counted, which is right for a used, imported, leased or business vehicle; whether yours qualifies is not something the model can check.

Unit fraction Default Not set Range 0 to 0.37
APR (required)
About this input

The annual percentage rate on the loan. It is divided by twelve to give the rate charged each month, which is how an APR is defined, and a lender that charges interest on a daily balance will differ from this by cents. Zero is allowed and priced as a plain division of the amount by the months. It is also what the table at the foot varies down its side.

Unit fraction Default 0.0635 Range 0 to 0.25
Cash Rebate
When omitted Blank
About this input

Optional. Customer cash from the manufacturer, taken off the price. Leave it blank if there is none, and it reads as nothing. Whether it also comes off the taxed price is the rebate rule. Enter a promotional rate as well to see whether the rebate or the low rate offered instead of it costs less.

Unit $ Default Not set Range 0 to 15000
Down Payment (required)
About this input

Cash paid toward the car at signing, which reduces what is borrowed. It is asked for rather than assumed because nothing down is a real answer and not an omission: many loans are written that way, and then the whole cost is borrowed. A trade-in and a rebate are entered separately and are not part of this figure.

Unit $ Default 5800 Range 0 to 30000
First Year Depreciation
When omitted Blank
About this input

Optional. How much of the price the car loses in its first year. Leave it blank to use 20 percent, Kelley Blue Book's own statement of a typical first year, for which it publishes no dataset. An entered 0 means the car keeps its whole value that year. It moves only the value line and the months upside down, never the loan.

Unit fraction Default Not set Range 0 to 0.4
Government Fees
When omitted Blank
About this input

Optional. Title, registration and plate fees paid to the state at purchase. They vary by state from tens to thousands of dollars and no national figure exists to stand in for them, so a blank reads as nothing: the fees are then left out, and the total cost, and the payment when they are financed, are understated by them. They are not taxed.

Unit $ Default Not set Range 0 to 2500
Filing Status (required)
About this input

The filing status on your federal return. It sets the income above which the car-loan interest deduction starts to shrink, which under the 2025 law is 200,000 of modified adjusted gross income on a joint return and 100,000 on the others. Nothing else reads it, so it matters only when a tax rate and an income are entered.

Default Single Allowed Single, Married filing jointly, Married filing separately, Head of household
Finance Taxes And Fees (required)
About this input

Whether the sales tax and the government fees are added to the loan or paid in cash at signing. Adding them raises the amount financed, the payment and the interest, and it is one of the usual reasons a loan starts out owing more than the car is worth.

Default Yes Allowed Yes, No

Outputs

Table1 Interest Column Axis
About this output

The terms across the top of the table: your own term in the middle, then six-month steps either side, never shorter than a month. The longest columns can pass what the term input allows; they are priced the same way, since the interest needs no schedule. Read down a column to hold the term and vary the rate.

No unit declared
Sales Tax
About this output

The sales tax on this purchase, at the rate entered on the taxed price. When the tax is added to the loan it is borrowed too, so it carries interest for the whole term.

Unit $
Table1 Interest Corner
About this output

Machinery. Excel requires the figure being tabulated to sit at the top-left corner of the table, where it means nothing to a reader, so it is hidden. It holds the interest over the whole loan.

Unit currency
Table1 Interest Column Input
About this output

Machinery, and NOT an input. The same for the term: each term across the top is put here in turn while the table is filled, and the rest of the time it repeats the term you entered.

Unit months
Promo Total Interest
About this output

The interest over the whole loan at the promotional rate, on the larger amount that is borrowed without the rebate. At 0 percent it is nothing. It is 0 when no promotional rate is entered.

Unit $
Promo Total Cost
About this output

Everything the purchase costs on the promotional offer: the full price with no rebate, its sales tax, the fees, the interest at the promotional rate and any trade-in debt. It is 0 when no promotional rate is entered.

Unit $
Rebate Advantage
About this output

The promotional offer's total cost less the rebate offer's. Positive means taking the rebate at your APR is cheaper by that much; negative means the promotional rate is. Where your state taxes the price before the rebate, the rebate still carries its tax, and the comparison counts it.

Unit $
Qualifying Interest Share
About this output

The part of the loan whose interest can count toward the car-loan interest deduction: the amount financed less any debt carried over from a trade-in, as a share of the amount financed. The final regulations exclude interest on that debt, and the model spreads the exclusion evenly over every month's interest, which the regulations do not prescribe. It is never below 0.

Unit fraction
Total Cost After Deduction
About this output

Everything the purchase costs, less the federal income tax the deduction saves. With no tax rate entered it equals the total cost.

Unit $
Total Cost
About this output

Everything this purchase costs over the loan: the price less any rebate, the sales tax, the dealer and government fees, the interest, and any debt carried over from the trade-in. Insurance, fuel, upkeep and the value the car keeps at the end are not in it.

Unit $
Total Of Payments
About this output

Every payment added up: the monthly payment times the number of months. Add the cash at signing and any trade-in equity used and you have everything the purchase costs.

Unit $
Total Interest
About this output

What the loan charges in interest over its whole life: the total of the payments less the amount financed. It is the figure the table at the foot tabulates, and it rises with both the APR and the term.

Unit $
Table1 Interest Row Input
About this output

Machinery, and NOT an input. While the table is filled, each APR down its side is put here in turn and the whole model reads it; the rest of the time it repeats the APR you entered. Change the APR above, never this: the axis is built from the APR you entered, so changing this would move the axis while the table is being filled.

Unit fraction
Table1 Interest Row Axis
About this output

The APRs down the side of the table: your own rate in the middle, then one percentage point steps either side, never below 0 percent. Read along a row to hold the rate and vary the term.

No unit declared
Taxable Price
About this output

The amount the sales tax is charged on: the price and the dealer fees, less the trade-in when your state credits it, and less the rebate when your state taxes the price after it. Government fees and any debt from a trade-in are never part of it.

Unit $
Table1 Interest Values
About this output

The body of the table: the interest over the whole loan on this same deal, worked out again for every pair of APR and term on the two axes. One hundred and twenty-one figures, each the whole calculation run again, with less interest green and more red. Nothing here is a forecast or a probability: both axes are choices on your offer.

Unit currency
Promo Monthly Payment
About this output

The monthly payment if you take the promotional rate instead of the rebate: the same deal with the rebate left out, financed at the promotional rate over the same term. It is 0 when no promotional rate is entered.

Unit $/month
Deduction Reduction
About this output

What the deduction loses each tax year because of income: 200 for each 1,000 or part of 1,000 of modified adjusted gross income above the threshold for your filing status. It is shown whenever a tax rate and an income are both entered, whatever the term, because it is a fact about the income rather than the loan.

Unit $/year
Deductible Interest Year One
About this output

The deduction for the first tax year: that year's qualifying interest, capped at 10,000 and reduced for income, never below 0. The first payment is taken to fall in January 2026, so payments 1 to 12 count in that year; a loan whose first payment comes later counts fewer, so this is an upper estimate. It is 0 when no tax rate is entered.

Unit $
Deduction Saving Year One
About this output

What the first year's deduction saves in federal income tax: the deduction times the tax rate entered. It is a saving on your return, not a lower rate on the loan, and state income tax on it is not counted.

Unit $
Deduction Saving Total
About this output

What the deduction saves over all its tax years at the tax rate entered. It is usually far below the 10,000 a year the law allows, because a typical loan pays much less interest than that, and most of it early.

Unit $
Better Offer
About this output

Names the cheaper of the two offers, says they cost the same when the totals are within half a cent, or says that no promotional rate was entered. It compares total cost, not the monthly payment, and it assumes you qualify for the promotional rate, which usually needs top-tier credit.

No unit declared
Amount Financed
About this output

What is borrowed: the price and the dealer fees, the sales tax and government fees when they are added to the loan, and any debt from the trade-in, less the rebate, the down payment and the trade-in's value. It is never shown below nothing; when the cash and credits cover everything there is no loan to price.

Unit $
Deductible Interest Total
About this output

The deduction added over the tax years the law covers, 2026 to 2028 with the first payment in January 2026: the first 36 payments' qualifying interest, each year capped and reduced for income. Interest paid after 2028 is not deductible under the law as written.

Unit $
Cash At Signing
About this output

The cash paid when the deal is signed: the down payment, plus the sales tax and government fees when they are not added to the loan.

Unit $
Monthly Payment
About this output

The level payment that clears the amount financed over the term at the APR, the same every month. It is not rounded to cents: a lender rounds each payment and lets the last one absorb the difference, and one that charges daily interest differs by cents with the payment dates.

Unit $/month
Model Status
About this output

Reads OK, or explains why the inputs cannot be priced, or what deserves a second look: a trade-in worth less than what is owed on it, owing more than the car is worth for more than half the loan, or a deduction the income has fully phased out.

No unit declared
Negative Equity
About this output

The amount by which what is still owed on the trade-in exceeds what it is worth, carried into this loan. It is money borrowed for a car you no longer own, so it raises the payment and the interest, and it starts this loan owing more than the new car is worth.

Unit $
Months Upside Down
About this output

How many month-ends of the loan find you owing more than the car's estimated value, by more than half a cent. In those months, selling or trading the car, or losing it to theft or a crash without gap cover, would leave a debt to clear. It rests on the value estimate, which is typical depreciation at average mileage.

Unit months
Largest Shortfall
About this output

The most by which the balance exceeds the car's estimated value at any month-end of the loan, the day of signing included; 0 if it never does. It is the debt you would have to clear if you sold at the worst moment.

Unit $
Equity At Signing
About this output

The agreed price less the amount financed. A negative figure means the loan starts out larger than the price of the car, which is what financing the tax and fees, or carrying over debt from a trade-in, does.

Unit $
Loan By Year
About this output

One row for each year the loan runs: the principal repaid and the interest paid in that year, the balance owed and the car's estimated value at the year end, and the equity between them. Years the loan does not reach are blank rather than zero, and the last row is a part year when the term is not a whole number of years.

No unit declared
Last Month Upside Down
About this output

The last month of the loan in which the balance is still above the car's estimated value, counted from the first payment; 0 means it never is. From the month after it, the car is worth more than what is owed on it.

Unit months
This page is provided by LogicCommons for informational purposes only. Results are model outputs computed from the inputs you supply and are not financial, investment, tax, accounting, or legal advice, and no advisory relationship is created. Verify all inputs and results independently before relying on them in any decision.

LogicCommons is in beta. If a result, label, or reference looks wrong, tell us here; we read every message.

Methodology

Purpose and model boundary

Works out the monthly payment on a car loan built from the whole deal: the sales tax charged under your state's own rules for a trade-in and a rebate, dealer and government fees, a trade-in with any debt still owed on it, and a manufacturer's rebate set against a promotional rate. Use it to see what the loan really costs, how many months you would owe more than the car is worth, and what the 2025 car-loan interest deduction is worth at your own tax rate and income.

The workbook is the calculation authority. The page groups and explains its inputs and returned figures; it does not reproduce the financial logic in browser code.

Inputs and units

Input Unit Accepted range What it means
Promo APR % 0% through 6% Optional.
Rebate Tax Rule choice listed options Whether your state charges sales tax on the price before a manufacturer's rebate comes off, or after it.
Loan Term Months months 12 through 96 How many monthly payments the loan runs for.
MAGI $/year 0 through 300000 Optional.
Sales Tax Rate % 0% through 12% The combined state and local rate charged on a vehicle sale, entered as a percentage, so 7.5 percent is 7.50%.
Trade In Value $ 0 through 60000 Optional.
Vehicle Price $ 3000 through 150000 The price agreed with the seller for the car itself, before sales tax, fees, any rebate or any trade-in.
Trade In Owed $ 0 through 60000 Optional.
Trade In Tax Rule choice listed options Whether your state charges sales tax on the price less the trade-in's value, or on the full price.
Later Depreciation % 0% through 25% Optional.
Dealer Fees $ 0 through 1000 Optional.
Deduction Tax Rate % 0% through 37% Optional.
APR % 0% through 25% The annual percentage rate on the loan.
Cash Rebate $ 0 through 15000 Optional.
Down Payment $ 0 through 30000 Cash paid toward the car at signing, which reduces what is borrowed.
First Year Depreciation % 0% through 40% Optional.
Government Fees $ 0 through 2500 Optional.
Filing Status choice listed options The filing status on your federal return.
Finance Taxes And Fees choice listed options Whether the sales tax and the government fees are added to the loan or paid in cash at signing.

Governing relationships

The taxable price starts with the vehicle price and taxable dealer fees, then applies the selected state treatment of trade-in value and manufacturer rebate.

Amount financed = vehicle price + financed tax and fees + trade-in debt - rebate - down payment - trade-in value, floored at zero.

For a nonzero annual percentage rate, the monthly payment is the standard level-payment annuity on the amount financed. At zero, it is the amount financed divided by the term.

Total interest = monthly payment × term - amount financed.

The estimated market value loses the entered first-year share and then the entered later-year share. Months upside down counts months when the loan balance is above that estimated value.

Calculation sequence

  1. The taxable price starts with the vehicle price and taxable dealer fees, then applies the selected state treatment of trade-in value and manufacturer rebate.

  2. Amount financed = vehicle price + financed tax and fees + trade-in debt - rebate - down payment - trade-in value, floored at zero.

  3. For a nonzero annual percentage rate, the monthly payment is the standard level-payment annuity on the amount financed. At zero, it is the amount financed divided by the term.

  4. Total interest = monthly payment × term - amount financed.

  5. The estimated market value loses the entered first-year share and then the entered later-year share. Months upside down counts months when the loan balance is above that estimated value.

  6. Rerun the calculation across the delivered two-way table and chart ranges so the effect of changing the stated assumptions is visible.

Outputs and interpretation

Output Role Unit What it means
Total Interest primary $ What the loan charges in interest over its whole life: the total of the payments less the amount financed.
Monthly Payment primary $/month The level payment that clears the amount financed over the term at the APR, the same every month.
Months Upside Down primary months How many month-ends of the loan find you owing more than the car's estimated value, by more than half a cent.

Model Status reports whether the workbook accepted the current entries and whether an assumption deserves review. It describes model health, not whether the calculated outcome is good or bad.

Every figure above is returned by the workbook. The page arranges and formats the figures; it computes none of them.

Validation and status logic

Condition Returned status
The entries are accepted and no additional model warning applies OK
you would owe more than the car is worth for more than half of the loan. CHECK: you would owe more than the car is worth for more than half of the loan.
the down payment, trade-in and rebate cover the whole cost, so there is nothing to finance. NOT VALID: the down payment, trade-in and rebate cover the whole cost, so there is nothing to finance.
the trade-in is worth less than what is still owed on it, and the difference is added to this loan. CHECK: the trade-in is worth less than what is still owed on it, and the difference is added to this loan.

Assumptions and limitations

  • A lender that accrues daily interest can differ by cents from the monthly model.
  • Vehicle value follows the depreciation rates entered and is not an appraisal or sale offer.
  • Insurance, fuel, maintenance and repair are outside this loan calculator.
  • The federal interest deduction applies only when the vehicle and loan meet the legal conditions described in the source material.

Restrictions and non-computing states

Numeric entries outside the accepted ranges above are refused before calculation. A state the workbook itself marks NOT VALID returns no usable answer. Optional blanks follow the workbook's documented treatment and are not silently replaced by page logic.

The sensitivity table is a set of recalculations across its two axes. It is not a probability surface or a forecast.

Errors and warnings

NOT VALID means the entered question cannot be computed as stated. CHECK means the workbook returned figures but identified an assumption or combination that deserves attention. OK means the current entries passed the workbook's model checks; it does not mean the financial outcome is recommended.

A transport or service failure is reported separately and never replaced with a stale or partial result.

References

Sources and further reading

These sources provide background; they do not supply the calculator's assumptions or certify its result. Values that vary by household, offer, place or time remain inputs for the reader to check.

This calculator is informational and is not financial, investment, or tax advice. Verify important decisions against current official rules, the actual offer or account terms, and an appropriately qualified professional.

Results are informational and not professional advice. See our Terms of Use. Powered by SpreadsheetWeb · About · Privacy · Terms