Floor Plan Cost Per Day: A Simple Holding Cost Worksheet

Ask a general manager what a sitting used car costs per day and you will usually get a shrug, a joke about "too much," or a round number that has not been updated since the last rate change. The floor-plan statement arrives monthly. Recon invoices arrive whenever they arrive. Depreciation is felt at the next appraisal meeting. None of that is a daily number the used-car desk can use when it decides to keep a unit another week, to cut price, or to pack it out. Floor plan cost per day is that number, and a simple holding cost worksheet is how you get it without a controller project.

The sharp problem is not that interest exists. Everyone knows it exists. The problem is that idle days after the car is front-line ready still get treated as "marketing time," as if they were free. They are not. Every unlisted day and every aged day is a line on the same worksheet. Once the desk can see it per unit, recon delays, photo delays, and "we will post it Monday" become cost decisions instead of habits.

This article is for dealer principals, general managers, and used-car managers who already live with a floor-plan line and an aged report. It shows how to build a per-unit daily holding cost, how to use it on live inventory, and how to avoid fake precision. Use your own rates and books. Do not import someone else’s "average holding cost."

What Floor Plan Cost Per Day Should Include

Floor plan interest is the headline. It is not the whole story. If you only count interest, you will underprice the cost of delay and over-keep aged units.

Four buckets on the worksheet

1. Floor plan interest. Your actual plan rate applied to that unit’s funded amount (or average funded amount if you do not allocate perfectly).
2. Economic depreciation. The expected drop in wholesale or retail support as the unit ages. You will not know this to the dollar. Use a conservative daily estimate from your own solds vs. days in stock, or skip it until you have data rather than inventing a national curve.
3. Allocated lot overhead. Insurance, lot rent or occupancy, and a share of utilities that you already put against used. Divide a monthly used-overhead figure by unit-days in the month.
4. Recon and idle labor that is caused by delay. Not the original recon ticket — that belongs to the buy. The extra moves, re-details, and battery charges that happen because the car sat.

Sum the buckets you can defend. Label estimates as estimates. The goal is a number you will actually use, not a thesis.

Separate original recon from holding cost

Original recon is part of landed cost. Holding cost starts when you own the car and continues until it funds out. If you dump recon into daily holding cost, you will think a three-day unit is "expensive per day" because the shop ticket hit this week. Keep recon on the buy. Keep delay on the worksheet.

Illustrative structure

Consider a lot with 60 units. You take your monthly floor-plan interest from the statement, divide by the number of unit-days those cars were on plan, and get an interest-per-unit-day figure. You add a modest overhead-per-unit-day from used occupancy. You optionally add a depreciation-per-day you derived from your own aged markdowns. That sum is H. Then any VIN that sits D days costs about H × D plus any extra re-detail. The arithmetic is the point. The dollars are yours to fill in.

Build a Simple Holding Cost Worksheet

Keep it on one tab. If it needs a data warehouse, it will not get opened.

Unit-level columns

You do not need to match the lender’s interest formula to the penny for this to change behavior. You need to be directionally honest and consistent month to month. Confirm the actual interest method with your lender or controller before you use the number in a lender conversation. This worksheet is an operating tool.

Lot-level summary

Above the unit rows, show:

• Total units on plan
• Total unit-days this month
• Total interest paid
• Implied interest per unit-day
• Count of units over your aged line and their combined holding so far

That summary is what belongs in a Monday used meeting next to the aged list. Pair it with days-to-turn and online exposure: holding cost is the price of each unexposed or unsold day.

Cash units still have a holding cost

If some inventory is cash, interest may be zero, but depreciation, overhead, and opportunity cost of the cash are not. Put cash units on the same sheet with interest at zero and a note. Do not pretend they are free. The funding choice itself is a separate decision; see cash vs floor plan: thinking through how to fund inventory.

What to leave off so the sheet stays honest

• Backend gross you hope to make (not a cost offset until it funds).
• "Free" employee labor that is not free.
• A national depreciation percentage you read somewhere.
• Pack, which is a buy policy, not a daily cost.

Use Cost Per Day to Make Three Decisions

