Cargo Van Cost-Per-Mile & Load Profit Calculator: guide

Know your real cost per mile and whether a load is worth it. A 7-tab Excel / Google Sheets workbook built for cargo and Sprinter vans.

Who it's for

Cargo van and Sprinter owner-operators, new courier businesses, and anyone pricing loads off a load board.

What's inside

  • 7-tab .xlsx: Instructions, Fixed Costs, Variable Costs, Cost Per Mile, Load Calculator, Load Log, Monthly Summary
  • 3-offer GO / NEGOTIATE / NO-GO comparison with deadhead and profit per hour
  • 200-row load log with monthly totals and a revenue vs. costs chart
  • 4-page quick-start PDF; example data clearly labeled

How to use it

  1. Open in Excel, or upload to Google Drive and choose File → Save as Google Sheets.
  2. Fixed Costs tab: list every bill and its frequency; enter planned miles per month.
  3. Variable Costs tab: enter your real MPG, fuel price, service, tire and supply costs.
  4. Cost Per Mile tab: set a target profit per mile and per hour to get your target rate.
  5. Load Calculator: enter each offer's rate, loaded and deadhead miles, tolls and hours.

FAQ

Does it work in Google Sheets?

Yes. No macros, add-ons or scripts are used.

Is there a free version?

Yes. The free web calculator uses the same formulas for one load at a time.

Does it promise profit?

No. It's a planning tool; results depend on the numbers you enter.

Planning tool only. Example data is labeled; replace it with your own. No earnings promised. Digital download; nothing is shipped. Educational templates, not legal, medical or compliance advice. Created with help from AI tools and reviewed by the owner.

Get a quoteTrack