Blog · Finance metrics and formulas
Calculate the automotive cash conversion cycle separately for a manufacturer and a dealer. Work through inventory, receivables, trade payables, and a floorplan financing adjustment using consistent finance exports.
The cash conversion cycle in the automotive industry is inventory days plus receivable days minus trade payable days, calculated for a clearly defined operating business. Separate manufacturers from dealers, and keep inventory financing visible alongside the cycle so borrowing does not get mistaken for faster stock turnover or longer supplier terms.
A manufacturer holds materials, work in process, and finished vehicles or components. A dealer holds purchased vehicles and potentially parts, while collecting from retail customers, commercial accounts, or finance providers. Those balances describe different operating activities.
Start with a business-unit boundary. A vehicle manufacturing unit should not silently absorb a captive financing subsidiary's loan receivables. A vehicle-only dealer calculation should not combine vehicle sales with inventory and receivables from an excluded service operation. Keep the included balances and income statement flows on the same basis.
The general cash conversion cycle guide owns the underlying formula and broader interpretation. This application concentrates on automotive scope and the financing distinction. For comparisons across sectors, use cash conversion cycle by industry rather than treating an automotive business as representative of every inventory business.
Use the inventory valuation report, customer receivables aging, supplier payables aging, and the matching revenue and cost-of-goods-sold export. Retain opening and closing balances, period dates, business unit, currency, and account classification.
Average balance = (Opening balance + Closing balance) / 2
DIO = Average inventory / Cost of goods sold × Period days
DSO = Average trade receivables / Credit sales × Period days
DPO = Average trade payables / Cost of goods sold × Period days
Cash conversion cycle = DIO + DSO - DPO
The CFA Institute's financial analysis reading identifies inventory, receivable, and payable days as activity measures and the cash conversion cycle as a liquidity measure. It does not establish one automotive benchmark that makes unlike business units comparable.
This example uses cost of goods sold as the DPO denominator. If finance uses credit purchases instead, retain that policy consistently and label it. Check the cost of goods sold definition when moving between manufacturing and resale operations, because different cost scope can change the denominator.
Opening and closing averages are an approximation. Use consistently timed monthly or more frequent balances when production schedules, deliveries, or quarter-end inventory swings make the two endpoints unrepresentative.
Consider two illustrative US operating units over the same 90-day period. For this arithmetic, all sales are credit sales; the dealer serves commercial fleet customers. These are examples, not reported industry averages or assumptions about every retail dealer.
| Input (USD) | Manufacturer | Dealer |
|---|---|---|
| Period credit sales | 18,000,000 | 9,000,000 |
| Period cost of goods sold | 13,500,000 | 7,200,000 |
| Opening inventory | 8,000,000 | 3,000,000 |
| Closing inventory | 10,000,000 | 3,400,000 |
| Opening trade receivables | 2,400,000 | 200,000 |
| Closing trade receivables | 3,600,000 | 400,000 |
| Opening trade payables | 4,000,000 | 300,000 |
| Closing trade payables | 5,000,000 | 500,000 |
The average balances and component calculations follow directly:
| Calculation | Manufacturer | Dealer |
|---|---|---|
| Average inventory (USD) | (8,000,000 + 10,000,000) / 2 = 9,000,000 | (3,000,000 + 3,400,000) / 2 = 3,200,000 |
| Average receivables (USD) | (2,400,000 + 3,600,000) / 2 = 3,000,000 | (200,000 + 400,000) / 2 = 300,000 |
| Average trade payables (USD) | (4,000,000 + 5,000,000) / 2 = 4,500,000 | (300,000 + 500,000) / 2 = 400,000 |
| Inventory days | 9,000,000 / 13,500,000 × 90 = 60 | 3,200,000 / 7,200,000 × 90 = 40 |
| Receivable days | 3,000,000 / 18,000,000 × 90 = 15 | 300,000 / 9,000,000 × 90 = 3 |
| Payable days | 4,500,000 / 13,500,000 × 90 = 30 | 400,000 / 7,200,000 × 90 = 5 |
| Cash conversion cycle | 60 + 15 - 30 = 45 | 40 + 3 - 5 = 38 |
All displayed days are exact in this example. In a live review, calculate with unrounded balances and round displayed days consistently.
Rebuild each average balance from its days as a check. Manufacturer inventory is 60 × 13,500,000 / 90 = $9,000,000. Dealer receivables are 3 × 9,000,000 / 90 = $300,000. Dealer trade payables are 5 × 7,200,000 / 90 = $400,000. The reconstructed figures must match the average-balance schedule, whose endpoints must tie to the corresponding finance reports.
Floorplan financing funds inventory. The OCC's Floor Plan Lending handbook explains that proceeds from selling the inventory are the primary repayment source for a floorplan loan. That financing obligation needs its own review alongside inventory aging and sale proceeds.
Suppose the dealer also has these financing balances:
| Financing input | Amount (USD) |
|---|---|
| Opening floorplan borrowing | 2,200,000 |
| Closing floorplan borrowing | 2,600,000 |
| Average floorplan borrowing | (2,200,000 + 2,600,000) / 2 = 2,400,000 |
If someone adds the average floorplan borrowing to average trade payables, the apparent payable balance becomes 400,000 + 2,400,000 = $2,800,000. Apparent DPO becomes 2,800,000 / 7,200,000 × 90 = 35 days, and apparent CCC becomes 40 + 3 - 35 = eight days.
That is 30 days below the operating result of 38 days, entirely because financing entered the payable balance. No vehicle moved faster and no customer paid earlier. Separate borrowing by economic purpose even when the source export uses a broad payable label. Finance should approve the mapping and preserve a reconciliation to the reported account totals.
Keep dealer sales, cost of goods sold, receivables, and trade payables unchanged. Reduce average inventory from $3,200,000 to $2,800,000:
| Measure | Original | Variation |
|---|---|---|
| Average inventory (USD) | 3,200,000 | 2,800,000 |
| Inventory days | 40 | 2,800,000 / 7,200,000 × 90 = 35 |
| Receivable days | 3 | 3 |
| Payable days | 5 | 5 |
| Cash conversion cycle | 38 | 35 + 3 - 5 = 33 |
Daily cost of goods sold is 7,200,000 / 90 = $80,000. The five-day inventory reduction represents 5 × 80,000 = $400,000 less average inventory investment, matching 3,200,000 - 2,800,000. It is not automatically a $400,000 increase in unrestricted cash: purchases, sale receipts, and floorplan repayments determine the actual cash movement.
Operations owns the explanation for production stages, vehicle age, and slow-moving stock. Credit and collections investigates customer balances and settlement delays. Procurement and finance examine supplier terms and payment behavior, using days payable outstanding for the supplier timing detail.
Treasury separately reviews floorplan balances, repayment requirements, and interest costs. Bring these owners to the same review, while keeping their operating and financing schedules distinct.
Bring your inventory, receivables, trade payables, sales, and cost exports to Covirage, with floorplan balances identified separately. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the component changes with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for FP&A reporting for the finance review context.
For an operating cash conversion cycle, keep floorplan borrowing separate from supplier trade payables. It finances inventory rather than measuring ordinary supplier payment timing. Reconcile it in a separate financing schedule, even when the export groups floorplan balances under a broad payable caption.
There is no universal target that applies to every dealership. Vehicle mix, inventory age, customer payment arrangements, and supplier terms change the result. Compare the same business scope over time, then examine the inventory and collection rows behind any movement before setting a target.
Yes, but identical totals can contain different operating conditions. A manufacturer could have longer inventory holding offset by longer supplier terms, while a dealer could collect quickly but hold aging vehicles. Compare the component days and financing separately before treating equal totals as equivalent performance.