A worksheet that does not change a decision is a report. Use H on live calls.

1. How long can this unit sit before the buy is gone

For each new retail-bound VIN, compute days until estimated remaining gross is eaten by H × days. That is not a prophecy. It is a tripwire. When a unit crosses halfway to that tripwire with no appointments, it needs a price, photo, or wholesale conversation — not another week of hope. This is also when planning for floor plan curtailments should already be on the calendar for aging units, not a surprise invoice.

2. What an extra recon day is worth

If the shop wants another three days for a cosmetic item that will not change the list price, the cost is about 3H plus stall time taken from a car that would actually sell. Sometimes the cosmetic item still wins. Now it has to win against a number. Combine this with a recon cap so you are not financing both extra work and extra days.

3. What an unlisted day costs

Front-line ready but not posted is the most indefensible holding. There is no market test, only cost. If your ready-to-posted gap is five days on 40 incoming units a month, that is 200 unit-days of H with zero chance of an inquiry. Fixing posting process is often cheaper than buying fewer cars. The worksheet makes that comparison visible.

A conservative operating rhythm

• Daily: used-car manager glances at units whose holding so far crossed an internal flag.
• Weekly: add holding-so-far to the aged discussion; decide cut, keep, or wholesale on the oldest high-H units.
• Monthly: rebuild H from the actual floor-plan statement so rate changes show up.

Pitfalls That Make Floor Plan Cost Per Day Useless

A worksheet that is wrong in a consistent way will still change behavior — in the wrong direction. Fix these before you brief the floor.

Bad bases and blended averages

• Using windshield price instead of funded amount as the interest base.
• Ignoring curtailments until they hit, then calling them "one-time."
• Averaging H across cheap cars and heavy trucks so a dually looks as cheap to hold as a compact.

Decisions that ignore the listing gap

• Cutting price by more than remaining holding just to "stop the interest" without checking whether a smaller cut plus better photos would do.
• Treating Marketplace silence as proof of no demand when the unit was never listed, or listed with bad data.

How PostToMarket Automates This

The worksheet lives in your books. The days you can actually steal back are the days between ready and listed, and the days a sold car keeps occupying a plan because nobody marked it sold. PostToMarket does not calculate interest and does not talk to your lender. It does shrink avoidable idle days on the retail side of holding cost.

Cut the ready-to-posted gap

• Capture from auction and wholesale sites so the VIN exists as a draft while transport is rolling.
• AI titles and descriptions from specs, editable before posting, so copy is not a two-day wait.
• Facebook photo picker and per-rep queues so a ready unit has an owner the same day.
• Mobile dashboard to reorder the queue when high-H units should go first.

Stop paying for cars that already sold

• Mark as sold and archive from inventory or the queue the day the deal funds.
• Statuses (draft, posting, posted, sold, failed) so the desk can see what is actually live.
• Team queue view to release a stuck claim on a unit that should already be gone.

Make aged exposure a managed queue, not a hope

• Manager assignment of aged units to associates for fresh photos or a relist after a price move, without duplicate chaos.
• Team analytics by rep and source so you can see whether high-H units are even being worked online.
• Server-enforced daily post limits and human-like delays so catching up on aged units does not become a burst. PostToMarket is not affiliated with Meta, and no tool can guarantee reach.

Holding cost still depends on your rate, your mix, and your recon. What you can stop doing is funding silence.

Put a Daily Number on Every Sitting Car

Floor plan cost per day becomes useful when it is a worksheet, not a complaint. Add interest, allocated overhead, and only the depreciation you can defend from your own file. Use the number to tripwire aged units, to price extra recon days, and to treat unlisted days as the most expensive idle time you have. Rebuild it when the statement changes.

PostToMarket attacks the idle days that are process, not rate: capture, draft, unique copy, owned queues, paced posting, and same-day sold hygiene. Starter is $59 per month for a solo seller or independent lot with one login. Dealership is $299 per month for up to 13 team logins.

Start your 10-day free trial through secure Stripe checkout. Get high-holding-cost units into a real queue this week, and cancel anytime.