Log Truck Carrier Financial Model

Description

The model covers a for-hire log trucking operation that hauls roundwood from landings to mills. It supports various contracting modes—pay per ton, per loaded mile, or flat rate per load—and handles different wood forms (shortwood, longwood, tree-length) that affect loading times and payload capacity. Fleet composition can mix company-owned trucks with owner-operator units, each with its own cost and settlement structure.

Operational realities such as seasonal road bans, axle weight compliance, and load-to-empty fuel differentials are built in. The model simulates daily dispatch cycles, capturing turnaround times at loading and unloading, and allocates fuel, maintenance, and driver costs per trip. It generates a consolidated financial picture while preserving per-truck P&Ls, enabling analysis of fleet sizing and contract profitability.

Modeling specifics

• Payload engine uses bridge formula and axle ratings, wood density by species, and moisture content to compute legal load weight—gaps in payload assumptions can shift revenue by a significant margin.
• Seasonal road restriction calendar that automatically reduces available haul days per month, reflecting spring thaw closures and winter freeze periods, preventing overestimated annual capacity.
• Fuel module differentiates loaded, empty, and idle fuel burn rates and incorporates a fuel surcharge mechanism tied to an indexed diesel price, so margin compression from fuel spikes is immediately visible.
• Owner-operator vs. company driver P&L: each truck can be flagged as O/O with percentage-of-revenue settlements or as a company asset with fixed wages, benefits, and employer taxes.
• Maintenance reserve fund built on mileage-based cycles for tires, brakes, engine overhauls, and trailer wear, avoiding cash flow surprises from lump-sum overhauls.
• Rate schedule by customer/mill, supporting escalation clauses and tiered volume pricing, enabling realistic contract modeling across multiple wood buyers.
• Fleet growth module that allows phased acquisition of trucks and trailers, with corresponding driver hiring, financing, and depreciation starts, preserving correct timeline of cash flows.

What's included in the base version

• Revenue engine with configurable load parameters, rates, and dispatch frequency
• Direct cost engine (fuel, driver expense/owner-operator settlement, tires, R&M) per truck mile
• Fixed overhead budget (dispatch, safety, insurance, licenses, facility) with escalation
• Capital expenditure schedule for truck and trailer purchases with financing options
• Loan and lease amortization tables with flexible debt terms and drawdown periods
• Full set of financial statements: monthly P&L, cash flow, balance sheet over 5–10 years
• Per-truck and fleet-wide KPIs: utilization, cost per mile, EBITDA per truck, load count
• Scalable fleet module for up to 10 trucks with individual truck ID tracking
• Sensitivity tables for diesel price, utilization, rate per ton, and mileage
• Scenario selector (base, best, worst case) with adjustable drivers
• Depreciation schedules (straight-line and accelerated) compliant with tax options

Common modeling mistakes

• Ignoring seasonal road bans and load restrictions — annual haul capacity is overstated by 15–25%, leading to unrealistic revenue forecasts and fleet sizing.
• Using a single fuel consumption rate for all miles — fuel cost per ton-mile is underestimated by 10–20% because empty backhauls and idling during loading/unloading are overlooked.
• Treating all trucks as company-owned with driver wages — misrepresents owner-operator settlement costs, which can be 25–35% higher on a per-mile basis when revenue-sharing is used.
• Neglecting component replacement cycles (tires, brakes, engine rebuilds) based on mileage — maintenance expenses are understated by 15–20%, masking the capital required for ongoing fleet upkeep.
• Assuming constant haul distances and loading times — utilization rates are inflated by 10–15% because real-world variability in turnarounds and mill queues reduces productive hours per day.