The price of each kind of job by the square foot, materials with the waste counted, contribution per crew-day, the W-2 crew against the subcontracted installer, a P&L with break-even, the cash floor and net working capital, adjusted EBITDA, SDE and two offers for the company.
The file follows Brindlemere Floors, a fictional company with 4 W-2 crews of two, a showroom and a warehouse. Revenue is $3,008,826 from 501 installed jobs, adjusted EBITDA $444,000 (14.8%), and the company breaks even at about 7.3 installed jobs a week. Every figure in the book comes from this model; replace the inputs with yours and the whole case recalculates.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Flooring_Company_Business_Model_Brindlemere.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.
This file is the worked case of The Flooring Company Owner. The book explains every assumption and every tab: why the crew-day is the unit, why the waste is priced because it is bought, how markup differs from margin, when a subcontracted installer earns his place, why a builder job pays less per day and later, and how two buyers would value the company.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Eight tabs. Blue cells are inputs; every other cell is a formula.
Reprice tile. Raise the tile labor price per square foot in the inputs and watch tile's contribution per crew-day on the Job Contribution tab. In the case, $15.33 a square foot would bring it level with vinyl plank.
Add four points of utilization. The Job Contribution tab shows $61,142 more contribution a year with the same crews and the same wages.
Send a job out. The Crew or Subcontractor tab shows what an average vinyl plank job leaves with the crew ($1,884) and with a subcontractor ($1,671), before you ask whether the crew would have been idle that day.
Yes. In the case, an average vinyl plank job of 620 square feet is priced at $4,856, or $7.83 a square foot with materials, labor and extras.
No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.
Yes: replace every blue input, starting with your crews, your wages, your square feet and your price list. Brindlemere and every figure in it are fictional case assumptions, not market data.