Project Quote Calculator · Excel 365

What should we charge so this project still pays?

For small agencies, studios, consultancies and freelancers who quote projects or retainers from estimated hours.

Loaded rates, margin targets, scope lines and a client-ready quote.

project-quote-calculator-v1.2.0-worked-example.xlsx Demo data
Dashboard of the Project Quote Calculator showing key figures for a demo quote, a line repeating the Setup defaults, ten checks, a Do this next line, the price build-up, and charts of price points and scope hours.
  • Yellow cells: you type. Leave every other cell to the workbook.
Open full-size image of the Dashboard sheet Watch the walkthrough (1:19)

01What it answers

Three questions, answered for every quote

  1. What does an hour of each person really cost us?

    A loaded cost rate for every role, from pay, on-costs, leave and the share of time spent on client work, or from a contractor's hourly or day rate.

  2. What should we charge to hit our margin, and what does a discount cost us?

    The fee at your target margin, rounded the way you choose, with quoted margin and markup side by side and the contribution every discount gives away.

  3. What goes in front of the client?

    A one-page quote with your logo, scope, totals, terms and a validity date. Internal costs and margins never print.

02Demonstration

See the actual workbook

Walkthrough, 1:19: Start Here and Setup, one scope line goes in, then the price against the walk-away price, the checks and the page you send. Captioned, no sound needed.
Read what the video shows
  1. Price a project so it still pays. Fictional quote: 25,500.00; walk-away 19,436.68. On screen: the Dashboard's price build-up for a fictional quote. Price excl. tax, 25,500.00, and Walk-away price, 19,436.68, are outlined.
  2. Yellow cells: you type. Leave every other cell to the workbook. On screen: Start Here, row 3. The key sentence and the yellow swatch, "Yellow: you type here", are outlined. The About this file block below shows the version and the release date.
  3. White cells calculate. Grey cells hold lists and reference values. On screen: Start Here, row 3. The white swatch reads "White: calculated, don't type here" and the grey swatch reads "Grey: lists and reference values"; both are outlined.
  4. Start Here has nothing to type. Do this next says what to do. On screen: Start Here, row 5. Do this next is outlined. It reads "Open Setup: type your business name; it prints at the top of every quote."
  5. On Setup, type your business name. Setup complete then reads Yes. On screen: Setup, the Business name cell, empty, with the active-cell outline. Example Studio is typed. The view then moves down to Setup complete, which reads Yes and is outlined.
  6. Delivery cost: 13,919.00. Contribution: 11,581.00, an 83.2% markup. On screen: the Dashboard key figures for quote EX-Q0142, Harbor Retail, Website rebuild. Delivery cost, 13,919.00, and Contribution before overhead, 11,581.00, are outlined. Quote price excl. tax, 25,500.00, quoted margin, 45.4%, and markup on delivery cost, 83.2%, are shown beside them.
  7. On Team Rates, type each role's pay, on-costs, leave and delivery share. On screen: Team Rates, five fictional roles. The Strategist row is outlined: annual pay 76,000.00, employer on-costs 7.65%, other annual on-costs 8,426.00, paid hours 2,080.0, leave hours 200.0 and delivery share 60.0%.
  8. The Strategist's cost: 80.00 USD per delivery hour. On screen: the view moves to the calculated columns for the same roles. The Strategist's annual cost is 90,240.00, delivery hours per year 1,128.0 and cost per paid hour 48.00. The role and the loaded cost rate, 80.00, are outlined.
  9. On Scope Lines, add one row per deliverable, typing left to right. On screen: Scope Lines, with EX-1 to EX-6 shown and the empty row 11 outlined. Row 11 is typed one cell at a time: EX-4, Project management, Weekly check-ins and launch coordination, Strategist, then 14.0 hours. The cursor moves one cell right after each entry.
  10. The line costs 1,120.00 USD: 14.0 hours at the Strategist's 80.00. On screen: the view moves to row 11's calculated columns. Cost rate 1 is 80.00, line hours 14.0 and labor cost 1,120.00, which are outlined.
  11. Fee at the 45.0% target: 25,307.27. Rounded up to the next 500: 25,500.00. On screen: the price build-up. Delivery cost 13,919.00, target margin applied 45.0%, equivalent markup 81.8%, fee at target margin before rounding 25,307.27 (outlined), fee as quoted 25,500.00 and rounding added 192.73.
  12. The walk-away price is 19,436.68; this quote clears it by 6,063.32. On screen: further down the Dashboard, overhead share for these hours, 5,517.68, and walk-away price, 19,436.68, are outlined; then headroom over walk-away price, 6,063.32, is outlined.
  13. Ten checks: nine read OK. Sample data is flagged until you clear it. On screen: the Dashboard checks. Checks 1 to 9 read OK. Check 10, Sample data, has a count of 12 and reads SAMPLE, and Checks failing reads 1.
  14. The Quote sheet is the page you send. Costs and margins never print. On screen: the Quote sheet as it prints: a SAMPLE banner, Harbor Retail as the client, the six deliverables EX-1 to EX-6 with their descriptions, and Fee for the scope above, 25,500.00, and Total, 25,500.00, outlined. No cost or margin appears on the sheet.
  15. Clear the sample with these steps, and the status then reads OK. On screen: Start Here, the steps to clear the sample data, with steps 1 and 2 outlined. Choose MV_Clear_ScopeLines in the Name Box and press Delete, then repeat for MV_Clear_QuoteDetails and MV_Clear_TeamRates. Then the status in Start Here row 3 reads OK; Setup, with the typed business name, is kept.
  16. The Guide explains every input and check. Support replies within 1 business day. On screen: the Guide sheet, with the five setup steps and the time each takes; then Start Here, the Support rows only: the Email row is outlined: [email protected], and "You get a reply within 1 business day (Monday to Friday, Australian Eastern time)."
  17. See every sheet and what is tested at metricvalley.com. On screen: the end card. Project Quote Calculator, v1.1.0, Excel 365, Google Sheets edition when it ships, metricvalley.com, above the Dashboard key figures for EX-Q0142: 25,500.00, 13,919.00, 11,581.00, 45.4%, 83.2% and 6,063.32. Every sheet shown is the v1.1.0 worked-example file in Excel 365, with fictional data. One scope line was cleared before this video, then typed back in. The business name was typed on Setup for the recording.

