# Freight Trucking

Translate a three-class trucking fleet (light, medium, heavy) plus a 12-month additions plan and per-mile economics into a per-class fleet schedule, revenue and cost decomposition, a 12-month income statement through EBITDA and net income, and a dashboard with revenue per mile, cost per mile, operating ratio, EBITDA margin, fuel intensity, and a per-class composition block.

- Canonical: https://finamodel.com/templates/freight-trucking
- Excel download: https://finamodel.com/templates/freight-trucking.xlsx
- Category: Operating Businesses
- Model type: Operating model
- Difficulty: Intermediate
- Audiences: CFOs & FP&A, Founders & operators, Fleet operators, CFOs, Logistics investors, FP&A teams
- Tags: trucking, logistics, fleet operations, revenue per mile, operating ratio

## Overview

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's included

- 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
- Three truck classes (light, medium, heavy) with per-class inputs: opening trucks, annual miles, revenue per mile, driver pay per mile, maintenance per mile, MPG, insurance per truck per month
- 12-month fleet-additions plan by class plus operating inputs: fuel price, utilisation, corporate G&A, depreciation per truck, other fixed per truck, tax rate
- Fleet sheet with per-class active trucks (opening + cumulative additions) and productive miles (active trucks × annual miles / 12 × utilisation)
- 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
- 12-month P&L through revenue, variable opex, contribution margin, fixed opex, EBITDA, depreciation, EBIT, tax, net income with margin rows and an annual column
- Dashboard with annual revenue, EBITDA, net income, EBIT, M12 trucks, total miles, revenue per mile, cost per mile, fuel and driver-pay intensity, peak month, and EBITDA margin / operating ratio status flags
- Per-class composition block with M12 trucks, annual revenue, and annual miles

## 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.

## Built for the rate cycle

Revenue per mile and cost per mile move together with the trucking rate cycle, so margins are usually expressed inversely as operating ratio. Flex the per-mile inputs and watch the operating ratio status flag update across the horizon.

## Variable per mile, fixed per truck

Driver pay, fuel, and maintenance scale with productive miles; insurance, other fixed, and depreciation scale with the active fleet count. Splitting opex this way is what makes contribution margin and operating ratio interpretable.

## Audit-friendly mechanics

Every driver is on the Assumptions sheet, every cross-sheet ref is row-locked, and the fleet roll-forward uses an OFFSET width that adapts to the horizon without rewiring formulas.

## Built for the rate cycle

Revenue per mile and cost per mile move together with the trucking rate cycle, so margins are usually expressed inversely as operating ratio. Flex the per-mile inputs and watch the operating ratio status flag update across the horizon.

## Variable per mile, fixed per truck

Driver pay, fuel, and maintenance scale with productive miles; insurance, other fixed, and depreciation scale with the active fleet count. Splitting opex this way is what makes contribution margin and operating ratio interpretable.

## Audit-friendly mechanics

Every driver is on the Assumptions sheet, every cross-sheet ref is row-locked, and the fleet roll-forward uses an OFFSET width that adapts to the horizon without rewiring formulas.

## Workbook structure

### Cover

Workbook overview, sheet legend, and tab-colour key.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: per-class fleet inputs, monthly additions plan, operating drivers, status thresholds.

- Three truck classes with opening trucks, annual miles, revenue / mile, driver pay / mile, maintenance / mile, MPG, insurance
- 12-month fleet additions per class (whole trucks)
- Operating inputs: fuel price, utilisation, corporate G&A, depreciation per truck, other fixed per truck, tax rate
- Status thresholds for operating ratio (on-track / watch) and EBITDA margin (on-track / watch)

### Fleet

Per-class active trucks and productive miles by month with panel totals.

- Active trucks = opening + cumulative additions through month t
- Productive miles = active trucks × annual miles / 12 × utilisation
- Per-class rows and total rows for trucks and miles

### Revenue

Per-class monthly revenue with blended dollars-per-mile.

- Revenue per class = miles × revenue per mile
- Panel total revenue by month
- Blended dollars-per-mile = total revenue / total miles

### Operating Costs

Variable and fixed cost decomposition by class and month.

- Driver pay = miles × driver pay per mile (per class, totalled)
- Fuel = miles / MPG × fuel price (per class, totalled)
- Maintenance = miles × maint per mile (per class, totalled)
- Insurance = trucks × insurance per truck (per class, totalled)
- Other fixed = trucks × other fixed per truck (per class, totalled)
- Variable opex, fleet fixed opex, corporate G&A, depreciation, and total opex

### P&L

12-month income statement plus an annual column.

