Free Excel templates

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

The loaded cost of a billed hour, an estimate calculator by production rate, the revenue mix and a management P&L with adjusted EBITDA and SDE, the sales funnel, rate, production and subcontractor tests, break-even in billed hours, seasons and working capital, a three-year plan and two offers for the company. Twelve sheets, no macros.

The file follows Brightline Painting, a fictional residential painting company with 8 painters in two crews. Revenue is $1,219,338, adjusted EBITDA $158,055 (13.0%), and each billed hour costs $34.59 fully loaded against a $72 residential rate. The company breaks even at 8,316 billed hours. Every figure in the book is computed here, and every input can be replaced with your own.

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.

Painting_Business_Model_Brightline.xlsx (30 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 Painting Business Owner. The book explains every assumption and every sheet: what a billed hour really costs, how to estimate by production rate, how to set and raise the rate, when to subcontract, what an overrun costs, how the close rate drives the company, why the winter loses money, and how two different buyers value the same company.

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

What is in the file

Twelve sheets, in the order the calculation runs. Blue type on a yellow fill is an input; black type is a formula.

Inputs
Painters, crew leads, wages, burden, paid hours and the billed share; for each segment the share of hours, rate, materials per hour and hours per job; markup, vans, equipment and callbacks; the funnel; overhead and owner pay; working capital terms; test, plan, offer and seasonality assumptions.
Billed Hour
Blended wage, loaded cost per paid hour and per billed hour ($34.59 in the case), billed hours per painter and in total, and the cost of unbilled hours.
Mix
Hours, jobs, revenue, gross margin and gross profit per hour for exteriors, interiors, cabinets and commercial work.
P&L
Revenue, field labor, materials, vans and callbacks, gross margin (39.2%), overhead, adjusted EBITDA, the EBITDA in the owner's books and SDE ($253,055).
Estimate
Two jobs priced from areas and production rates: hours, gallons, materials, price, labor cost, gross profit, crew days, an overrun test, the deposit and the subcontracted version.
Funnel
Leads (976), estimates (732), jobs, lead spend, cost per job sold and a close-rate test.
Tests
A rate increase against lost hours, a production gain, and own crew against subcontractor.
Break-Even
Contribution per billed hour ($34.33), fixed costs, break-even hours, revenue and painters, and the hours a new salary needs.
Cash
Quarterly revenue and EBITDA (a first-quarter loss of $20,825 in the case); working capital with deposits (-$15,319).
Plan
2027 to 2029: painters, new painters' first year, billed hours, revenue, jobs, leads, EBITDA and margin.
Valuation
A regional painting company's offer on adjusted EBITDA with an earnout, an individual buyer's offer on SDE with an SBA loan and a seller note, the loan payment and its coverage.
Checks
Shares add up, gross profit ties, quarters tie, SDE ties, and a comparison with the figures printed in the book.

Three things to try

Price your next job. Enter its areas, your own production rates, the trim and setup hours and the gallons; the Estimate sheet returns the price and the gross profit, and what a 20% overrun would take back.

Raise the rate $5 an hour. The model shows $64,600 more gross profit a year if the same hours sell, and how far the close rate can fall (30.8% in the case) before the increase stops paying.

Change the billed share of paid hours. Move it a few points and watch the loaded cost per billed hour, gross profit and break-even move with it.

Questions

Can it estimate a painting job?

Yes. In the case, a 3,200 sq ft exterior at 100 sq ft per hour, with trim and setup, takes 56 hours and is priced at $5,489.28, a gross margin of 42.6%.

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

Yes: replace every blue input. Brightline and every figure in it are fictional case assumptions, not market data.

Related reading