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.
Compare scenarios
How the result changes
This input can't be charted across its full range — the formula has no valid result for most of it. Pick another input above.
Export Report
How would you like to export your results?
Share
Preview
Result
—
❮ ❯ switch fields·− + change value
0
Formula
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.
Report a Problem
Help us fix issues faster
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
Depreciation % Retained Calculator
Calculate what percentage of its original value a car has retained after depreciation.
Best Time to Sell Calculator
Calculate the optimal holding period that minimizes average annual cost of ownership.
Mileage Impact on Resale Value
Calculate how above- or below-average mileage affects a vehicle's resale value.
Service History Value Premium
Calculate the resale premium a full service history adds to your car's baseline valuation.
Single Owner Premium Calculator
Calculate the premium a single-owner vehicle commands over an equivalent multi-owner baseline.
People also use
Monthly Car Payment Calculator
Financing & PurchaseCalculate your monthly car loan payment from loan amount, APR, and term in months.
Fuel Cost for a Journey
Fuel & EfficiencyCalculate the total fuel cost for a journey from distance, MPG, and fuel price per litre.
Loan vs Lease Comparison
Cost of OwnershipCompare total cost of buying on finance versus leasing over different terms and buyout scenarios.
EV vs Petrol Total Cost (5yr)
EV vs ICECompare total cost of ownership—purchase price, fuel, and depreciation—for EV vs petrol over 1–20 years.
Braking Distance Calculator
Performance & EngineeringCalculate total stopping distance from speed, road friction and driver reaction time.
Long Road Trip Total Cost
Practical & UtilityCalculate total fuel, lodging, food, and toll expenses for a multi-day road trip.