- Revenue, variable opex detail (driver, fuel, maintenance), and variable opex subtotal
- Contribution margin with CM %
- Fixed opex detail (insurance, other, corp G&A) and fixed opex subtotal
- EBITDA with EBITDA margin
- Depreciation, EBIT, tax (MAX of EBIT and zero × rate), net income with net margin
- Operating ratio per month and on the annual column

### Dashboard

Headline KPIs and traffic-light status with a per-class composition block.

- Annual revenue, EBITDA, net income, EBIT
- M12 active trucks and total annual miles
- Revenue per mile, cost per mile, fuel and driver-pay intensity
- Peak monthly EBITDA and the month it occurs
- EBITDA margin and operating ratio with on-track / watch / heavy status
- Per-class composition: M12 trucks, annual revenue, annual miles

### Cover

Workbook overview, sheet legend, and tab-colour key.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: per-class fleet inputs, monthly additions plan, operating drivers, status thresholds.

- Three truck classes with opening trucks, annual miles, revenue / mile, driver pay / mile, maintenance / mile, MPG, insurance
- 12-month fleet additions per class (whole trucks)
- Operating inputs: fuel price, utilisation, corporate G&A, depreciation per truck, other fixed per truck, tax rate
- Status thresholds for operating ratio (on-track / watch) and EBITDA margin (on-track / watch)

### Fleet

Per-class active trucks and productive miles by month with panel totals.

- Active trucks = opening + cumulative additions through month t
- Productive miles = active trucks × annual miles / 12 × utilisation
- Per-class rows and total rows for trucks and miles

### Revenue

Per-class monthly revenue with blended dollars-per-mile.

- Revenue per class = miles × revenue per mile
- Panel total revenue by month
- Blended dollars-per-mile = total revenue / total miles

### Operating Costs

Variable and fixed cost decomposition by class and month.

- Driver pay = miles × driver pay per mile (per class, totalled)
- Fuel = miles / MPG × fuel price (per class, totalled)
- Maintenance = miles × maint per mile (per class, totalled)
- Insurance = trucks × insurance per truck (per class, totalled)
- Other fixed = trucks × other fixed per truck (per class, totalled)
- Variable opex, fleet fixed opex, corporate G&A, depreciation, and total opex

### P&L

12-month income statement plus an annual column.

- Revenue, variable opex detail (driver, fuel, maintenance), and variable opex subtotal
- Contribution margin with CM %
- Fixed opex detail (insurance, other, corp G&A) and fixed opex subtotal
- EBITDA with EBITDA margin
- Depreciation, EBIT, tax (MAX of EBIT and zero × rate), net income with net margin
- Operating ratio per month and on the annual column

### Dashboard

Headline KPIs and traffic-light status with a per-class composition block.

- Annual revenue, EBITDA, net income, EBIT
- M12 active trucks and total annual miles
- Revenue per mile, cost per mile, fuel and driver-pay intensity
- Peak monthly EBITDA and the month it occurs
- EBITDA margin and operating ratio with on-track / watch / heavy status
- Per-class composition: M12 trucks, annual revenue, annual miles

## Features

- **Per-class mile-based economics:** Every variable cost line is driven by productive miles per class through the per-mile rate on Assumptions. Flexing driver pay rate, fuel price, MPG, or maintenance rate flows straight to opex, EBITDA, operating ratio, and the dashboard status flags.
- **Fleet additions roll-forward:** Active trucks at month t = opening fleet + cumulative monthly additions through t. Implemented with OFFSET so the formula adapts cleanly to longer horizons and the fleet count, productive miles, fixed costs, and depreciation all stay tied together.
- **Operating ratio and EBITDA margin status:** Two user-set thresholds per metric drive on-track / watch / heavy resolution on the dashboard. Operating ratio is total opex (variable + fixed + depreciation) divided by revenue - the headline efficiency metric the trucking industry actually uses.

## Use cases

- **Fleet operator P&L planning:** Size the variable and fixed cost stack against the rate environment to confirm whether the current fleet mix clears an operating ratio threshold and an EBITDA margin floor. Flex driver pay or fuel price and watch the dashboard status flags update.
- **Trucking acquisition diligence:** Underwrite a for-hire carrier or LTL business by importing the target's revenue per mile by class, driver pay structure, MPG, and fleet age. The dashboard shows whether the headline numbers reconcile to a credible operating ratio.
- **Capacity expansion modelling:** Stress-test a fleet build-out by flexing the monthly additions plan per class. The model recomputes utilisation-adjusted miles, revenue, variable opex, fixed cost scaling, depreciation, and EBITDA flow-through across the 12-month horizon.

## Frequently asked questions

### 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.

## Related templates

- [Shipping Company Operating Model](https://finamodel.com/templates/shipping-model)
- [3 Statement Model](https://finamodel.com/templates/3-statement-model)
- [Depreciation](https://finamodel.com/templates/depreciation)