Trucking Pro Forma Template

Start with the Assumptions sheet and configure the model for your operation. Enter your truck count, equipment type, average loaded miles per truck per week, and rate per mile — if you're on spot market, use a conservative rate based on your recent average; if you run dedicated lanes, use your contract rate. Set your empty mile percentage (typically 10–20% for well-managed routes), your fuel cost per gallon, and your miles per gallon. Enter driver pay structure — cents per mile or percentage of linehaul — and set the loaded employer cost percentage (usually 18–22% on top of driver wages for taxes, workers' comp, and benefits). If you have equipment payments, enter the monthly payment and remaining term. The entire model updates from this one sheet.

Move to the Revenue Projections sheet and review the monthly numbers. Check that the seasonal adjustments look right for your lanes — some carriers run counter-cyclically to the general freight market depending on what they haul. Then review the Driver & Equipment Costs and Fuel sheets to confirm the per-mile cost buildup looks realistic. Your total cost per loaded mile should be somewhere between $1.40 and $2.20 for most over-the-road dry van operations, though refrigerated, flatbed, and specialized freight often run higher. If your cost per mile looks wrong, trace it back to the Assumptions sheet and adjust. It's common for the first pass to surface a compensation rate or fuel efficiency number that was entered incorrectly.

Before sharing this with any lender or equipment financier, review the Cash Flow Forecast carefully. If you factor your receivables, toggle the factoring switch on and enter your factor rate — this will change your effective revenue per mile but dramatically improve cash timing. If you're borrowing to buy a second or third truck, the cash flow sheet will show you whether the new truck's contribution is enough to service the loan from day one or whether you need a ramp period with additional working capital. Once the numbers make sense, use the Summary Dashboard for any external presentation. The operating ratio, cost per mile, and revenue per mile numbers are the metrics every trucking lender looks at first.

Trucking is one of the few industries where you can be busy all year and still lose money — because the margin between revenue per mile and cost per mile is thin enough that a 10% swing in fuel prices or a 5% increase in driver pay can wipe out net income entirely. Owner-operators and small fleet owners who run the business on feel rather than a monthly financial model often find out too late that a combination of rising diesel prices, a soft freight market, and an unexpected truck repair has pushed their operating ratio above 100 — meaning they're spending more than they're earning. A trucking pro forma builds the math explicitly before that happens, so you know what rate per mile you need to be profitable at current fuel and driver costs, and what your break-even load factor is for each truck.

The key financial relationships in trucking are all per-mile. Revenue per mile (RPM) is your gross revenue divided by total miles including deadhead; cost per mile (CPM) is your total operating expenses divided by the same total miles. The gap between them — your net per mile — is the real measure of profitability. Most well-run owner-operators achieve $0.15–$0.40 net per mile after all costs including owner salary; small fleets with 5–20 trucks typically see net margins of 4–8% when properly managed. The Operating Ratio (total expenses / total revenue) is the industry's standard health metric: below 90% is healthy, 90–95% is acceptable but tight, and above 95% is a warning sign that the business is close to breakeven. A pro forma makes these ratios visible month by month for three years, which is exactly what commercial lenders and equipment financing companies need to approve a loan.

The most common reason trucking companies hit a cash crisis isn't a bad P&L — it's receivables timing. A broker pays net-30. A direct shipper pays net-45. Your driver payroll runs every two weeks. Your equipment loan pays on the first of the month. When you're growing — adding trucks, hiring drivers, taking on more freight — the gap between when you do the work and when you collect the money widens fast. Invoice factoring solves this by advancing you 90–97% of the invoice face value immediately in exchange for a fee, typically 2–5% of the invoice value. Whether to factor is a real business decision that the cash flow model helps you make quantitatively: if growth requires cash that receivables timing doesn't provide, factoring at 3% is often cheaper than the opportunity cost of turning down freight. The pro forma shows you the math clearly either way.