Watch it on its own page, with chapters

project-quote-calculator-v1.2.0-worked-example.xlsx Demo data
Printed one-page demo quote with a logo area, client details, six deliverables, the total and a terms block.

Quote. The page you send: your logo and details, the scope, totals, terms and validity date, on one printed page.

03What's inside

Eight sheets, one job

Demo data

Start Here

Setup in 5 steps: about 10 minutes, plus about 1 minute per role and per scope line.

Its Do this next line says where to go. The map lists every sheet in tab order, with what it is for.

Demo data

Setup

One quote can use its own target, contingency, price rounding and validity: set those on Quote Details.

Clearing the sample data leaves these settings as they are, the overhead figures too: replace them with your own.

Demo data

Team rates

Employees, owners and contractors (hourly or day rate).

Shows a blended team rate for comparison and flags a role recorded two ways.

Demo data

Scope lines

Up to 30 lines. A line with a missing role or rate is marked Review and the quote shows DRAFT until it is fixed.

Demo data

Dashboard

Fixed fee, time and materials, or monthly retainer.

Ten checks, and a line that repeats the Setup defaults, so a print shows what the figures start from.

Ready-made rows to paste into the Client Profitability Tracker.

A Do this next line gives one next step for the quote as it stands.

Demo data

Quote

No cost, margin or internal note ever appears on it.

Demo data

Guide

Read it in the workbook or print it.

  • Quote Details: The client, project, quote number, date, quote type and terms for this quote.

Exactly what's in the download

One ZIP file (about 297 KB), delivered by Payhip straight after payment.

