Free Excel templates

A free food truck business model in Excel, with a full worked case

One service in each channel from sales to contribution per crew hour, food cost per ticket and prime cost, the year by channel with a P&L, break-even in services a week, the four quarters and the cash floor, adjusted EBITDA, SDE and two offers for the business.

The file follows Quillfennel Street Kitchen, a fictional business with 2 food trucks, one rented commissary and four channels. Revenue is $974,900 from 500 services, adjusted EBITDA $78,299 (8.0%), and the business breaks even at about 8.0 services a week. Every figure in the book comes from this model; replace the inputs with yours and the whole case recalculates.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

Food_Truck_Business_Model_Quillfennel.xlsx (21 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This file is the worked case of The Food Truck Owner. The book explains every assumption and every tab: why the crew is paid for the whole shift, why a price is tested against the contribution per crew hour and not the food alone, what a festival's fees take, why catering deposits are the customers' money, and how two buyers would value the business.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Eight tabs. Blue cells are inputs; every other cell is a formula.

Inputs
Trucks, wage, burden and tax on tips; truck fuel and the card fee; the trucks' maintenance, insurance and permits, the commissary and the truck loan; overhead; deposits and the shape of the seasons; the two offers and the trucks' sale value; and, by channel, services, tickets, average ticket, food and packaging per ticket, crew, shift hours, generator fuel, card share, tips and festival terms.
Service Economics
One service in each channel from sales to contribution before the crew, then after the crew and per crew hour ($14.43 for a street stop, $50.62 for a catering event in the case).
Menu Cost
Food cost per ticket and its share of the ticket (30.0% on the street), food for the year, and prime cost (56.0% of revenue).
Channel Mix
Services, revenue and contribution by channel, tickets and crew hours, then the year's P&L to EBITDA as reported ($63,687).
Break-Even
Fixed costs, the contribution share, break-even revenue ($778,133), services a year and a week at break-even, the margin of safety and the truck loan payments, paid below EBITDA.
Cash Floor
Catering deposits held, one month of fixed costs and the first quarter's loss ($63,176 in the case), one payroll, and the four quarters.
Value
Adjusted EBITDA and SDE, the trucks and equipment alone, offer A on adjusted EBITDA with an SBA 7(a) loan and its coverage, offer B on SDE.
Checks
The model's outputs set against the figures printed in the book, and the quarter shares that must add up to the whole.

Three things to try

Raise the street ticket. Type $17.00 for the street stop's average ticket and watch its contribution per crew hour. On 2026 volumes, the book puts the change at $24,681 a year after card fees and tax on tips.

Weigh a festival day. A festival day keeps $2,157.06 after its crew in the case, $1,464 more than two street stops. Raise the organizer's share or the booth fee and see where the day stops paying.

Reshape the seasons. Lower the first quarter's share of revenue on the Inputs tab and watch the Cash Floor tab, where the first quarter closed at -$18,788 of EBITDA in the case.

Questions

Can it tell me which events are worth doing?

Yes. In the case, a street stop keeps $14.43 per crew hour after the crew, a partner venue evening $28.05, a festival day $41.48 and a catering event $50.62.

Does it use macros?

No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.

Can I use it for my own food truck?

Yes: replace every blue input, starting with services, tickets per service and the average ticket of each channel. Quillfennel and every figure in it are fictional case assumptions, not market data.

Related reading