Home / Guides / Project fee calculator
Guide · Pricing · Project fee
Project fee calculator in Excel
A fixed project fee should not be a vibe check. Start from your hourly floor, multiply by a realistic hour estimate, then add contingency so scope creep does not erase your take-home — then put that locked number on the invoice.
May earn commissions. SoloDesk may earn a commission if you buy through affiliate links on this page. Recommendations are based on what we think fits the use case. See our affiliate disclosure.
Free client rate calculator (Yellowcell)
One sheet: yellow inputs for take-home, tax cushion, and billable time; gray formulas for hourly floor, day / half-day rate, and project fee. No macros. Soft path into the invoice kit when you are ready to bill.
Free client rate calculator Gumroad free download All free Yellowcell downloads
The core formula
Project fee = hourly floor × estimated hours × (1 + contingency %).
Everything hangs off the same hourly floor you use for day rates and hourly quotes, so a fixed-fee PDF does not undercut your other pricing.
Yellow inputs that matter
| Input (yellow) | Typical use |
|---|---|
| Hourly floor | From take-home, tax cushion, and billable weeks/hours — do not invent it per client |
| Estimated project hours | Optimistic delivery time plus unpaid admin / revisions you already expect |
| Contingency % | Often 15–25% for fuzzy creative scopes; less when the brief is locked |
| Optional fixed add-ons | Licensing, stock, travel, or rush — keep them as separate line items when possible |
Gray cells compute the fee. Keep formulas visible so you can defend the number if a client asks “why $X?”
When a project fee beats pure hourly
- Clients want a clear amount due before work starts
- Scope is stable enough to estimate hours without weekly change orders
- You want to reward efficiency instead of billing more for slower days
- The deliverable is a package (site redesign, brand kit, launch campaign) rather than open-ended support
Stay hourly when the brief is vague and revisions are unlimited — but still derive the rate from the same floor so your quotes stay consistent.
Contingency traps
- Quoting best-case hours with 0% buffer, then eating every revision
- Hiding contingency inside a round number with no note of what it covers
- Using “what the market might pay” with no link back to your floor rate
- Leaving “TBD” or “estimate only” on the client PDF after the calculator already produced a fee
From calculator to invoice
The calculator is for you. The client sees an invoice: deliverable name, quantity 1 (or milestone lines), fixed fee, tax if any, amount due, due date. Copy the locked project fee into your invoice workbook so the quote and the bill match.
Related SoloDesk guides
- Client rate calculator in Excel
- Freelance day rate calculator in Excel
- Hourly rate calculator Excel vs pricing apps
- Name-your-price invoicing in Excel
Free rate calculator + invoice kit
Start with Yellowcell’s free hourly / day / project rate calculator (Netlify page or Gumroad). When the project fee is locked, Sole Ledger puts a matching amount due on the invoice — expense log and 2026 mileage included, yellow inputs, no macros.
Free client rate calculator Gumroad free download Payhip (free) Buy invoice kit