A free junk removal business model in Excel, with a full worked case
A load ladder and a quote calculator with a payload check, the cost of a truck-day, the mix and a management P&L with adjusted EBITDA and SDE, the booking funnel, price, diversion and franchise tests, break-even in jobs, seasons and working capital, a three-year plan and two offers for the company. Twelve sheets, no macros.
The file follows Clearway Junk Removal, a fictional company with 3 box trucks and two-person crews. Revenue is $1,174,635 from 2,800 jobs, adjusted EBITDA $177,552 (15.1%), and the company breaks even at 2,197 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.
Junk_Removal_Business_Model_Clearway.xlsx (31 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 Junk Removal Business Owner. The book explains every assumption and every sheet: what a truck-day costs, how to build and raise a load ladder, why weight decides the dump fee, when donating pays, what a lead and a booking point are worth, what a franchise royalty must bring back, why the first quarter barely breaks even, and how two different buyers value the same company.
Twelve sheets. Blue type on a yellow fill is an input; black type is a formula.
Inputs
Trucks, box size and payload; crew wages, burden, paid hours and jobs per truck-day; for each segment the share of jobs, average share of a truck, density, diversion, price factor and fees; the load ladder; tipping fee, fuel and truck costs; the funnel; overhead and owner pay; terms; test, plan, offer and seasonality assumptions.
Truck-Day
Crew wage and loaded cost, truck-days a year, the crew and fuel cost of a truck-day ($538.04 in the case) and jobs a year.
Mix
Jobs, ladder price for the average load, average ticket, revenue, yards, tons and disposal per job for residential pickups, estate clean-outs, debris and commercial work.
P&L
Revenue, crews, disposal, fuel and trucks, gross margin (48.5%), overhead, adjusted EBITDA, the EBITDA in the owner's books and SDE ($262,552).
Funnel
Leads (4,242), lead spend, lead cost per job and a booking-rate test.
Quote
Three jobs priced from the ladder: share of the truck, surcharges and fees, crew hours, tons to the transfer station, tipping fee, fuel, card fee, contribution and a payload check.
Break-Even
Contribution per job ($294.48), jobs per truck-day to cover crew and fuel and to cover everything, break-even jobs and revenue.
Tests
A price increase against lost jobs, extra diversion against drop-off trips, and a franchise royalty against the jobs it must bring.
Cash
Quarterly revenue and EBITDA; commercial receivables, the transfer station payable and a cash cushion.
Plan
2027 to 2029: trucks, a new truck's first year, truck-days, jobs, revenue, leads, EBITDA and margin.
Valuation
A regional hauling 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 the share of the truck, the fees, the hours, the crew and the kind of material; the Quote sheet returns the price, the tipping fee and the contribution, and warns when a dense load would exceed the payload.
Raise every ticket $20. The model shows $56,000 more profit a year if the same jobs book, and that up to 6.4% of jobs could be lost before the increase stops paying.
Change jobs per truck-day. Move it from 4.2 by half a job either way and watch EBITDA and break-even move with it.
Questions
Can it price a junk removal job?
Yes. In the case, a garage clean-out at three eighths of a 15-yard truck, with a mattress fee, is priced at $374 and contributes $239.14 after crew, tipping fee, 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 junk removal company?
Yes: replace every blue input, starting with your ladder and your tipping fee. Clearway and every figure in it are fictional case assumptions, not market data.