The 13-Month Rolling Forecast: What's Changed and What Hasn't

Most dealership controllers still rely on the same 12-month rolling forecast model their predecessors used a decade ago. They update the spreadsheet each month, shift the columns forward, drop in new numbers for month 13, and call it done. It works, sort of. But what actually needs to happen in 2024 to keep your forecast honest and actionable?

The honest answer: the fundamentals of good forecasting haven't changed. You still need accurate historical data, realistic assumptions about market conditions, and discipline about updating the model monthly. But the variables that drive your forecast, the rhythm of how you should monitor it, and the downstream consequences of getting it wrong have shifted dramatically. Understanding what's holding steady and what's evolved is the difference between a forecast that gathers dust and one that actually steers your dealership through uncertainty.

The Anchor That Still Holds: Rolling 13-Month Structure

The 13-month rolling forecast persists because it works. By projecting out 12 months and comparing that to an actual 13th month (the one you're currently in), you gain perspective on the full business cycle without getting lost in quarterly noise.

Here's why dealership controllers from Texas to the Northeast still use it: a rolling model forces you to think ahead. If you're sitting in January and looking only at January through December, you miss the fact that February's parts orders need to be placed now. Your floor plan borrowing capacity needs headroom. Your technician hiring needs to happen before the spring busy season crushes your scheduling.

That structural discipline hasn't become obsolete. What has changed is how much discipline the model itself now demands.

What's Changed: The Data Inputs Are Noisier Than Ever

Five years ago, a dealership controller could build a forecast based on a fairly linear extension of historical sales velocity, customer count, and market trends. The market moved. You adjusted. But the basic shape of the business remained recognizable.

Today's inputs are murkier. Consider what's hitting your forecast right now:

• Used inventory cycles are unpredictable. Days to front-line can swing 15 days month-to-month depending on auction pricing, trade-in quality, and reconditioning bottlenecks. A typical $8,500 used unit that used to sit 35 days might now sit 48 days, crushing your cash flow timing.
• Floor plan rates remain volatile. A 50-basis-point swing in your cost-per-day borrowing directly impacts carrying costs. That's not a 2% hit to margin. It's a 7–10% hit to net front-end gross on vehicles held longer than your model predicts.
• Customer credit behavior is tightening. Captive finance approvals are running 10–15% tighter than they were 18 months ago at many dealerships. Your down-payment assumption and contract type mix need quarterly reality checks, not annual ones.

And then there's the reality nobody likes to admit: your sales team's forecast of what they're going to close is almost always too optimistic.

Actually, scratch that. Let me be more specific. Your sales team's forecast is optimistic by about 8–12% in the first 30 days and gets dramatically worse beyond that. A sales manager projecting 45 units for next month might actually deliver 40 if the market stays flat. But if you ask them to forecast 90 days out, they'll give you 120, and you'll start paying them on deals that never happen while floor plan costs creep up on inventory that doesn't move.

The rolling 13-month model is still the right container. But the ingredients going into months 4–13 need fresh questioning every single month.

Cash Flow Timing: Now the Real Profit Driver

Controllers used to focus their 13-month forecast on top-line gross profit and break-even unit count. Those still matter. But the dealership that manages cash flow timing wins right now.

Here's a concrete scenario: say you're carrying a typical mixed inventory of 85 used units with an average cost of $12,000 and average front-line gross of $2,200. Your current floor plan rate is 4.5% annually (about $1.35 per day per vehicle). If your average days to front-line is 42 days instead of your budgeted 38 days, that's an extra $5,440 in carrying costs per month across the lot. Multiply that by 12 months in your forecast, and you're looking at $65,000 in unexpected floor plan expense that wipes out $40,000 in gross profit.

The old model would catch that eventually. The new requirement is catching it 30 days before it happens, not 30 days after.

This is exactly where a system like Dealer1 Solutions changes how you forecast. When you can see reconditioning status, part wait times, detail queue position, and actual days-to-front-line trending, you're not guessing at assumptions. You're projecting based on observed velocity. That reduces the forecast error band from ±12% down to ±4–5%, which is the difference between confident planning and expensive surprises.

The Monthly Update Ritual: More Frequent, More Forensic

Here's what's stayed the same: your office manager or controller needs to update the rolling forecast every single month. Same date, same discipline.

What's changed is what that update actually requires.

The old ritual: compare actuals to forecast, note variances, move the month forward, plug in month 13, move on. Twenty minutes. Done.

The new ritual needs to include three additional questions:

One: What assumptions broke? Not what numbers were off, but which assumptions driving those numbers no longer hold. If you forecasted 38 days to front-line and you're running 44, is it a temporary reconditioning backlog, or has your sourcing mix shifted to higher-mileage inventory that actually takes longer to recondition? The answer changes how you adjust month 13.

Two: What's the 60-day leading indicator? Look at your pipeline 60 days ahead. What's the appointment book showing? What's the trade-in flow looking like? What's your current auction activity relative to what you forecasted? If the leading indicators disagree with your month 13 projection, you don't have a data problem. You have a forecast problem.

Three: What's floor plan exposure really saying? Don't just track whether inventory is staying on the lot longer. Track whether that's bleeding into your cash flow forecast. The gap between when you pay out a vehicle's floor plan balance and when you actually deliver it is where dealerships get stuck. A 48-day turn with a 15-day delivery delay is a 63-day cash conversion cycle. Your forecast needs to reflect that.

This takes 45 minutes now instead of 20. But the output is a forecast that actually predicts what's going to happen, not what you hope will happen.

What Hasn't Changed: Discipline and Honesty

The most important thing about a rolling 13-month forecast has nothing to do with the mechanics. It has to do with ownership.

A forecast is only useful if the general manager, controller, and finance director actually believe in it and use it to make decisions. If it's a checkbox exercise because the dealer group requires it, it's worthless. If numbers get massaged to make a bonus target look achievable, it's worse than worthless—it's misleading.

The dealerships that do this well treat the forecast like a living document, not a report. They argue about assumptions. They adjust when reality disagrees. They protect the integrity of the numbers because those numbers drive hiring decisions, capital allocation, and floor plan strategies.

That discipline has never been more important than it is right now. Because the margin for error has gotten smaller, the variables have gotten noisier, and the cost of a bad forecast has gotten steeper.

The Practical Next Step

If you're running a 13-month rolling forecast on a spreadsheet and updating it by manually hunting down data from five different systems, you already know it's friction-heavy. You're also leaving accuracy on the table.

The dealerships that've tightened forecast accuracy recently have done one thing: they've connected their forecast directly to operational data. Days to front-line comes from actual reconditioning status, not a guess. Cash flow timing comes from floor plan data and delivery schedules, not an assumption. Trade-in pipeline comes from live CRM data, not last month's trend.

That doesn't require a complete system overhaul. But it does require treating your 13-month forecast as a tool that drives decisions, not just a report that documents them. And it requires the discipline to update it honestly, every month, even when the numbers disagree with what you want to believe.

The structure of the 13-month rolling forecast still makes sense. It's the commitment to keeping it accurate that separates dealerships managing cash flow from dealerships that get surprised by it.