Dealership Cash Flow Forecast: A 13-Week Guide for Used Lots

A dealership cash flow forecast is a week-by-week estimate of the money that will land in your bank account and the money that will leave it, so you can see a shortfall before it arrives. For an independent used-car lot, the most practical version covers 13 weeks, starts from your real bank balance, and is updated every week. Below is what to include, how to build it, a worked example, and how to stress-test it.

TL;DR

• Profit is not cash. A car can show a healthy gross on the deal jacket while the money sits in a lender’s pipeline for days or weeks.
• Forecast 13 weeks out, by week, starting from your actual bank balance. Add inflows, then outflows: inventory buys, recon, payroll, floorplan interest, rent, taxes.
• Model three cases (expected, best, worst) and set a minimum cash balance that triggers action.
• The forecast is only as good as your per-car costs. If recon, transport and fees are scattered, the numbers will be guesses.
• Compare the forecast to actuals every week and fix the assumption that missed.

Table of Contents

• Why profit and cash tell different stories on a lot
• What goes into a dealership cash flow forecast
• How to build the forecast in seven steps
• A worked example: one lot, four weeks
• Floorplan timing and the cost of aged units
• Stress-test with three scenarios
• How often to update it, and what to watch
• Perspective: the forecast breaks when the per-car numbers are wrong
• Put the forecast on top of live per-car costs
• FAQ
• Sources

Why profit and cash tell different stories on a lot

The FDIC’s small-business training material describes a cash-flow projection as a forward-looking estimate of cash inflows and outflows that shows your future cash position. A profit-and-loss statement does something else: it reports revenues and expenses over a set period, and profit is what remains after costs, expenses and taxes come off sales revenue.

The gap matters most for businesses that sell on credit or carry physical inventory. The SBA warns that credit sales appear on a P&L but are not money in the bank, while inventory spending uses cash without showing up as an expense. A used-car lot is both at once.

Here is how that plays out in a normal month:

• You buy six cars at auction on Monday. Cash leaves immediately. None of it shows as an expense until each car sells.
• You sell a car on Friday with a financed deal. The revenue is booked that day, but the lender’s funding can take days to arrive.
• Recon, transport and detail invoices are paid before the car is frontline ready, long before it sells.
• Floorplan interest accrues every day a car sits, whether or not it sells.

A lot can be profitable on paper and still miss payroll. That is the problem a cash forecast solves. If you want a plain-language walkthrough of why lenders and owners both care about the distinction, this explainer on cash flow versus profit covers it well.

As one CPA firm puts it, because revenue is recorded at the sale but cash often arrives later through financing or incentive clearing, planning has to follow the timing of cash, not accounting profit.

What goes into a dealership cash flow forecast

The FDIC template separates cash into operating, investing and financing activity, and it lists customer receipts, inventory purchases, operating expenses, salaries, interest, taxes, equipment purchases and borrowing, ending with the change in cash and the ending balance. For a used lot, that translates into the lines below.

Two lines deserve extra attention. The first is inventory. A CPA writing in Auto Dealer Today argues that inventory is a cash-management issue and that a car’s cost should include the purchase price plus reconditioning, transportation and cleanup. If your forecast carries only the purchase price, every car will look cheaper to hold than it is.

The second is floorplan. In the U.S., floor plan lending is a line of credit secured by vehicle inventory and its VIN. Interest is a continuing cost on every unit, so aged cars drain cash even when nothing else changes.

How to build the forecast in seven steps

You can do this in a spreadsheet. The FDIC layout (beginning cash, operating inflows, inventory purchases, expenses, wages, interest, taxes, investing, financing, change in cash, ending cash) maps directly onto columns for each week.

1. Start with the real bank balance. Use the cleared balance in every operating account today, not the books. Subtract outstanding checks and drafts you know are coming.
2. Pick a 13-week window. A 13-week model shows roughly a quarter of inflows and outflows in weekly detail, which is why auto-finance advisers call it a practical dealer tool for exposing short-term swings and shortfalls.
3. List the committed outflows first. Payroll, rent, floorplan interest, loan payments, insurance, tax deposits and known vendor bills. These are the least uncertain numbers, so they anchor the sheet.
4. Forecast unit sales by week. Use your last 90 days of retail and wholesale units, adjusted for season. Multiply by your average cash received per unit, separating cash deals from financed ones.
5. Apply funding lag to financed deals. Put the money in the week it arrives, not the week of the sale. Track your own average days from contract to funding by lender.
6. Plan inventory buys against the sales plan. If you plan to sell eight cars, decide how many replacements you will buy and when. Include buyer fees, transport and expected recon per car.
7. Calculate ending cash each week. Opening balance plus inflows minus outflows. The ending balance becomes next week’s opening balance. Mark every week where it dips below your minimum.

