Food Truck Fleet Model
Operating Businesses Financial Model (Free Excel Download)
Forecast a food-truck fleet from locations, service days, transactions, menu mix, food costs, labor, permits, vehicle capex, and route expansion.
professionals from Deloitte
Used by professionals from
About this model
This model helps you assess a food truck business with one vehicle or a growing fleet. It connects daily trading, private events, catering, and delivery sales to food costs, crew pay, fuel, permits, and the investment required to add trucks.
Use it to evaluate a new truck, a catering strategy, or a multi-city rollout. Test customer volumes, menu pricing, event bookings, and staffing to see their impact on profit and cash flow.
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 Food Truck Fleet Model
- Truck & transaction economics: Y1 trucks, new trucks per year, transactions per truck, crew per truck, average ticket
- Route utilisation: Y1 utilisation, annual ramp and a practical ceiling below 100%
- Menu mix, pricing & food margins: mains / combos / sides / beverages shares, per-tier price indices and net margins, catering events per truck and average catering value, merch spend per transaction, price escalation
- Cost structure: crew compensation, support staff per truck and wage, benefits, wage growth; commissary & site fees, marketing, technology & POS and corporate SG&A as % of gross profit; depreciation % of revenue, tax
- Capital & working capital: maintenance capex %, truck build-out cost per truck, NWC % of revenue change, base-year revenue
- Valuation: WACC, terminal growth, net debt, shares outstanding
- Operations sheet: fleet roll-forward (opening, new, closing), a capped utilisation ramp, effective transactions per truck and total transactions, crew and prep/support headcount, total staff and transactions per crew
- Revenue sheet: menu revenue by tier, menu subtotal, catering & events, branded merchandise, total revenue
Inside the Food Truck Financial Model: How It Tracks Fleet Economics and Value
This food truck financial model is an operating and valuation template for a multi-unit mobile fleet. It links trucks, route utilisation, menu pricing and cost structure to cash flow and enterprise value.
The following explains the model's documented drivers, calculation flow, outputs and practical use, helping you evaluate whether it fits your analysis.
Fleet Roll-Forward and Volume Build
The model's starting point is the truck fleet itself: opening trucks plus new trucks equals closing trucks. That closing count drives the rest of the operations build, including crew headcount and the transaction-volume calculation.
- Each truck supports a mature number of transactions per year, based on service days and covers per day. A utilisation factor then scales that mature volume to reflect how full the route actually runs.
- Utilisation starts at a Year 1 input and ramps by a fixed number of percentage points annually, capped at a practical ceiling. Closing trucks multiplied by effective transactions per truck gives total transactions, which the design document identifies as the single most important volume driver.
The year's new trucks also trigger build-out capex through a per-truck vehicle, wrap and kitchen investment.
Menu Mix, Pricing and Catering Revenue
Revenue is built in three layers. Menu revenue comes from transactions split across four tiers: signature mains, combos and platters, sides and snacks, and beverages.
- Each tier has a share, a blended average ticket and a price index, so the blended revenue per transaction emerges from the mix. A combo carries a price index above one while a side or drink sits below it, meaning a shift toward higher-ticket combos expands blended revenue even with flat transaction volume.
- Truck-driven catering and events add closing trucks times events per truck times average catering value, and branded merchandise adds transaction-driven spend. All lines escalate at a menu price step-up.
Food and packaging cost is tier revenue times one minus that tier's net margin, with mains and combos carrying heavier protein costs and beverages pouring at the widest margin.
Cost Stack and Profitability Profile
Crew and prep labour are headcount-driven, calculated as FTEs per truck times wage, loaded for benefits and escalated at the wage-growth rate. These labour costs sit in operating expense rather than cost of revenue, so the blended gross margin runs well above the food-only figure and EBITDA margin becomes the meaningful profitability line.
- The remaining overhead stack—commissary and site fees, marketing and promotion, technology and POS, and corporate SG&A—is set as a percentage of gross profit rather than revenue. This reflects that the fleet is a high-gross-margin business whose true operating scale is gross profit.
- Because the utilisation ramp and price escalation lift gross profit while per-truck crew grows only with headcount and wage inflation, the model captures operating leverage: EBITDA margin expands across the forecast horizon as the fixed crew is filled.
Cash Flow, Valuation and Practical Application
Unlevered free cash flow is NOPAT plus depreciation, less maintenance capex and truck build-out capex, less the change in working capital. Working capital is a light call because a food fleet collects cash and card at the window and carries modest food inventory, so only a thin fraction of revenue growth ties up in working capital.
- The DCF sums the present value of explicit free cash flows and a Gordon-growth terminal value to reach enterprise value, then subtracts net debt for equity value and value per share. A dashboard summarises trucks, transactions, utilisation, revenue per truck, revenue per transaction, revenue, EBITDA, EBITDA margin, enterprise value and value per share.
- Practically, the model helps an analyst flex transactions per truck, the utilisation ramp, menu mix or catering attach and see the flow through to cash flow and valuation. The public download is a values-only preview.
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 food truck financial model?+
A food truck financial model captures the seven-year operating economics and intrinsic value of a multi-unit food truck fleet - a branded fleet of mobile kitchens serving street pitches, offices, breweries and festivals, plus a catering & events book and a branded-merch attach. It rolls a truck count forward, ramps route utilisation into a total transaction count, builds menu revenue tier by tier (signature mains, combos, sides and beverages, each at a per-tier price index) with catering and merch on top, nets food and packaging cost into gross profit, runs crew and prep labour and a gross-profit-geared overhead stack to EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value and value per share.
Why is utilisation the core driver?+
A food truck carries a largely fixed crew and commissary cost whatever the day's volume, so profitability turns on how full the route runs. Each truck supports a mature number of transactions a year; a route-utilisation factor (the share of that mature volume the route actually fills) times transactions per truck gives effective transactions per truck, and closing trucks times that gives total transactions - the single most important volume driver. Utilisation starts at the Y1 input and ramps a fixed number of points a year, capped below 100% because a new truck takes a season or two to build its pitches and regulars.
How does the menu-mix revenue engine work?+
Menu revenue is built tier by tier: transactions times each tier's share times the average ticket times that tier's price index, escalated at the menu step-up. A combo or platter carries a price index well above one while a side or a drink sits below it, so the blended revenue per transaction falls out of the mix - and as the mix shifts toward higher-ticket combos the blended figure expands even at flat volume. Food and packaging cost is each tier's revenue times one minus that tier's net margin: mains and combos carry a real protein cost of goods, sides run on cheap staples, and beverages pour at the widest margin.
Why does gross margin look high while EBITDA margin is the headline?+
Gross profit is struck only against food and packaging cost, which keeps the blended gross margin near seventy percent. Crew and prep labour - the single largest line in a people-intensive food business - sit in operating expense rather than cost of revenue, so EBITDA margin is the meaningful profitability measure. Because the utilisation ramp and price escalation lift gross profit while per-truck crew grows only with headcount and wage inflation, the EBITDA margin expands across the horizon: the operating leverage of filling a fixed crew.
How is this different from the restaurant and franchise templates?+
The restaurant model builds a fixed-location, table-and-cover business; the franchise model builds a royalty-and-unit-fee franchisor. Food-truck-fleet is a mobile, route-driven fleet: its capacity constraint is trucks and how full each route runs, its revenue is a menu-mix engine on a per-truck transaction volume rather than covers or franchise fees, and its dominant capital call is the per-truck build-out that funds fleet expansion - so the model foregrounds the truck roll-forward, the utilisation ramp and the menu mix.
Have more financial modelling questions? Contact us
Related templates
Restaurant Unit Economics and Multi-Unit Model
Single-unit operating metrics, cost of goods sold, labor, rent, and multi-unit chain economics.
Franchise Unit Economics Model
Economics template for franchise systems modeling unit-level P&L, franchise fees, royalties, and multi-unit growth scenarios.
Car Rental Economics Model
Vehicle fleet rental financial projections with utilization and rate dynamics.
Food Manufacturing Model
Operating model for food production and processing businesses with ingredient sourcing, production scheduling, and margin analysis.
