Moving Company Model

Operating Businesses Financial Model (Free Excel Download)

Forecast moving-company performance through jobs, crew hours, truck utilization, pricing, fuel, labor, claims, seasonality, and branch-level operating cash flow.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model helps a moving company plan both local and long-distance jobs while managing a shared pool of crews and trucks. It shows how demand, pricing, capacity, subcontracting, and protection claims work together to shape performance.

Use it to test hiring, fleet investment, and the mix of local and long-distance work. The summary shows the resulting revenue, margin, cash flow, and value.

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 Moving Company Model

  • Crew inputs: crew count by year, new-crew productivity lag, hours per crew per day, operating days, utilization
  • Local move inputs: job demand and growth, hours per job, hourly crew rate and escalation
  • FVP and claims inputs: attach rate ramp, declared-value-per-pound rate, valuation premium rate, claim incidence, average claim severity, payout-lag split
  • Cost stack: crew wage rate, linehaul driver pay, fuel/maintenance per mile, packing materials, liability insurance, dispatch and corporate labor, marketing, G&A, admin
  • Capital and working capital: truck and facility capex, useful lives, AR/AP days, Year-0 seed methodology
  • Valuation: WACC, terminal growth, net debt, shares outstanding
  • Operations sheet: crew roll-forward, capacity split between in-house and brokered long-distance volume, FVP and claims-reserve roll-forward, working capital, capex and depreciation
  • Revenue sheet: local revenue, in-house and brokered long-distance revenue, FVP valuation-premium revenue, mix KPIs

Moving Company Financial Model: Local and Long-Distance Operations

This moving company financial model captures the operating dynamics of a regional household-goods mover running its own crews and trucks. It explores how two distinct service lines compete for a shared crew-hours pool, and how subcontracting, valuation coverage, and claims reserves feed into a seven-year cash flow and valuation view.

Rates and financial results described here reflect illustrative model settings, not industry benchmarks.

One Crew-Hours Pool, Two Pricing Engines

The model separates local and long-distance moves into two revenue engines that draw on the same finite crew-hours. Local jobs are priced as jobs multiplied by hours per job and an hourly crew rate.

  • Long-distance jobs use a weight-and-distance tariff, calculated as weight in hundreds of pounds times miles times a rate per hundredweight-mile. Local demand is always served first in-house.
  • Any remaining crew-hours cap how many long-distance jobs the company handles directly, with excess long-distance demand brokered to partner agents for a fee. That broker valve prevents turning away business, but brokered loads earn only a fraction of the equivalent in-house revenue, tying total revenue and margin directly to crew availability.

Full Value Protection and Claims Reserve Mechanics

On in-house long-distance jobs, the company sells Full Value Protection, a priced liability product. The model rolls a claims reserve forward by estimating claims incurred from FVP jobs, an incidence rate, declared value, and average severity, then paying those claims with a one-year lag.

  • The reserve grows as FVP attach rises, but remains modest in absolute terms. This liability is netted against working capital as a source of cash, reflecting money owed but not yet paid.
  • Brokered loads carry the partner agent's liability, so the FVP line only applies to in-house long-distance jobs.

Valuation premium revenue is also modeled as a separate line, growing with attach rate on in-house long-distance jobs. Together, these mechanics make the insurance-like side of moving explicit rather than treating it as deferred revenue.

Operating Assumptions and Cost Structure

Crews are the core capacity driver. The model starts with 10 crews, holds them flat for three years, then expands to 15 by Year 7.

  • New crews are only 50% productive in their first year, reflecting real onboarding time. Local demand grows 4.5% annually, while long-distance demand grows 7.0%, creating a squeeze on crew-hours until the hiring catch-up phase.
  • Costs are volume-derived: crew wages track hours worked, linehaul driver pay covers multi-day transit separately, and fuel/maintenance scales with miles. Other operating expenses include insurance, marketing, G&A, dispatch labor, and corporate overhead, each with their own growth rates.

This structure shows how capacity constraints ripple through revenue and margins rather than assuming smooth growth.

Cash Flow Bridge and Valuation Outputs

The model builds an unlevered free cash flow bridge starting from NOPAT, adding depreciation, subtracting capital expenditures and changes in working capital. Working capital nets accounts receivable, accounts payable, and the claims reserve, with the reserve treated as a liability that provides cash.

  • Capex covers new-crew trucks, fleet replacement, and facility buildout. The discounted cash flow uses a WACC of 10.5% and a terminal growth rate of 2.5% to arrive at enterprise value, then subtracts net debt to get equity value and value per share.
  • The dashboard summarizes crews, brokered share, FVP attach, revenue, EBITDA, EBITDA margin, claims reserve, and valuation metrics, offering a compact view of operating and financial outcomes.
income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

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.

Alex Tapio, ex-Deloitte financial modelling expert

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 moving company financial model?+

A moving company financial model captures the seven-year operating economics and intrinsic value of a regional household-goods mover running its own crews and trucks. It prices local and long-distance moves on two different real-world pricing structures, caps both against one crew-hours capacity pool, brokers out excess long-distance demand instead of turning it away, and builds a claims reserve for the cargo-liability coverage it sells, then discounts an unlevered free-cash-flow stream to enterprise value, equity value and value per share.

Why is long-distance revenue priced differently from local revenue?+

Real household-goods interstate carriers price on a regulated tariff structure - weight in hundredweight times distance in miles times a rate per hundredweight-mile - a fundamentally different formula from a local hourly crew rate. Modeling both explicitly, rather than collapsing them into one blended price, is what lets the shared-capacity mechanic and the brokered-margin dilution actually show up in the numbers.

Why does brokering long-distance jobs hurt EBITDA margin?+

A brokered long-distance job still shows up as revenue (the 14% broker fee), but the company's own crew, truck and linehaul driver never touch it - so it carries almost no cost of revenue but also almost none of the tariff value an in-house job would earn. As the brokered share rises during the crew-hiring freeze, blended revenue per long-distance job falls and EBITDA margin compresses even though total demand keeps growing.

Why is Full Value Protection a reserve instead of deferred revenue?+

Deferred revenue resolves into a service the company will still deliver later. A moving claim resolves into a cash payout for damage that has already happened - a real, incidence-driven liability, the same category as an insurer's loss reserve. The model rolls it forward from claims incurred and claims paid rather than treating the valuation-premium cash collected as a simple deposit.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview