MotorMath
Resale & Depreciation

Months on Lot Value Erosion

Estimate a car's negotiated value after sitting unsold on the dealer lot for months

Last updated:

What this tool does

This calculator applies compound monthly depreciation to estimate a car's realistic negotiated value after sitting unsold on a dealer lot. It requires the current asking price, the number of months the vehicle has been listed, and a monthly erosion percentage, then computes the compounded eroded value. The formula assumes constant monthly erosion; actual dealer pricing may vary based on inventory strategy, condition changes, and local demand.

Inputs
(£)
(months)
(%)
Result
Result
Formula
Eroded value after time on lot
Asking price (£)
Monthly value erosion (%)
Months on lot

How Months on Lot Value Erosion works

A car sitting unsold on a dealer lot typically loses perceived value each month. Buyers recognise that older inventory may signal lower demand, potential condition issues, or a dealer's increased motivation to clear space. This tool calculates the compounded effect of that erosion: it takes the original asking price and reduces it by a fixed percentage each month the vehicle remains unsold, using the same compound logic as depreciation.

The formula

The calculator uses compound monthly erosion:

Eroded value = Asking price × (1 − Monthly erosion % ÷ 100)Months on lot

For example, a £18,000 car listed for 4 months at 1.5% monthly erosion becomes £18,000 × (1 − 0.015)4 = £16,944. The tool also reports total value eroded (£18,000 − £16,944 = £1,056) and the overall erosion percentage (5.9%).

Where this method is most accurate

Compound erosion models work best for franchised dealers with public inventory systems where list dates are visible and market forces are relatively transparent. The assumption of constant monthly erosion holds most reliably over 1–6 months; beyond that, dealer strategy shifts (auction, trade-in, reconditioning) often dominate. The calculation does not account for mid-listing price reductions, condition changes, or seasonal demand swings.

What this tool does not do

The calculator does not retrieve actual listing dates from any database, verify the asking price against book values, or incorporate vehicle history, mileage, or mechanical condition. It does not suggest a specific offer amount or predict whether a dealer will accept a given bid. The erosion percentage is user-supplied; real erosion rates vary widely by make, model, body style, and local market velocity.

Disclaimer

This tool is for educational and estimation purposes only. It does not constitute financial advice, vehicle valuation, or a guarantee of negotiation outcomes. Actual dealer pricing depends on inventory costs, holding expenses, reconditioning, and buyer competition. Always inspect the vehicle history, conduct a pre-purchase inspection, and verify all transaction terms independently before committing to a purchase.

Questions

How do I find out how long a car has been on the lot?
Many online dealer listings show a "days on market" or "listed since" date. Alternatively, ask the salesperson directly or check third-party aggregators (AutoTrader, Motors.co.uk) that timestamp first appearance. This calculator requires the user to supply that figure manually.
What is a typical monthly erosion rate?
Monthly erosion rates vary widely. High-demand models may see 0.5–1%, while slow-moving or niche vehicles can erode 2–3% per month. The user sets the rate based on market research or negotiation assumptions; the calculator does not supply default rates tied to specific makes or models.
Does this formula account for dealer price reductions?
No. The calculation assumes the asking price entered is the current listed price and that erosion compounds from that baseline. If the dealer has already reduced the sticker mid-listing, enter the new asking price and adjust the months-on-lot count to reflect the period since the last reduction.
Can I use this for private-seller cars?
The logic applies to any vehicle sitting unsold, but private sellers often lack transparent listing dates and may not adjust prices as systematically as dealers. The erosion-percentage input becomes more subjective in private sales, and the compound model may overstate value loss if the seller is not actively marketing.
Is the eroded value a fair offer price?
The eroded value is a mathematical estimate, not a recommended bid. Actual negotiation depends on the vehicle's mechanical condition, service history, competing inventory, dealer holding costs, and buyer leverage. Use the output as one data point alongside book values, inspection reports, and comparable sales.

Spotted something off?

Calculations or display — let us know.

Sources & Methodology

The calculator applies compound monthly depreciation: Eroded value = Asking price × (1 − Monthly erosion % ÷ 100)^Months on lot. This mirrors the standard compound-depreciation formula used in retail inventory valuation. The method assumes constant monthly erosion; real-world dealer pricing may deviate due to inventory strategy, reconditioning, or market shifts.

Related tools

People also use