If you are seeking outside funding, expect to need more than a weekly model. Planning guides note that lenders typically want yearly and monthly cash flow forecasts in the financial plan. The 13-week view is for running the lot; the monthly and annual versions are for the bank.

A worked example: one lot, four weeks

These figures are illustrative, not benchmarks. Picture a small lot that opens the period with $60,000 in the bank and a minimum cash balance of $25,000.

Week 1 outflows include $34,000 of auction buys, $9,000 of payroll, $5,000 of rent and floorplan interest, and $4,000 of recon. Week 3 looks strong because two financed deals funded that week. Week 4 is the problem: $30,000 of new inventory, payroll, fixed costs and recon pull cash to $22,000, which is $3,000 under the minimum.

With the forecast in hand, you have options three weeks ahead of time. Delay one buy by a week, push a vendor payment to its due date, move a slow unit to wholesale, or line up credit. Without it, you find out on payday.

The weekly detail also shows something a P&L never would: the same lot can be profitable for the month and still touch its floor in week 4, because purchases come in a lump and sales proceeds arrive in a stream.

Floorplan timing and the cost of aged units

Floorplan is where a lot’s cash forecast usually goes wrong. NADA notes that because dealership inventory levels are large, the interest rate on floor plan is a critical cost factor, and a one percent increase can add millions of dollars in costs across a large dealership. An independent lot is far smaller, but the logic is the same: every point of rate applies to every financed unit.

For the forecast, model floorplan in three parts:

• Advances. When you buy a car on the line, cash does not leave your bank, but the debt rises. Track the balance owed separately from your bank balance.
• Interest and fees. Calculate by unit, using days on the lot. A car that sits 75 days costs far more in interest than one that sells in 25.
• Payoffs. When a car sells, the payoff goes to the lender before you keep the rest. If you forecast gross proceeds without netting the payoff, your cash will look better than it is.

If you run floorplan, two guides on our academy help with the mechanics: per-VIN floorplan utilization analysis for finding where interest is leaking, and a same-day floorplan payoff checklist for clearing liens quickly once a deal funds.

Stress-test with three scenarios

One forecast is a guess. Three are a plan. Advisers recommend best-case, worst-case and expected scenarios rather than one annual projection, with actual results compared to the forecast each month.

One CPA playbook suggests stress tests such as a 10% slowdown in sales velocity, a 50-basis-point rise in floorplan rates, and a spike in parts costs. Here is how a lot can apply that:

For the worst case, find the first week cash drops below your minimum, then write down the action you would take. A set trigger helps: one CPA firm suggests alerts when projected balances fall below a chosen threshold so that pre-planned contingency actions such as drawing on credit lines or delaying non-critical spending kick in. That firm’s example is $1 million, which fits a large store. Set yours to cover a few weeks of payroll, rent and floorplan interest.

Lenders think this way too. FDIC supervisory guidance says lenders mainly assess a small business’s ability to repay from current and expected cash flows, looking across a reasonable range of conditions rather than an overly optimistic or pessimistic case. A forecast with three scenarios is the document they want to see.

How often to update it, and what to watch

Update the 13-week forecast weekly. Replace last week’s estimates with actuals, roll the window forward one week, and note which assumption missed. Over a few months you learn your real funding lag, your real recon spend and your real sales pace, and the forecast gets tighter.

Two checks make the weekly review quick:

• Variance. Compare forecast and actual for each line. The SBA recommends variance analysis because inventory spending, debt repayment and asset purchases can use cash without appearing in the P&L.
• Cash days’ supply. NADA’s 2026 slide guide defines it as cash, contracts in transit, marketable securities and vehicle receivables, divided by average monthly dealership expenses plus technicians’ labor, multiplied by 30. NADA’s guide figure is 90 days. That formula is built for franchised stores with service departments, so a lot should adapt it: use your own monthly operating expenses and see how many days your liquid cash and funding in transit would cover.

