Freight Trucking
Operating Businesses Financial Model (Free Excel Download)
Plan trucking profitability using loads, miles, rates, fuel, driver utilization, maintenance, fleet purchases, working capital, and route-level contribution margins.
professionals from Deloitte
Used by professionals from
About this model
A freight-trucking operating model projects a 12-month fleet P&L for a for-hire carrier built around the canonical revenue-per-mile and cost-per-mile economics that drive the industry. The workbook organises three vehicle classes (light duty, medium duty, heavy duty) into a single Assumptions sheet with one row per class holding opening trucks, annual miles per truck, revenue per mile, driver pay per mile, maintenance per mile, MPG, and insurance per truck per month, plus a 12-month fleet-additions plan per class, a block of operating inputs (fuel price, utilisation, corporate G&A, depreciation per truck per month, other fixed per truck per month, effective tax rate), and a status-threshold block with two pairs of thresholds (operating ratio on-track / watch, EBITDA margin on-track / watch).
The Fleet sheet computes per-class active trucks as opening + cumulative monthly additions (using an OFFSET width that adapts to the horizon) and productive miles as active trucks × annual miles / 12 × utilisation. The Revenue sheet multiplies miles by revenue per mile to derive per-class monthly revenue, sums to a panel total, and computes a blended dollars-per-mile row. The Operating Costs sheet decomposes opex into per-class variable lines (driver pay, fuel, maintenance), per-class fixed lines (insurance, other fixed), and panel fixed lines (corporate G&A, depreciation), each with class and panel subtotals. The P&L pulls the cost lines into a 12-month income statement: revenue, variable opex detail, variable opex subtotal, contribution margin with CM %, fixed cost detail (insurance, other, corp G&A), fixed opex subtotal, EBITDA with EBITDA margin, depreciation, EBIT, tax (MAX of EBIT and zero × rate), net income with net margin, and operating ratio.
The Dashboard reads annual revenue, EBITDA, net income, EBIT, M12 active trucks, total annual miles, revenue per mile, cost per mile, fuel intensity, driver-pay intensity, peak monthly EBITDA and the month it occurs, with traffic-light status on EBITDA margin and operating ratio against the user-set thresholds, plus a per-class composition block (M12 trucks, annual revenue, annual miles) and panel totals. Fleet operators, logistics investors, and FP&A teams use this template for capacity planning (size the fleet against a target operating ratio), acquisition diligence (import a target carrier's per-class rates and check whether the headline numbers reconcile), and rate-cycle stress testing (flex revenue per mile, driver pay, fuel price, or utilisation and watch the operating-ratio status flag update across the horizon).
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Freight Trucking
- Three truck classes (light, medium, heavy) with opening trucks, annual miles, revenue per mile, driver pay, maintenance, MPG, and insurance per truck per month
- 12-month fleet-additions plan per class plus operating inputs: fuel price, utilisation, corporate G&A, depreciation per truck, other fixed per truck, tax rate
- Per-class active trucks (opening + cumulative additions) and productive miles by month
- Revenue by class with blended dollars-per-mile, and cost decomposition by line
- 12-month P&L through revenue, variable opex, contribution margin, fixed opex, EBITDA, depreciation, EBIT, tax, net income, and operating ratio
- Dashboard with annual KPIs, fuel and driver-pay intensity, peak month, per-class composition, and traffic-light status against user thresholds
- Revenue sheet with per-class monthly revenue, panel total, and a blended dollars-per-mile row
- Operating Costs with driver pay, fuel, maintenance, insurance, other fixed by class, plus corporate G&A and depreciation lines
Freight Trucking Model: Fleet Economics and Financial Flow
This freight trucking model is a CFO-grade operating template for a mixed-fleet North American carrier. It translates fleet composition, financing, fuel exposure and freight-market conditions into a five-year operating ratio, EBITDA margin, leverage and cash trajectory.
Year one is monthly; later years are annual, with Bull, Base and Bear scenarios set by a single toggle.
Operating drivers behind the model
The model is built around a three-class fleet: light, medium and heavy duty. Each class carries its own opening count, annual miles, contract and spot revenue per mile, spot mix, deadhead percentage, utilisation and fuel economy.
- Driver pay is modelled as a full stack, combining cents per mile, per-diem, retention bonus, sign-on amortisation and a benefits load. Fuel, tires, IFTA tax, tolls and age-graded maintenance sit on the variable side, while insurance, safety reserve, other fixed costs, recruiting and corporate G&A form the fixed block.
- A scenario toggle selects eight sector-sensitive inputs, so the same structure can reflect a tight or soft freight market.
How revenue and costs are calculated
Line-haul revenue starts with loaded miles, which are total miles reduced by the deadhead adjustment, and blends contract and spot rates according to the spot mix. Spot rates carry a scenario haircut, and the blended rate grows each year.
- Fuel surcharge revenue converts fuel-price inflation above a base price into incremental revenue, using a pass-through percentage that partially offsets fuel cost. Accessorial revenue is applied as a simple percentage of line-haul.
- Cost calculations use total miles for per-mile lines and truck counts for per-truck lines. Depreciation is straight-line per class, and interest is based on a blended equipment-loan facility.
Outputs and financial statements
The model produces a monthly P&L for year one, annual P&L columns for years two to five, and an annual P&L sheet for board reporting. A cash-flow statement reconciles net income, depreciation and working-capital movements, with separate investing and financing sections.
- Working capital covers receivables, payables, accrued wages and accrued taxes. The dashboard presents revenue per mile, cost per mile, operating ratio, EBITDA margin, fuel intensity and a per-class composition block.
- A checks sheet ties revenue and cost lines to the fleet and flags covenant and cash tests, while sensitivity grids show first-order elasticities for fuel, deadhead, driver pay and utilisation.
Practical use and scenario testing
In practice, the model helps an operator test how fleet additions, rate assumptions and fuel prices flow through to margin and leverage.
- The scenario toggle drives revenue growth, fuel price, driver wage growth, utilisation, deadhead, spot haircut, maintenance escalation and addition pace, so a user can move from Base to Bull or Bear without rebuilding the workbook.
- The sensitivity grids approximate the impact of fuel and deadhead on EBITDA margin, and driver pay and utilisation on operating ratio, around the year-one baseline.
- The checks sheet also documents where the model intentionally fails under Bear conditions, such as leverage and cash, highlighting areas a CFO would need to address.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a freight-trucking model?+
A freight-trucking model translates fleet size, miles, and per-mile economics into revenue, cost, and profitability. The standard inputs are revenue per mile, driver pay per mile, fuel cost (price divided by MPG), maintenance per mile, insurance per truck, and fixed overhead. The headline output is operating ratio: total opex divided by revenue, with 88-92% considered healthy in for-hire trucking.
Why are variable costs sized per mile rather than per truck?+
Because the marginal cost of driving an extra mile is driver pay, fuel, and maintenance - all of which scale with miles, not with the truck count. Fixed costs (insurance, depreciation, other) scale with the fleet count regardless of how much each truck is run. Splitting opex into variable (per-mile) and fixed (per-truck) is what makes the operating ratio and contribution margin interpretable.
How is utilisation applied?+
Utilisation is a single fleet-wide rate that scales gross capacity miles down to productive (revenue-generating) miles. Annual miles per truck is the theoretical capacity at 100% utilisation; the model applies the utilisation rate to derive billable miles. A carrier with 90% utilisation runs about 10% empty (deadhead) or idle relative to its capacity.
What is the operating ratio and why does it matter?+
Operating ratio (OR) is total opex (variable + fixed + depreciation) divided by revenue. It is the canonical efficiency metric for trucking carriers because revenue per mile and cost per mile fluctuate together with the rate cycle, so margins are usually expressed inversely. Public LTL and TL carriers report OR every quarter; sub-90% is strong, 90-94% is typical, above 94% is stressed.
Can I extend this beyond 12 months?+
Yes - the builder is parameterised by N_MONTHS and the fleet roll-forward uses OFFSET with a COLUMN()-based width so the formulas adapt to wider horizons. Bump N_MONTHS, regenerate, and every sheet picks up the longer range without rewiring.
Have more financial modelling questions? Contact us
Related templates
Shipping Company Operating Model
Operating model for shipping companies with vessel utilization, freight rates, bunker costs, and operational efficiency metrics.
3 Statement Model
Integrated income statement, balance sheet, and cash flow forecasts.
Depreciation
12-month fixed-asset register with capex schedule and straight-line depreciation across an asset panel.
Food Manufacturing Model
Operating model for food production and processing businesses with ingredient sourcing, production scheduling, and margin analysis.
