Free Excel templates

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

The commercial line with its labor hours and self-performed contribution, a storefront bid line by line and its second trip, residential jobs by kind with the price rule and a shower quote, service and door 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 Ardmoor Glass Company, a fictional company with 3 shop fabricators, 3 field crews of two, 3 residential installers and 2 service technicians. Revenue is $4,286,280, reported EBITDA $470,470, adjusted EBITDA $546,380 (12.7%), and the company breaks even at 81.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.

Glass_Company_Business_Model_Ardmoor.xlsx (27 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 Glass and Glazing Company Owner. The book explains every assumption and every tab: why the labor hour is the unit, why engineering and the rented lift sit inside the marked-up cost, why a chipped lite costs a crew-day and its fuel as well as the glass, why tempered glass is measured twice, 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, except the book figures on the Checks tab.

Inputs
People, wages, burden and paid hours; commercial revenue by channel, materials, subcontracted scope, engineering, rentals and fuel; the residential installers and the price rule; service and door maintenance agreements; trucks and leases; overhead with the add-backs, including the owner's salary and the social security wage base; working capital; the worked examples; the two offers; and, by kind of residential job, jobs, hours, prices and materials.
Commercial
Labor hours on jobs, commercial contribution, then the self-performed figures with the subcontract markup kept apart: $12,065 per job and $49.29 per labor hour in the case, after the wages of all paid hours.
Storefront Bid
The storefront and entrance package as bid ($32,510, retainage of $3,251, $69.47 per labor hour of the job) and after the second trip, with the crew-day, its fuel and the replacement lite counted ($45.03).
Residential and Service
Residential jobs by kind and the price each would carry under the rule, the shortfall of each list price, $86.73 per installer-hour on jobs, the shower quote with and without its remake, and the service line ($777 per technician-day).
P&L and Bridge
Cost of sales, gross profit (33.4%), overhead, reported EBITDA, the three add-backs, adjusted EBITDA, SDE and the break-even revenue ($3,498,037).
Cash
Working capital by component ($501,823 in the case, customer deposits as a liability) and the cash floor ($154,539).
Value
Offer A at 4.8x adjusted EBITDA with its rollover; offer B at 3.6x with an SBA 7(a) loan, the guaranty fee solved on the final loan by passes laid out row by row, the equity injection on total project cost split into the buyer's cash and the standby seller note, and the debt service coverage (1.52x).
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.

Add a day to the second trip. Raise the crew-days added by the overrun on the Inputs tab: the price stays at $30,900 for the self-performed work, and the contribution per labor hour of the job falls on the Storefront Bid tab.

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 passes on the Value tab carry the guaranty fee to the new loan on their own. The personal expenses and the move costs work the other way: each is typed once and feeds both an overhead line and an add-back, so changing it moves reported EBITDA and leaves adjusted EBITDA where it was.

Questions

Can it price a storefront glazing job?

Yes. In the case, materials of $17,850, 44 fabricator-hours, 4 field crew-days, fuel, shop drawings and stamped calculations of $950 and a rented lift of $520 make a self-performed cost of $23,397.28; a markup of 32%, rounded up to the next $100, gives $30,900, and the perimeter sealant billed at $1,610 brings the price to $32,510.

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

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

Related reading