Also watch inventory against sales. The Auto Dealer Today article recommends comparing inventory investment with average monthly cost of sales to judge months of supply and turns. When supply creeps up, cash is being parked on the lot, and the forecast should show it.

Perspective: the forecast breaks when the per-car numbers are wrong

We built Loturn for independent used-vehicle dealers, and the most common reason we see a cash forecast fail is not the spreadsheet. It is that the costs behind each car are scattered. The purchase price is in one place, the transport bill in an email, the recon invoices in a stack, and the floorplan interest on a lender statement. When the forecast asks what a car will cost to get to frontline, nobody can answer with confidence.

So we start one level below the forecast. Every cost belongs to a VIN: purchase price, transport, recon, fees, floorplan interest. Once those are captured as they happen, you can see true profit per car before it sells, and you can see how much cash is tied up in each unit that has not sold yet. That makes the forecast an exercise in reading numbers you already trust, not guessing at them.

Our advice to a dealer who has never forecast cash: do not wait for perfect books. Build the simple 13-week sheet this week using your bank balance and your known bills. Then fix the data feeding it, one cost at a time, starting with recon and floorplan interest, because those are the lines most dealers underestimate.

— Eric Dosset

Put the forecast on top of live per-car costs

A forecast is easiest to keep current when costs are recorded against each vehicle as they occur. Loturn combines inventory, native double-entry accounting with an automotive chart of accounts, recon and transport cost assignment, floorplan interest tracking and reporting in one platform, with every tool included in one flat monthly price. Plans are Flipper at $99 per month, Dealer at $349 per month and Multi-Lot at $699 per month, and we help import your existing data for free. See the plans and pricing to find the fit for your lot.

If recon spend is where your cash leaks, our guide to recon WIP accounting per VIN shows how to catch overruns before the car is done.

FAQ

How do you forecast cash flow for a car dealership?

Start with your current bank balance, then list cash coming in (retail, wholesale, funded finance deals, back-end income) and cash going out (inventory, recon, payroll, floorplan interest, rent, taxes) for each week. Calculate ending cash weekly and carry it forward. A 13-week window updated weekly works well for most independent lots.

Can I use a free Excel template for a simple dealership cash flow forecast?

Yes. The FDIC’s Module 10 layout (beginning cash, inflows, inventory purchases, expenses, wages, interest, taxes, investing, financing, change in cash, ending cash) can be rebuilt in Excel or Google Sheets with a column per week. Add rows for floorplan payoffs and funding lag, since those are specific to dealers.

Do dealerships like cash deals?

Often yes, because cash arrives on the day of sale, with no funding lag. But a cash buyer is not always a better deal if the gross is lower, so judge it by the cash it brings in and what that car cost you per day to hold, not by payment type alone.

Can ChatGPT create a cash flow forecast for my lot?

It can draft a layout and explain the lines, but it knows nothing about your bank balance, funding lag or recon spend. Use it to structure the sheet, then fill it with your own numbers and check every formula yourself.

Sources

• FDIC Module 10: Managing Cash Flows, Participant Guide
• FDIC Module 8: Profitability, Participant Guide
• SBA: 5 Classic Fails in Budgets and Forecasts
• Larsco CPA: Cash Flow Planning for Dealerships
• Auto Dealer Today: Inventory Management Is Really Cash Management
• NADA: Dealerships 101, What Is Auto Floor Plan Lending?
• LHPH: What Is the Best Way for a Dealer to Forecast Cash Flow?
• The Business Plan Shop: How to Create a Car Dealership Financial Forecast
• NCM Associates: Budgeting and Forecasting in the Auto Industry
• Baldwin CPAs: Auto Dealership Cash Flow
• FDIC FIL-90-2010 Attachment
• NADA Slide Guide: Definitions

Recommended

• Wholesale Deal Accounting for Used Car Dealers
• Floorplan Cash Flow: How Dealers Keep the Line From Draining Cash
• Inventory Write-Downs for Used Car Dealers: A Practical Guide
• Stop Gross Surprises: Deal Posting Checklist for Used Car Dealers