FileWhat it isSize
xlsxproject-quote-calculator-v1.2.0-blank.xlsx The workbook for your own quotes 149 KB
xlsxproject-quote-calculator-v1.2.0-worked-example.xlsx The same workbook with a demo team and quote 153 KB
htmlSTART-HERE.html Open this first: what each file is and where to begin 10 KB
mdquick-start.md Setup steps, a first quote, reading the Dashboard and printing the quote 9 KB
mdmetric-dictionary.md Every field and calculation defined 41 KB
mdsupport-and-compatibility.md What is tested, what isn't, and how to ask for help 5 KB
mdlicense.md The license terms 3 KB
mdrelease-notes-v1.2.0.md What is in this version 14 KB
mdmoney-back-guarantee.md The 30-day money-back guarantee 1 KB
txtMANIFEST-project-quote-calculator-v1.2.0.sha256 Checksums to verify your download 1 KB

04Setup

Ready in about 10 minutes (estimate)

  1. Save a master copy and fill in Setup your business details, currency and target margin.

    About 4 minutes.
  2. Add your team rates one row per role or person; the loaded cost per delivery hour is worked out for you.

    About 1 minute per role.
  3. Quote the project fill in the quote details and one row per deliverable, check the Dashboard, then print the Quote.

    About 1 minute per line.

Estimate: a first quote with 3 roles and 6 deliverables takes about 15 minutes, including setup.

05Worked example

A website quote at a fictional studio

Fictional example

Northfield Studio is a fictional design studio quoting a website rebuild. Its strategist costs US$80 a delivery hour, its designer US$66 and its contract developer US$75. The scope comes to 156 hours and US$11,290 of labor, plus 10% contingency and US$1,500 of copywriting and stock images. At a 45% target margin the fee works out at US$25,307, which the studio rounds up to US$25,500: a quoted margin of 45.4%, or an 83.2% markup on cost. A 10% discount would give away US$2,550, 22% of the project's contribution.

Delivery cost (fictional)
Labor, 156 hoursUS$11,290
Contingency, 10% of laborUS$1,129
Direct costsUS$1,500
Delivery costUS$13,919
Price (fictional)
Fee at 45% marginUS$25,307
Rounded up toUS$25,500
Contribution before overheadUS$11,581
Quoted margin45.4%

Northfield Studio is not a real business. The figures follow the example in our pricing guide, are illustrative and are not a customer result.

06Fit

Is it right for you?

Good fit

  • Small agencies, studios and consultancies that quote projects from estimated hours
  • Teams that mix staff, owner and contractor time on the same project
  • Anyone who wants to see what a discount costs before agreeing to it
  • Businesses quoting clients abroad in a second currency

Not a fit

  • You need proposals with images, e-signatures, invoicing or a CRM
  • You need to track actual hours against the quote while the project runs; the Client Profitability Tracker does that
  • You want to compare several quotes, options or versions in one file
  • You need tax worked out beyond one rate on the quote total, or tax advice

Known limitations

  1. One quote per file. Save a copy of your master file for each quote.
  2. Up to 30 scope lines with up to three roles each, and 40 roles. The printed quote is one page.
  3. Costs are in one business currency. A quote can use a second currency at one exchange rate you type in. There is no live feed.
  4. Contribution is before overhead. It is not net profit or cash flow. Overhead is used only for the walk-away price and a suggested margin.
  5. The tax line is one label and one rate on the total. It is not tax advice.
  6. Tested in Excel 365 for Windows desktop. Excel for Mac, Excel for the web and Google Sheets are not yet tested.
  7. Excel mobile and the Google Sheets mobile apps are for viewing only, not data entry.
  8. Google Sheets has no saved print area: select MV_QuotePrint and print the selection, as the Guide shows.

07Tested on

Where it has been tested

Each release is tested against written checks, and the results are listed here and on the compatibility page. "Not yet tested" means exactly that: it may work, but we haven't confirmed it.

Latest test run

