Free Excel templates

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

Technician hours and jobs, service call prices with the minimum, materials and markup, revenue for service calls, projects, property manager work orders and inspection repair lists, repeat customers and churn, new requests, a management P&L with adjusted EBITDA and SDE, a calculator for one job, break-even, price, workers' compensation, lost-days and scheduling tests, seasons and working capital, a three-year plan and two offers for the company.

The file follows Fenwick Home Repair, a fictional company with 8 technicians, 566 active repeat customers, 21 property managers and 63 agents who send repair lists. Revenue is $1,488,602 from 2,686 jobs, adjusted EBITDA $161,741 (10.9%), and the company breaks even at 2,300 jobs a year. 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.

Handyman_Business_Model_Fenwick.xlsx (34 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 Handyman Business Owner. The book explains every assumption and every sheet: why the technician hour is the unit of production, how the hourly rate, the minimum and the materials markup fit together, why a fixed-price project needs a change order process, what repeat customers are worth, why drive time is paid and how to cut it, and how two buyers would value the company.

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

What is in the file

Twelve sheets. Blue type on a yellow fill is an input; black type is a formula.

Inputs
Technicians, wages, burden and paid hours; working days, days lost and the share of hours on jobs; share, technician hours, materials and markup by kind of work; the service call list mix; the homeowner rate and the minimum; the project rate and hours; the property manager rate and hours; repair list hours; disposal, fuel and vans; repeat customers, churn, close rate and cost per request; overhead; the tests, the plan and the two offers.
Technicians
Technician-days and hours available, average technician hours per job (4.57 in the case), jobs a year, jobs per technician-day, capacity, and technician time and fuel per job.
Jobs
Service call labor by list size with the minimum applied, and for each kind of work: labor and materials billed, jobs, ticket, revenue, materials at cost and revenue per technician hour; property manager accounts and agents.
Customers
Jobs from repeat and first-time customers, active repeat customers (566), customers lost at the churn, new requests (1,497), lead spend, and churn and close rate tests.
P&L
Revenue, technicians, materials, disposal, fuel and vans, gross margin (32.7%), overhead, adjusted EBITDA, the EBITDA in the owner's books and SDE ($251,741).
Job
Six jobs from the book: a first service call, the same customer's repeat call, a lockset at the minimum, a make-ready day in one apartment community, a seller's repair list and a bathroom project as bid, with contribution and contribution per technician hour.
Break-Even
Contribution per job ($418.76) and per technician hour, fixed costs, break-even in jobs and revenue, margin of safety, and the jobs that pay the office manager, the insurance and one technician.
Tests
An hourly rate increase against lost jobs, a higher workers' compensation burden after injury claims, a bad year of lost days, and more technician hours on jobs.
Cash
Quarterly revenue and EBITDA with account work spread evenly; receivables, payables and the December cash cushion with a payroll float.
Plan
2027 to 2029: technicians, a new technician's first year, jobs, repeat customers, revenue, new requests, EBITDA and margin.
Valuation
A regional home services 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, and the equipment value.
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 the price, the technician hours and the materials; the Job sheet returns the contribution per technician hour, so you can compare a service call, a project, a make-ready day and a repair list on the same footing.

Raise the hourly rate $10. The model shows $57,210 more profit a year if the same jobs stay, and that up to 8.9% of those jobs could be lost before the increase stops paying.

Use 85% of technician hours on jobs instead of 80%. The Tests sheet shows 168 more jobs and $70,296 more profit a year with the same technicians and vans.

Questions

Can it price a handyman job?

Yes. In the case, a first service call of three billed hours with materials is priced at $420.50 and contributes $147.86 after materials, technician time, fuel, card fee and lead cost; a half-hour lockset billed at the $250 minimum contributes $186.61.

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

Yes: replace every blue input, starting with your technician hours per job, your wages and your rates. Fenwick and every figure in it are fictional case assumptions, not market data.

Related reading