A free dumpster rental business model in Excel, with a full worked case
Truck hours and hauls, the size mix and a management P&L with adjusted EBITDA and SDE, a quote calculator by size, tons and days, can utilization, the booking funnel, break-even in hauls, price, tipping fee, swap, truck-hour and fleet tests, seasons and working capital, a three-year plan with a third truck and two offers for the company. Twelve sheets, no macros.
The file follows Ironbark Roll-Off, a fictional company with 2 trucks and 120 cans. Revenue is $1,547,329 from 2,593 hauls, adjusted EBITDA $263,069 (17.0%), and the company breaks even at 1,877 hauls 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.
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 Dumpster Rental Business Owner. The book explains every assumption and every sheet: why the truck hour is the unit of production, how the posted price, the included tons and the overage fit together, why disposal is the largest cost, when the can fleet is really full, what a swap and a point of close rate are worth, 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, driver wage, burden and paid hours; operating days, shop days, hours per truck-day and the share of hours spent on hauls; truck hours per haul and per swap; contractor share and discount, overage and extra-day rates; tipping fee and diesel; truck and can costs; for each size the share of hauls, posted price, included and average tons, overage, days on site, cans and can price; the funnel; overhead and owner pay; terms; test, plan, offer and seasonality assumptions.
Trucks
Truck-days and truck hours available, average truck hours per haul (1.45 in the case), hauls a year, hauls per truck-day, capacity, and driver time and fuel per haul.
Mix
For each size: hauls, revenue per haul, revenue, tons dumped, tipping fee per haul, can-days used, can utilization and revenue per can.
P&L
Revenue, drivers, disposal, fuel, trucks and cans, gross margin (41.3%), overhead, adjusted EBITDA, the EBITDA in the owner's books and SDE ($353,069).
Quote
Three rentals priced from the posted price: size, tons on the ticket, extra days, contractor price, swap and lead cost; tipping fee, driver time, fuel and card fee; contribution and contribution per truck hour.
Funnel
Hauls from new customers, new requests (2,377), lead spend, lead cost per haul and a close-rate test.
Break-Even
Contribution per haul ($367.60) and per truck hour, fixed costs, break-even in hauls, weeks and revenue, margin of safety, and the hauls that pay the office manager and the insurance.
Tests
A price increase against lost hauls, a tipping fee increase, more swaps, more truck hours on hauls, and more cans.
Cash
Quarterly revenue and EBITDA; contractor receivables, the transfer station payable and a cash cushion.
Plan
2027 to 2029: trucks, a new truck's first year, cans added, hauls, revenue, new requests, EBITDA and margin.
Valuation
A regional waste hauler'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 rental. Enter the size, the tons you expect and the days on site; the Quote sheet returns the price and the contribution per truck hour, so you can see what an unbilled overage or a free week costs you.
Raise every haul $25. The model shows $64,828 more profit a year if the same hauls book, and that up to 6.4% of hauls could be lost before the increase stops paying.
Change the tipping fee or the truck hours per haul. Add a few dollars a ton or ten minutes a haul and watch the break-even move.
Questions
Can it price a dumpster rental?
Yes. In the case, a roofer's 20-yard tear-off of 4.6 tons on a swap, at the contractor price with 2.1 tons of overage, is priced at $680 and contributes $323.64 after disposal, driver time, 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 roll-off company?
Yes: replace every blue input, starting with your tipping fee, your truck hours per haul and your posted prices. Ironbark and every figure in it are fictional case assumptions, not market data.