Free Excel templates

A free sign company business model in Excel, with a full worked case

The exterior sign line with its labor hours and self-performed contribution, a channel letter bid line by line and its overrun, graphics and wraps by the graphics-hour, service and maintenance agreements, a P&L with reported and adjusted EBITDA, break-even, working capital, the cash floor and two offers for the company.

The file follows Quillmont Sign Company, a fictional shop with 6 fabricators, 2 install crews of two, a graphics team of 3 and 1 service technician. Revenue is $3,577,004, reported EBITDA $367,258, adjusted EBITDA $450,570 (12.6%), and the company breaks even at 84.6% of its revenue. The 2026 figures and the two offers of the book come from this model; replace the inputs with yours and the 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.

Sign_Company_Business_Model_Quillmont.xlsx (26 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 Sign Company Owner. The book explains every assumption and every tab: why the labor hour is the unit, why the permit sits inside the marked-up cost, why rework costs hours and material at the same price, how a wrap is priced by the graphics-hour, why a customer deposit is not cash to spend, and how two buyers would value the company.

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
People, wages, burden and paid hours; exterior revenue by channel, materials, subcontracted scope, permits, rentals and fuel; graphics and its price rule; service and maintenance agreements; trucks and leases; overhead, including the owner's salary and the social security wage base; working capital; the worked examples; the two offers; and, by kind of graphics job, jobs, hours, prices and materials.
Exterior Signs
Labor hours on jobs, exterior contribution, then the self-performed figures with the subcontract markup kept apart: $5,619 per job and $51.72 per labor hour in the case, after the wages of all paid hours.
Sign Bid
The channel letter bid as bid ($12,980, $68.30 per labor hour of the job) and after the overrun, with the remade faces' hours and acrylic counted ($46.57).
Graphics and Service
Graphics by kind of job and the price each would carry under the rule, $74.86 per graphics-hour on jobs, the box truck quote with and without its reprint, and the service line ($694 per technician-day).
P&L and Bridge
Cost of sales, gross profit (37.2%), overhead, reported EBITDA, the three add-backs, adjusted EBITDA, SDE and the break-even revenue ($3,027,244).
Cash
Working capital by component ($337,623 in the case, customer deposits as a liability) and the cash floor ($128,934).
Value
Offer A at 5.0x adjusted EBITDA with its rollover; offer B at 3.5x with an SBA 7(a) loan, the guaranty fee in the closing costs, the equity injection on total project cost and its debt service coverage (1.53x).
Checks
Every output set against the figure printed in the book.

Three things to try

Book fewer hours. Lower the share of the fabricators' paid hours booked to jobs. The wages do not move; the labor hours on jobs fall and the contribution per labor hour rises, which is why the book reads it with the hours counted.

Remake the faces again. Add fabricator-hours to the overrun column of the Sign Bid tab: the price stays at $11,900 for the self-performed work and the contribution per labor hour of the job falls.

Raise the manager's market salary. Raise the market salary of a hired general manager on the inputs tab. Reported EBITDA and SDE do not move; the owner add-back, adjusted EBITDA and both offers fall, and the Value tab asks for the guaranty fee to be retyped on the new loan. The personal expenses and the legal fees work the other way: they sit both in overhead and in the add-backs, so changing them moves reported EBITDA and leaves adjusted EBITDA where it was.

Questions

Can it price a channel letter sign?

Yes. In the case, materials of $4,850, 46 fabricator-hours, 1 install crew-day, fuel and a permit of $650 make a self-performed cost of $7,665.40; a markup of 55%, rounded up to the next $100, gives $11,900, and the electrician's circuit billed at $1,080 brings the price to $12,980.

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 sign shop?

Yes: replace every blue input, starting with your staff, wages, revenue by line and jobs. Quillmont and every figure in it are fictional case assumptions, not market data.

Related reading