Floor Plan Finance

Days on Lot: The Metric Floor Plan Lenders Should Track But Often Do Not

Harm-Julian Schumacher 7 min read

Days on lot is a measure of how long a vehicle has been in a dealer's inventory since acquisition. It is the primary aging metric for inventory management, and it is the most direct available indicator of whether a dealer's inventory is performing as expected under the terms of their floor-plan credit. It is also a metric that most floor-plan lenders in the Philippine used-car market do not currently track at the unit level on an ongoing basis.

That gap has a cost. Not a theoretical cost based on models, but a practical one: lenders who do not track days on lot are making credit management decisions without the most operationally relevant piece of information available to them. They are relying on payment history, which tells them what happened, when they could also be using lot data, which tells them what is happening now and where it is likely to go.

What Days on Lot Tells a Lender

Days on lot for a specific unit tells the lender how long that unit has been consuming collateral coverage in the credit line without generating a sale that would produce a curtailment payment and release the advance. It is a direct measure of the velocity mismatch: how long the asset has been on the lender's books versus how long it was expected to be there when the advance was made.

For a dealer whose typical inventory turns in 25 to 30 days, a unit that has been on lot for 50 days is already outside the normal operating pattern. For a dealer who averages 40 days, 50 days is unremarkable. Days on lot is only interpretable in the context of that dealer's baseline, which is why the metric needs to be tracked over time, not read as a single data point.

The pattern over time is what carries the most information. A unit at 35 days from a dealer whose portfolio is typically turning in 28 days is a mild flag. Three units at 45 days, 52 days, and 63 days from the same dealer is a different signal: the dealer's aging tail is growing, and the pattern is consistent across multiple units rather than a single anomaly. The pattern signals a systematic change in how the dealer's inventory is performing, which is a credit management signal even if payment performance has not yet changed.

The Connection Between Days on Lot and Depreciation

The significance of days on lot for lenders is not just operational. It is directly tied to the collateral economics of the credit relationship.

Every additional day a unit spends on the lot without selling is a day during which the unit's realistic recovery value is declining. The rate of decline varies by model, condition, and market conditions, but the direction does not vary. Used vehicles are depreciating assets, and lot time accelerates the depreciation relative to what would have occurred if the unit had been sold promptly.

The floor-plan advance against the unit was sized based on the unit's value at origination. If the unit's value has declined materially while the advance has remained constant, the effective loan-to-value ratio has increased. The lender is now carrying more credit exposure per unit of collateral value than they were when the advance was made. This is a concrete change in the lender's risk position, and it happens automatically as the unit ages, without any payment event or any change in the dealer's reported financials.

Days on lot is the leading indicator for this depreciation effect. By the time a unit's declining value shows up in a payment problem, it has typically been aging in the elevated buckets for weeks or months. Days on lot monitoring gives the lender visibility into the depreciation process while it is still developing, not after it has produced a loss.

Why Lenders Do Not Currently Track It

The reasons floor-plan lenders typically give for not tracking days on lot as a monitoring metric fall into three categories, each of which has a practical response.

The first is data availability. The most common version of this objection is that dealers do not provide unit-level acquisition dates in their regular reporting. This is accurate for many dealers who submit summary stock lists without unit-level timestamps. The practical response is that VIN transaction records from LTO data and from dealer DMS exports can provide arrival dates for most units, and marketplace listing dates for actively marketed units provide another approximation. The data is often available from sources independent of the dealer's self-reporting, even if the dealer's own stock list does not include it.

The second is monitoring complexity. Tracking days on lot per unit, per dealer, across a portfolio of many dealers, is genuinely more operationally complex than tracking a single aging summary per dealer. The objection is real. The response is that the complexity is addressable through the right tooling, and that the cost of the additional monitoring infrastructure is substantially lower than the cost of absorbing losses that the monitoring would have enabled the lender to prevent.

The third is precedent: if days on lot monitoring were important, existing lenders would already be doing it. This is a reasoning pattern rather than an argument. The adoption rate of a monitoring practice among incumbent lenders is not a reliable indicator of whether the practice adds value. It is an indicator of how established the practice is, which can reflect inertia, capability gaps, or competitive considerations as easily as it reflects a judgment about value.

What Changes When Lenders Track Days on Lot

When a lender adds days on lot monitoring to their credit management workflow, several things change in how they manage the relationship with dealers.

First, they can have proactive conversations with dealers about specific units rather than generic conversations about portfolio performance. Knowing that a dealer has three units beyond 60 days and one beyond 90 days, and knowing the model category and last listed price for each, enables a substantive conversation about what the dealer's plan is for each unit. That conversation, early in the aging cycle, is qualitatively different from a conversation six months later when the lender is trying to understand why the credit line is under stress.

Second, credit line adjustments become grounded in specific collateral data. A lender who reduces a credit line during a portfolio review without being able to explain exactly which collateral items drove the decision is in a weaker position, both analytically and in conversation with the dealer, than one who can say: these specific units have aged beyond our policy threshold, and until they clear or the credit line is adjusted to reflect their current collateral value, we are not in a position to extend further credit against them. The specificity is not just analytically stronger. It is more useful for the dealer, who can then focus on the specific units that are affecting their credit availability.

Third, the lender's credit policy can be calibrated to the actual aging behavior of their dealer book. A lender who has tracked days on lot across their portfolio over time knows what the typical aging distribution looks like, what seasonal patterns exist, and how their dealers compare to each other. That baseline allows them to identify anomalies more quickly and to set policy thresholds that reflect actual market behavior rather than round-number assumptions.

Getting Started Without Full Infrastructure

Lenders who want to add days on lot monitoring to their workflow do not need to implement a complete system before they start seeing value. A starting point that many lenders find manageable is to add a single field to the existing stock list submission requirement: the acquisition date for each unit. With that date and the current date, the days on lot for each unit can be computed in any spreadsheet tool.

The immediate benefit is visibility into the aging tail: which specific units have been on lot the longest, and whether any have crossed meaningful thresholds. Even a manually updated tracking sheet that flags units beyond 45 and 60 days gives the lender's credit managers something concrete to follow up on with each dealer, without requiring any significant system investment.

The progression from manual tracking to automated monitoring, with VIN-level data feeds and algorithmic threshold alerting, is a continuous improvement, not a prerequisite. The value of days on lot data is proportional to how regularly it is updated and how quickly the lender acts on the signals it produces. Starting simple and increasing sophistication over time is a more practical path than waiting for the full infrastructure before beginning.

Add lot aging to your credit monitoring stack

OneLot tracks days on lot at the unit level for each dealer in your portfolio and delivers aging alerts so you can act before inventory deterioration becomes a payment problem.

For lenders Request access
← Back to Insights