38/42 checks passed, 4 not yet run
Excel 365, Windows desktop
  • Workbook version1.2.0
  • Last testedNov 7, 2026
  • Excel 365, Mac desktopNot yet tested
  • Excel for the webNot yet tested
  • Google Sheets (native edition)Not yet tested
  • Excel mobile (iOS, Android)Not supported

What the cases cover

  • 44 of 46 acceptance cases passed in Excel 365 for Windows, including fixed fee, time and materials and retainer quotes
  • Margin and markup targets, rounding up and to nearest, percent and amount discounts
  • A second quote currency, an optional tax line and pass-through costs at cost or with markup
  • Printed quote checked on Letter and A4 for one page and for internal figures
  • The 1.0.1 worked example's settings and rows entered into the 1.1.0 blank file gave the same figures: 2,169 values compared, 0 mismatches.
  • The 1.1.0 worked example's settings and rows entered into the 1.2.0 blank file gave the same figures: 2,171 values compared, 0 mismatches.
Environment Status Checks Version and build Last tested Notes
Excel 365, Windows desktop Tested with notes 38/42 passed, 4 not yet run Workbook 1.2.0 · Excel 16.0.20527.20150 · Windows Server 2025 Standard 10.0.26100 Nov 7, 2026 Automated run on temporary copies: 44 of 46 acceptance cases passed in Excel; the others need Google Sheets or a person at the screen. Not run: 4 checks that need the Excel interface, a system setting or a person.
Excel 365, Mac desktop Not yet tested — — — Not yet tested.
Excel for the web Not yet tested — — — Not yet tested.
Google Sheets (native edition) Not yet tested — — — Not yet tested. The Google Sheets edition is free for every buyer when it ships.
Excel mobile (iOS, Android) Not supported — — — Viewing only; not tested for data entry.
Google Sheets mobile apps Not supported — — — Viewing only; not tested for data entry.
Google Sheets (importing the .xlsx) Not supported — — — Use the native Google Sheets edition.
LibreOffice Calc Not yet tested — — — —
Apple Numbers Not yet tested — — — —

What changed in 1.2.0

Nov 7, 2026

A free update for every buyer, delivered through Payhip. The Dashboard has its own Do this next line. The inputs, names and results are the same.

  • The Dashboard has its own Do this next line: one next step for the file as it stands.
  • Excel 365, Windows desktop: Tested with notes, 38 of 42 checks passed, 4 not yet run, workbook 1.2.0, Excel 16.0.20527.20150, tested Nov 7, 2026. Excel for Mac, Excel for the web and Google Sheets: not yet tested.

Inputs affected: No. Nothing you type moved: every setting, name, table and column is where it was.

08What you get

What you get

Each purchase includes the files above, updates, email support and a license for your business.

  • Workbook: 8 sheets, no macros, no external connections; tested in Excel 365 for Windows desktop. The Google Sheets edition is free for every buyer when it ships.
  • Updates: 1.x updates are free and are delivered through Payhip.
  • License: Single-business, for one business and all its staff. Agency/Team is store-wide: the tracker's US$99 Agency/Team license, or the bundle's US$129 Agency/Team tier, covers this tool too, for up to 5 client businesses.
  • Support: Email support; we reply within 1 business day (Monday to Friday, Australian Eastern time).
  • Guide: a Guide sheet inside the workbook, plus a setup guide on this site.
  • Google Sheets: the Google Sheets edition is included free for every buyer when it ships.

09License

License

Two licenses. Both let you edit the workbook, keep backups and share the reports it produces. Neither lets you pass the editable file to another business. Tracking your own clients is exactly what Single-business is for. You need Agency/Team only if you keep a working copy for another business's own figures.

Single-business

included at US$29

For one business or sole trader, and everyone who works in it: staff and contractors.

Allowed
Edit and extend the workbook, keep backups, share reports and results with your team, clients, advisers and board.
Not allowed
Using it for a second business, giving an editable copy to a client or anyone outside the business, reselling or posting it online.
Buy for US$29

