Job Pricing & Breakeven Calculator — Excel Template

Know what every job really costs, what to charge, and how many jobs it takes to cover the month.

Most small businesses underprice for one reason: they forget overhead. Rent, insurance, the truck and your own pay don't show up on any one job, so they never make it into the quote. This calculator fixes that.

What's inside

• Monthly Costs: list your fixed bills and billable hours. It works out how much overhead every hour of work has to cover.
• Job Pricer: enter quantity, materials, labor and fees for up to 60 jobs. You get the full cost and a suggested price that hits your target margin.
• Quote checker: type in the price you already quoted to see your real margin. Jobs below target turn yellow, and jobs that lose money turn red.
• Breakeven: how many jobs, and how much in sales, you need each month to cover costs and hit a profit goal.
• "What if I raised my prices?": a table and chart showing how a 5–25% increase cuts the work you need to break even.

Details

• Format: Excel workbook (.xlsx) with a Start Here tab and filled-in examples
• Works in Excel 2010 or newer (Windows, Mac, Microsoft 365) and opens in Google Sheets
• Instant download

Pairs well with Charge What It's Worth, the Grit & Ledger pricing playbook.

Save with the bundle: The Owner's Toolkit includes this calculator, the Small Business Bookkeeping Kit and the 13-Week Cash Flow Forecast for $30 instead of $47.

From Grit & Ledger: business knowledge and motivation for people who build things.