Blog · Finance metrics and formulas
Dealership inventory turnover can measure vehicles sold or the cost of vehicles sold against average stock. This page separates those bases, works new and used vehicle examples, and checks the result against inventory movements and aging.
The car dealership inventory turnover ratio compares vehicles sold with the average inventory held during the same period. Calculate unit turns for the sales desk and cost-based turnover for finance, with new and used vehicles shown separately. Read both beside aging: a strong overall ratio can hide a small group of vehicles that never moves.
Unit turns for the period = Vehicles sold / Average vehicle units held
Financial inventory turnover for the period = Vehicle cost of sales / Average vehicle inventory at cost
Simple average inventory = (Opening inventory + Closing inventory) / 2
Unit turns answer how quickly vehicles leave relative to the number held. Financial turnover answers how much vehicle cost moved through sales relative to the dollars invested in inventory. A change in the mix of inexpensive and expensive vehicles can move these measures differently.
The CFA Institute identifies inventory turnover and days of inventory as activity ratios. The general inventory turnover formula explains the financial measure; the dealership task is to keep vehicle counts, cost and sales channels on matching bases.
Do not divide vehicle sales revenue by inventory at cost and label that financial turnover. Revenue includes the margin earned, while inventory does not. For cost measurement, follow the ledger's established policy: the IRS describes purchased merchandise cost as invoice price after appropriate discounts plus transportation and other acquisition charges. That tax guidance does not replace your financial reporting policy, but it illustrates why sticker prices are the wrong inventory base.
Use a vehicle sales export with the vehicle identification number, department, delivery date, retail or wholesale channel, and booked vehicle cost of sales. Match it to opening and closing inventory exports containing the vehicle identifier, new or used classification, location, carrying cost and original receipt date.
Count delivered vehicles under the same cutoff used for revenue recognition in the ledger. A signed deal that remains undelivered should not silently enter one measure while the vehicle remains in the denominator of the other.
Decide whether this is a retail-only or all-disposals report. The example below includes all vehicle sales and their related costs. Exclude parts, service, finance and insurance income, and vehicles held on consignment that the dealership does not own. Identify demonstrators and loaners according to the company's accounting classification.
Use average daily inventory when snapshots are available. Opening and closing balances are a transparent fallback, but they can miss a large delivery or stock clearance inside the period.
An illustrative US dealership measures January 1 through March 31, 2026, a period of 90 days. These are its starting rows; dollar amounts use the same carrying-cost basis as the vehicle ledger.
| Department | Opening units | Closing units | Units sold | Opening inventory (USD) | Closing inventory (USD) | Vehicle cost of sales (USD) |
|---|---|---|---|---|---|---|
| New | 80 | 100 | 180 | 2,720,000 | 3,800,000 | 6,480,000 |
| Used | 50 | 70 | 150 | 900,000 | 1,540,000 | 2,850,000 |
Calculate the averages first, then divide the matching numerator by each average. Turns are rounded to two decimal places; calculations use unrounded inputs.
| Step | New vehicles | Used vehicles |
|---|---|---|
| Average units | (80 + 100) / 2 = 90 | (50 + 70) / 2 = 60 |
| Unit turns, quarter | 180 / 90 = 2.00 | 150 / 60 = 2.50 |
| Average inventory at cost (USD) | (2,720,000 + 3,800,000) / 2 = 3,260,000 | (900,000 + 1,540,000) / 2 = 1,220,000 |
| Financial turns, quarter | 6,480,000 / 3,260,000 = 1.99 | 2,850,000 / 1,220,000 = 2.34 |
Used vehicles turned faster on both bases. The gap between their unit and financial turns also tells you that vehicles sold had a different cost mix from vehicles held. It does not prove better pricing or stronger margins.
These are quarterly ratios. Keep that label when comparing departments or periods; do not compare them directly with an annual figure.
The inventory movement export provides the additions below. This example has no returns, transfers, reclassifications or valuation adjustments.
| Department | Units added | Cost added (USD) | Unit rollforward | Cost rollforward (USD) |
|---|---|---|---|---|
| New | 200 | 7,560,000 | 80 + 200 - 180 = 100 | 2,720,000 + 7,560,000 - 6,480,000 = 3,800,000 |
| Used | 170 | 3,490,000 | 50 + 170 - 150 = 70 | 900,000 + 3,490,000 - 2,850,000 = 1,540,000 |
Both closing quantities match the inventory export, and both closing costs match the ledger. Where transfers or adjustments exist, give them separate movement lines. A difference is a reconciliation problem to resolve before interpreting turnover.
Turnover measures movement across the period; aging examines the vehicles still held at its end. Apply the same elapsed-day definition to every vehicle, without resetting age after an internal transfer.
| Age at March 31 | New units | New carrying cost (USD) | Used units | Used carrying cost (USD) |
|---|---|---|---|---|
| 0-30 days | 45 | 1,710,000 | 28 | 616,000 |
| 31-60 days | 30 | 1,140,000 | 21 | 462,000 |
| 61-90 days | 15 | 570,000 | 14 | 308,000 |
| Over 90 days | 10 | 380,000 | 7 | 154,000 |
| Total | 100 | 3,800,000 | 70 | 1,540,000 |
New vehicles over 60 days old are (15 + 10) / 100 = 25.0% of closing units. Used vehicles over 60 days old are (14 + 7) / 70 = 30.0%. Faster used-vehicle turnover therefore coexists with a larger aged share.
The used-vehicle manager can review that stock for pricing, reconditioning delays or wholesale disposition. The new-vehicle manager can adjust ordering by vehicle type. The controller owns cost reconciliation and consistent classifications. Agree on those responsibilities before changing targets.
For the time-based financial companion, use days inventory outstanding; apparel inventory turnover covers a different industry's seasonal and product-mix questions.
Bring a sample of your own vehicle sales and inventory exports to Covirage, where columns are mapped and its tools compute and check unit turns, cost-based turnover and aging. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.
See spreadsheet file analysis for the supporting workflow.
There is no useful universal target across new vehicles, used vehicles, brands and selling seasons. Compare the same department over matching periods, then review gross profit, aged units and stock availability before deciding whether a higher turnover is better.
Use vehicle cost of sales when the inventory denominator is measured at cost. Revenue introduces vehicle margins into the ratio. For an operational unit measure, divide delivered vehicle units by average vehicle units and label it separately.
Yes. Fast sales of popular vehicles can support the overall ratio while other vehicles remain unsold. Review the age of each vehicle still held, using a consistent receipt date, and report aged units alongside their carrying costs.
A transfer changes the inventory location but is not a customer sale for the group. Include transfers in each location's stock reconciliation, eliminate them from group sales, and preserve the original group receipt date when measuring aging.