30-day money-back guarantee. No questions asked.

Agency/Team

Store-wide

For an agency and up to 5 client businesses it manages, and everyone who works in the agency. Store-wide: it covers every Metricvalley business template your business owns.

Agency/Team is store-wide: the Client Profitability Tracker's US$99 Agency/Team license, or the Agency Operating Bundle's US$129 Agency/Team tier, covers every Metricvalley business template your business owns, including this calculator, for up to 5 client businesses. This calculator has no Agency/Team price of its own.

Allowed
Everything in Single-business, plus separate working copies for up to 5 client businesses you manage, as long as you keep the file and send them the results.
Not allowed
Giving clients or anyone outside your agency an editable copy, reselling, or including it in a product, course or template library.
See Agency/Team on the tracker page

The full terms are in the download and shown before checkout. Nothing in them limits rights you have under consumer law. Read the full license terms.

10Guarantee

30-day money-back guarantee

If the calculator isn't right for your business, email [email protected] within 30 days of purchase with your order number. You'll get a full refund to your original payment method. No questions asked and no forms to fill in; we only ask that you delete your copies. This guarantee is in addition to your rights under the Australian Consumer Law and any other consumer law that applies to you.

11FAQ

Questions before you buy

I bought version 1.0.0 or 1.0.1. What changed in 1.1.0?

It is a free update, delivered through Payhip. The settings moved from Start Here to a new Setup sheet, with the same names; each quote's own settings stay on Quote Details. Formulas, names and results are the same, so your team rates, quote details and scope lines paste straight in. Your 1.0.1 master copy and saved quotes keep working, so you do not have to switch. The setup guide lists where each setting went.

What is the difference between margin and markup here?

Margin is contribution as a share of the price; markup is the same amount as a share of cost. You enter your target either way, and the Dashboard shows both. A 45% margin is an 81.8% markup.

Does it include overhead in the hourly rate?

No. Rates cover pay, on-costs and non-delivery time, as in our guide. Overhead is covered by your margin. If you enter your annual overhead, the workbook suggests a target margin and shows a walk-away price for each quote.

Can it quote time and materials or a retainer?

Yes. Choose fixed fee, time and materials (hourly rates and an estimate) or a monthly retainer (monthly fee, included hours and an extra-hour rate).

Does it add sales tax, GST or VAT?

Only if you ask it to. You can set one tax label and rate and switch the tax line on for a quote. It is not tax advice.

How does it work with the Client Profitability Tracker?

The Dashboard lays the quote out as rows in the tracker's Work Log format. Copy them and paste values into the tracker. The two files are never linked.

Can my whole team use it?

Yes, if they all work for the one business that bought it. Agencies that keep working copies for client businesses (up to 5) need Agency/Team, which is store-wide: the Client Profitability Tracker's US$99 Agency/Team license, or the Agency Operating Bundle's US$129 Agency/Team tier, covers every Metricvalley business template you own, including this one. This tool has no Agency/Team price of its own.

Is the Google Sheets edition included?

Yes. The Google Sheets edition is free for every buyer when it ships, delivered through Payhip. Do not import the .xlsx files into Google Sheets.

What if it isn't right for us?

Every purchase has a 30-day money-back guarantee. Email support within 30 days with your Payhip order number. You get a full refund to your original payment method.

What happens after I pay?

Checkout is handled by Payhip. You get a download link on the confirmation page and by email: one ZIP file with a blank workbook, a filled-in example workbook and eight short files, including START-HERE.html, the license terms and a checksum manifest.

Does it work on a Mac?

It hasn't been tested in Excel for Mac yet, so we don't say it works there. The current version is tested in Excel 365 for Windows desktop, and it uses no macros. The compatibility page lists every environment and its status. If you buy it for a Mac and it doesn't work as described, the 30-day money-back guarantee gives you a full refund.

More answers in the setup guide and the help center.

Project Quote Calculator · US$2930-day money-back guarantee. No questions asked.

Buy for US$29