How are overheads and estimated profit calculated in the estimate?

Overheads and estimated profit are calculated as percentages of the labor cost, and the percentages are set on the "Settings" sheet. The default values are placeholders: set them according to your contract or methodology.

Can I use it as a bill of quantities?

Yes. The "Estimate" sheet together with "Print Estimate" gives a bill of quantities and costs with sections and subtotals, and "Materials List" gives a purchasing summary.

Yes, in three modes: no VAT, VAT added on top, and VAT included. The rate is editable; please check the current value.

Is this an official estimate?

No. It is a simplified working form for calculation and approval and does not replace official estimating documents.

No, only ordinary Excel 2007 formulas; the file also opens in LibreOffice.

← All templates

Renovation Estimate Template — Excel Bill of Quantities and Materials

Renovation estimate with a rate catalog, sections by room, overheads, profit, VAT, a materials list, a printable estimate and a completion certificate.

390 ₽

≈ 4 USD

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

An Excel estimate for renovating an office, a room or a small site: you keep a catalog of your own rates, pick items from a drop-down list, enter quantities, and the spreadsheet calculates labor and material costs by row and section, overheads, estimated profit, contingency and VAT. The result is a bill of quantities, a materials list for purchasing, a printable estimate and a completion certificate.

What is inside

"Settings": site, client, contractor, VAT mode (no VAT, on top, included), percentages for overheads, profit and contingency, rounding, list of sections.
"Rate Catalog": up to 300 work items and materials: code, name, unit, labor price, material price, waste allowance.
"Estimate": up to 400 rows: section, item from the list, quantity, coefficient, labor, materials and row total, subtotals by section, row check.
"Materials List": what to buy and in what quantity, with waste allowance and amount.
"Summary": totals by section, overheads, profit, contingency, VAT, grand total, section shares on a chart.
"Print Estimate": a simplified print form with sections, subtotals and signature blocks.
"Completion Certificate": a certificate based on completed quantities, with overheads, profit and VAT recalculated automatically.

Who it is for

Facility managers, site engineers and estimators in small organizations, contractors and renovation crews, property owners, and anyone who needs a clear renovation estimate in Excel.

What you get

The download includes a blank template and a filled-in sample estimate for renovating an office, with fictitious data and a few "problem" rows to test the checks. The spreadsheet uses ordinary formulas, no macros.

Compatibility

Excel 2007 and later, LibreOffice. No macros. The file is in English. The overhead and profit percentages and the VAT rate are default placeholder values: set them according to your contract and check the current rates. The forms are simplified working forms, not official documents.

Questions and answers

How are overheads and estimated profit calculated in the estimate?: Overheads and estimated profit are calculated as percentages of the labor cost, and the percentages are set on the "Settings" sheet. The default values are placeholders: set them according to your contract or methodology.
Can I use it as a bill of quantities?: Yes. The "Estimate" sheet together with "Print Estimate" gives a bill of quantities and costs with sections and subtotals, and "Materials List" gives a purchasing summary.
Is VAT supported?: Yes, in three modes: no VAT, VAT added on top, and VAT included. The rate is editable; please check the current value.
Is this an official estimate?: No. It is a simplified working form for calculation and approval and does not replace official estimating documents.
Are there macros?: No, only ordinary Excel 2007 formulas; the file also opens in LibreOffice.