Free Excel templates

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

The cost of a crew-day and the weather days, the mix and a management P&L with adjusted EBITDA and SDE, a quote calculator for pruning, crane removals and storm work with stump grinding, the estimate funnel, break-even in jobs and crew-days, price, wood and crane tests, seasons and working capital, a three-year plan and two offers for the company. Twelve sheets, no macros.

The file follows Kestrelwood Tree Service, a fictional company with 2 crews of 3. Revenue is $1,258,884 from 757 jobs, adjusted EBITDA $179,919 (14.3%), and the company breaks even at 629 jobs a year. 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.

Tree_Service_Business_Model_Kestrelwood.xlsx (32 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 Tree Service Business Owner. The book explains every assumption and every sheet: what a crew-day costs, why the base day rate barely breaks even, what the removal premium pays for, when a crane wins the job and when owning one pays, how to price a stump, where the wood goes, what an estimate and a point of close rate are worth, why the first quarter barely breaks even, 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. Blue type on a yellow fill is an input; black type is a formula.

Inputs
Crews and crew size, wages, payroll burden, paid hours, hours per crew-day and weather days; the day rate; stump grinding and crane terms; tipping fee, fuel and equipment costs; for each segment the share of crew-days, crew-days per job, price factor, tons of wood and share diverted; the funnel; overhead and owner pay; terms; test, plan, offer and seasonality assumptions.
Crew-Day
Loaded cost of a field hour, of a crew hour and of a crew-day ($905.76 in the case), producing crew-days, the cost of weather days, the stump fee and the average crane cost per removal.
Mix
Crew-days, jobs, average ticket, revenue, revenue per crew-day, tons of wood and tons to the green-waste site for removals, pruning, commercial work and storm work.
P&L
Revenue, field labor, equipment, cranes, disposal and fuel, gross margin (42.2%), overhead, adjusted EBITDA, the EBITDA in the owner's books and SDE ($274,919).
Quote
Three jobs priced from the day rate: crew-days, price factor, crane hours and stump inches; crew cost (with an overtime factor), tons to the site, tipping fee, fuel, crane and card fee; contribution and contribution per crew-day.
Funnel
Estimate requests (1,681), lead spend, lead cost per job, estimating hours and their cost per job, and a close-rate test.
Break-Even
Contribution per job ($1,406.16) and per crew-day, the full cost of a crew-day, the revenue a crew-day needs, break-even jobs, revenue and crew-days, and the cost of extra weather days.
Tests
A price increase against lost jobs, more wood diversion against the drops it needs, and owning a crane against renting it.
Cash
Quarterly revenue and EBITDA; commercial receivables, the green-waste payable and a cash cushion.
Plan
2027 to 2029: crews, a new crew's first year, crew-days, jobs, revenue, estimate requests, EBITDA and margin.
Valuation
A regional tree care 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 removal. Enter the crew-days, the crane hours and the stump; the Quote sheet returns the price and the contribution per crew-day, so you can compare the crane version with the climbed one.

Raise every ticket $75. The model shows $56,749 more profit a year if the same jobs book, and that up to 5.1% of jobs could be lost before the increase stops paying.

Change the weather days or the burden. Add five weather days per crew or a few points of workers' compensation and watch the break-even day rate move.

Questions

Can it price a tree removal?

Yes. In the case, a large pine over a house, three quarters of a crew-day with 4 crane hours and one stump, is priced at $3,676 and contributes $1,528.61 after crew, crane, wood, fuel and card fee.

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 tree service?

Yes: replace every blue input, starting with your wages, your payroll burden and your day rate. Kestrelwood and every figure in it are fictional case assumptions, not market data.

Related reading