Free Excel templates

A free excavation company model in Excel, with a full worked case

Site packages, utility installation, basements for builders and homeowner work: unit prices and every cost line, export loads and trucks, contribution per crew-day, crews and overhead, a P&L with adjusted EBITDA, SDE and equipment payments, break-even and stress tests, equipment cost per hour and two offers for the company.

The file follows Corbeck Excavating & Site Work, a fictional company with a site crew and a builder crew on the edge of a growing metro area. It bills $4,200,480, earns adjusted EBITDA of $677,712 (16.1%), pays $300,000 a year on its equipment and breaks even after 148 of its 200 site crew days. Every figure in the book comes from the full model; this simplified version keeps the same logic and the same results.

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.

Excavation_Company_Model_Corbeck.xlsx (17 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 Excavation Contractor Business Owner. The book explains every assumption and every tab: how a takeoff becomes bank, loose and compacted yards and a bid, why the crew-day is the resource that runs out first, what the trucks and the fleet really cost, why cash falls into June, and how two buyers would value the company.

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

What is in the file

Eight tabs. Blue cells are inputs; every other cell is a formula.

Inputs
Production days, weeks and hours, burden and every crew member’s rate; the share of days and crew-days of each job type; swell, shrinkage, truck loads and dump fees; the typical jobs and their unit prices; materials, fuel, repairs and rentals; homeowner marketing; overhead; equipment payments; three stress test factors.
Jobs
One column per job type: price, every variable cost line, contribution, margin and contribution per crew-day ($10,090 for a site package in the case), then jobs, revenue and contribution for the year.
Crews and Overhead
Each crew’s year with overtime and burden, the cost per production day ($3,384 for the site crew) and the overhead lines.
P&L and Break-Even
Contribution, crew cost, overhead, adjusted EBITDA, reported EBITDA, SDE ($827,712), the equipment payments below EBITDA and the break-even in site crew days, with and without them.
Dirt
A pad takeoff: bank yards of cut, bank yards needed for a compacted fill, the export in loose yards, loads, truck-days and their cost.
Equipment
The owning and operating cost per hour of a large excavator ($74.73 before the operator), a fourth truck against hired trucks (136 working days to break even) and a dozer owned against rented.
Value
A regional contractor’s offer on adjusted EBITDA with a holdback, an individual buyer’s offer on SDE with an SBA loan and a seller note, the loan payment and its coverage with the fleet’s payments, and the fleet’s liquidation value.
Checks
A comparison with the figures printed in the book: with the case’s inputs every line reads OK.

Three things to try

Run a wet year. Set the production days factor to 0.88: revenue falls, the crews and the overhead do not, and adjusted EBITDA drops to $366,919, only $66,919 after equipment payments.

Change the swell. Raise the swell on the Inputs tab and watch the loads, the hired trucks and the export cost of every site package rise with it.

Park the excavator. Cut its engine hours on the Equipment tab from 1,600 to 900: its ownership cost per hour rises from $27.38 to $48.68.

Questions

What does a crew-day leave in the case?

A site package leaves $10,090 per site crew-day and a sewer job $7,520; on the builder crew, a basement leaves $4,351 and a homeowner job $2,730, after materials, trucks, dump fees, fuel, repairs, rentals and marketing, before crew wages and overhead.

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

Yes: replace every blue input, starting with your crews, production days, typical jobs and unit prices. Corbeck and every figure in it are fictional case assumptions, not market data.

Related reading