Free Excel templates

A free fence job price and break-even calculator in Excel

The price of a typical job of each fence type by the foot, with gates and removal; what it leaves after materials with waste, piece pay, burden, card fees, the loader and its share of fixed costs; break-even in feet a month from a closed year; and a check of one installer's piece-rate week against the minimum wage and the overtime premium.

The file opens on the book's fictional company, Ravelcourt Fence, in FY2026. Fixed costs of $565,520 over 1,173 crew-days installed make $482.11 a crew-day. A 150-foot wood privacy fence with one gate at $41.00 a foot is a $7,030.00 job; it leaves $2,722.59 after materials, piece pay, burden, card fees and the loader, and $1,517.32 after its 2.5 crew-days of fixed costs. The year needed 2,936 feet a month to break even and installed 5,791.

Get the calculator

One Excel file, no macros, nothing locked on the Inputs tab. Free: enter your email address and the download opens at once, along with the other free models.

Fence_Job_Price_and_Break_Even_Calculator.xlsx (14 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 calculator

This file is drawn from workbooks 1, 2 and 3 of The Fence Company Owner, which follows one fictional fence company through two fiscal years: three crews paid by the hour, then five crews on a piece rate a foot with a weekly guarantee, an estimator, a loader with an auger, a materials depot, financing, commercial work for general contractors with retainage, break-even in feet a month and a letter of intent from an SBA-backed buyer.

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

What is in the file

Three sheets. Blue type on a yellow fill is an input; black type is a formula, protected against overtyping with no password.

Inputs
For five job types (wood privacy fence, vinyl fence, aluminum or ornamental steel fence, chain link fence, commercial job) the feet, the price a foot, the gates and their price, the share of feet with an old fence removed, the materials a foot, the waste rate, the cost of a gate, the crew-days and the piece rate a foot; the removal price and disposal cost a foot, the piece rates for a gate and a foot removed, the payroll burden, the card fee and the share of residential revenue paid by card, the loader cost a job; the year's fixed costs and crew-days installed; the four totals of two closed years (feet, revenue, variable costs, fixed costs); and one installer's week: the crew's piece earnings, the installer's share, hours worked and the minimum wage.
Calculator
The fixed cost a crew-day; for each job type the feet removed, the price, the materials with waste, gates and disposal, the piece pay, burden, card fees and loader, the margin before fixed costs, a foot, and after them; the contribution a foot, break-even feet a month, actual feet a month and margin of safety of each closed year (2,547 against 3,264 in FY2025, 2,936 against 5,791 in FY2026); and the week's piece earnings, weekly guarantee, top-up, regular rate, overtime premium rounded up to the cent, pay rounded up to the dollar, with a pay alert.
Checks
Every price a foot above its materials a foot, a burden factor from 0 to 0.5, crew-days above zero, feet above zero and revenue above variable costs in each year, pay at least the minimum wage for every hour, and an overtime premium of at least half the regular rate above 40 hours, with an All checks cell.

Three things to try

Raise every materials cost a foot by 6 percent, prices unchanged. That is a supplier's rise between the signed price and the order. The wood privacy fence falls from $1,517.32 to $1,381.24 after fixed costs, the vinyl fence from $2,397.07 to $2,182.03 and the chain link fence from $1,010.06 to $906.18: the fence with the most material in its price loses the most.

Add $40,000 a year to the FY2026 fixed costs of the closed year. Break-even moves from 2,936 to 3,144 feet a month, and the margin of safety from 49.3 to 45.7 percent.

Type the busy week instead of the frozen one. The file opens on week 68, a frozen-ground week of 32 hours: the crew's piece earnings of $504.00 give the installer $226.80, below the guarantee, so the top-up is $5.20 and the regular rate exactly $7.25. Type $2,466.60 and 48 hours, week 81: the installer earns $1,109.97, no top-up is due, the regular rate is $23.12, the overtime premium for the 8 hours above 40 is $92.50 and the week's pay is $1,203.

Questions

Why does a piece-rate week need a minimum wage check?

Because piece pay is pay for every hour worked, productive or not. Under federal rules as in force in November 2026, the week's piece earnings divided by all the hours worked must reach the minimum wage, and the hours above 40 earn an overtime premium of half the regular rate on top. A state or city may set a higher floor; the calculator lets you type it.

Does the calculator include lead costs?

Not in the margin a job: in the book's split, paid estimate requests and referral gifts are variable costs of the year, and they sit in the closed year's totals that drive break-even. The book's workbook 4 sets each lead channel's cost against the jobs it brings: $412.27 a job signed from paid estimate requests in the case.

Related reading