Free Excel templates

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

Driveways, commercial mill and overlay, patching, commercial maintenance and residential sealcoating: tons, prices and every cost line, contribution per crew-day, crews and overhead, a P&L with adjusted EBITDA and SDE, break-even and stress tests, cash month by month and two offers for the company.

The file follows Fairlow Paving & Sealcoating, a fictional company with one paving crew and one sealcoat crew in a northern metro area. It bills $3,719,031, places 12,320 tons of asphalt and earns adjusted EBITDA of $471,125 (12.7%), and breaks even after 88 of its 120 paving 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.

Asphalt_Paving_Company_Model_Fairlow.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 Asphalt Paving Company Owner. The book explains every assumption and every tab: how a takeoff becomes tons and a bid, why the crew-day is the resource that runs out first, what the trucks and the milling really cost, why cash keeps falling into the season, and how two buyers would value the company.

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

What is in the file

Seven 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; the typical jobs; asphalt, base, sealer, fuel and repairs; residential marketing; overhead; three stress test factors; cash and the two offers.
Jobs
One column per job type: tons, price, every variable cost line, contribution, margin and contribution per crew-day ($11,111 for a commercial overlay in the case), then jobs, revenue and contribution for the year.
Crews and Overhead
Each crew’s season with overtime and burden, the cost per production day ($4,001 for the paving crew) and the overhead lines.
P&L and Break-Even
Contribution, crew cost, overhead, adjusted EBITDA, reported EBITDA, SDE ($611,125), tons placed and the break-even in paving days.
Cash
Month by month with the real lags: residential paid on completion, commercial over two months, retainage three months later, asphalt the month after. The cumulative cash from December and its deepest point ($165,646 in June).
Value
A regional group’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, 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 season. Set the production days factor to 0.85: revenue falls, the crews and the overhead do not, and adjusted EBITDA drops to $209,889.

Raise the asphalt price. Set the asphalt factor to 1.12 with prices unchanged: $115,315 comes straight off EBITDA.

Change the mix of days. Move paving days from commercial overlays to driveways and watch contribution per crew-day pull EBITDA down, even with the crew just as busy.

Questions

What does a crew-day leave in the case?

A commercial mill and overlay leaves $11,111 per crew-day, patching $9,200, a driveway $5,586, commercial maintenance $7,625 and residential sealcoating $1,028, after asphalt, trucks, milling, materials, fuel, repairs 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 prices. Fairlow and every figure in it are fictional case assumptions, not market data.

Related reading