Construction Estimate Template in Excel: Quantity Takeoff, Unit Costs, Markup and a Remodel Example
How to build a construction estimate template in Excel: line items by trade, quantity takeoff, material and labor unit costs, subcontractor quotes, contingency, overhead and profit, markup versus margin, and a worked bathroom remodel estimate you can adapt.
Quick answer: a construction estimate template in Excel lists every piece of work as a line item with a quantity, a unit, a material cost per unit and a labor cost per unit (or labor hours × rate). Line totals add up to direct costs. On top of that you add a contingency for the unknowns, then overhead and profit to reach the price you quote. The key formula per line is:
=Quantity*(MaterialUnitCost+LaborUnitCost)
Below is a structure that works for remodels, small builds and trade contractors, with a worked bathroom remodel example. All prices are illustrative; real costs vary widely by location, season and supplier.
Step 1: Organize line items by trade or phase
Group the estimate the way the work happens, so nothing gets missed and the client can follow it:
| Group | Typical items |
|---|---|
| General conditions | Permits, dumpster, protection, cleanup, supervision |
| Demolition | Removal, haul-away, disposal fees |
| Rough work | Framing, plumbing rough-in, electrical rough-in, HVAC |
| Enclosure | Drywall, cement board, insulation |
| Finishes | Tile, flooring, paint, trim |
| Fixtures and equipment | Vanities, toilets, lighting, appliances |
| Subcontractors | Quoted lump sums from licensed trades |
Larger commercial estimates often follow a standard division system; for residential and small jobs, simple trade groups are enough.
Step 2: Columns and formulas
| Column | Content | Formula |
|---|---|---|
| A Group | Demolition, Finishes… | Data validation list |
| B Description | “Wall tile, shower surround” | |
| C Quantity | From the takeoff | Often a formula: =Length*Height-Openings |
| D Unit | sq ft, linear ft, each, hour, LS | |
| E Waste % | Extra material for cuts and breakage | e.g. 10% for tile |
| F Material $/unit | From supplier pricing | =XLOOKUP(B5,Prices[Item],Prices[Cost]) |
| G Labor $/unit | Your rate or crew production | or Hours × rate |
| H Material total | =C5*(1+E5)*F5 |
|
| I Labor total | =C5*G5 |
|
| J Line total | =H5+I5 |
Keep a separate Prices sheet with your current material costs and labor rates. Updating one price there updates every estimate line that uses it. For subcontracted work, enter the quote as a lump sum (quantity 1, unit LS) and note the quote number and date.
Step 3: Contingency, overhead and profit
- Contingency covers the unknowns you can’t see before opening walls: rot, outdated wiring, uneven floors. Remodels typically carry more contingency than new work.
- Overhead covers the costs of running your business that aren’t tied to one job: insurance, vehicles, office, software, estimating time.
- Profit is what is left for the business after all costs.
Formulas at the bottom of the sheet:
- Direct costs:
=SUM(J5:J60) - Contingency:
=DirectCosts*ContingencyPct - Overhead:
=(DirectCosts+Contingency)*OverheadPct - Profit:
=(DirectCosts+Contingency+Overhead)*ProfitPct - Total price: the sum of the four
Sales tax on materials, permit fees and licensing rules depend on your state and local jurisdiction, so set those lines up according to the rules that apply to you.
Worked example: small bathroom remodel (5′ × 8′)
| Line item | Quantity | Calculation | Total |
|---|---|---|---|
| Demolition and disposal | 16 h + dumpster | 16 × $55 + $450 | $1,330 |
| Plumbing (subcontractor quote) | 1 LS | Quote | $3,800 |
| Electrical (subcontractor quote) | 1 LS | Quote | $1,200 |
| Floor tile | 40 sq ft | 40 × ($6 material + $9 labor) | $600 |
| Shower wall tile | 90 sq ft | 90 × ($8 + $12) | $1,800 |
| Cement board and drywall | 120 sq ft + 12 h | 120 × $1.50 + 12 × $55 | $840 |
| Vanity and toilet, installed | 1 set + 6 h | $1,450 + 6 × $55 | $1,780 |
| Paint | 1 room + 8 h | $120 + 8 × $55 | $560 |
| Permit | 1 | Local fee (example) | $350 |
| Direct costs | $12,260.00 | ||
| Contingency 10% | $1,226.00 | ||
| Overhead 12% on costs + contingency | $1,618.32 | ||
| Profit 10% | $1,510.43 | ||
| Total estimate | $16,614.75 | ||
The waste allowance is folded into the material unit prices here to keep the example short; in your template, use the Waste % column. If the contingency isn’t needed, it either comes back to the client as a credit or stays with you, depending on how your contract is written, so state it clearly.
Markup vs margin: don’t mix them up
In the example, overhead and profit add $3,128.75 on top of $13,486 of costs including contingency. That is a markup of 23.2% on cost but a margin of 18.8% of the selling price. If you want a specific margin, divide instead of multiplying: =Cost/(1-TargetMargin). A 20% margin needs a 25% markup. The profit margin calculator in Excel explains the difference in detail.
Step 4: Turn the estimate into a proposal
- Create a client-facing sheet that shows groups and totals, not your unit costs and markup. Pull totals with
=SUMIFS(Estimate[Line total],Estimate[Group],A5)and spread overhead and profit proportionally. - List exclusions and assumptions (for example: “Fixtures selected by client; tile allowance $8/sq ft”). Allowances protect you when the client upgrades.
- Add a validity date, because material prices change.
- Define the payment schedule (deposit, progress payments, final) in line with local rules on deposits.
Step 5: Track actual costs against the estimate
Add Actual material, Actual labor and Variance columns. During the job, enter real costs from purchase orders and timesheets. After the job, compare: which line items ran over, and by how much? Feeding those lessons back into your Prices sheet is how estimates get more accurate over time. Use a purchase order template to keep material buying tied to the job, and a Gantt chart to schedule trades.
Common mistakes
- No waste factor on tile, lumber and drywall.
- Labor hours too optimistic: base them on past jobs, not best-case days.
- Forgetting general conditions: cleanup, protection, trips to the supplier, dumpster.
- Confusing markup and margin and earning less than planned.
- Old prices: re-check key materials before sending the quote.
Frequently asked questions
How accurate should an estimate be?
It depends on the stage. Early ballpark numbers can be wide; a bid you sign should be based on a full takeoff and current quotes. Contingency and clear exclusions cover the rest.
Should I show my markup to clients?
Most contractors present a total or group totals. If your contract is cost-plus, you’ll show costs and the agreed fee, so set up a separate version for that format.
Does this template work in Google Sheets?
Yes. SUM, SUMIFS and XLOOKUP work the same; use normal ranges instead of Excel table references.
More tools for builders are in Construction estimating.