Free Excel templates

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

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.

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.

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.

The book behind this model

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

What is in the file

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

Inputs
Crews, wages, burden, working days and utilization; fees, leads and fuel; van upkeep, callbacks, the counter and freight; overhead; cash terms; the two offers; and, by kind of work, the job mix, square feet, material price and cost, waste, labor price, extras, crew-days and the subcontracted share and rate.
Job Price
The price of an average job of each kind and its all-in price per square foot ($7.83 for vinyl plank in the case), markup and margin on materials, and the jobs and revenue of the year.
Job Contribution
What each job leaves after materials, extras, fees, leads, fuel and subcontracted installation, then the same job installed by the company's own crew and its contribution per crew-day ($1,354 for hardwood, $667 for tile).
Crew or Subcontractor
The crew's cost per square foot on a billed day and with idle days spread, against the subcontractor's rate, and what the job leaves each way.
Break-Even
The P&L (gross margin 34.9%), fixed costs, the contribution share, break-even revenue ($2,194,047) and the margin of safety.
Cash Floor
One payroll, two weeks of material orders and a month's rent ($83,091 in the case); deposits held, builder receivables, stock, distributor payables and net working capital.
Value
Adjusted EBITDA and SDE, offer A on adjusted EBITDA with an SBA 7(a) loan and its coverage, offer B on SDE.
Checks
Every output set against the figure printed in the book, and the job mix that must add up to the whole.

Three things to try

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.

Questions

Can it price a flooring job per square foot?

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.

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 flooring company?

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.

Related reading