Shop / Guides / Freelance hourly rate calculator
Guide · Freelancer pricing
Freelance hourly rate calculator in Excel
Guessing an hourly rate from what “people charge” is how freelancers underbill for months. A better floor starts from the take-home you need, a tax cushion, and the billable hours you actually sell — then Excel does the division. Yellowcell’s free one-sheet calculator is built for that math.
The three yellow inputs that matter
- Target take-home — what you want to keep after business costs (annual or monthly; stay consistent)
- Tax cushion % — a rough buffer for income and self-employment tax (illustrative only; confirm with a preparer — not tax advice)
- Billable hours — weeks per year × hours per week you can honestly sell (admin, sales, and sick days do not count)
Gray cells turn those into required revenue and an hourly floor. Quotes below that floor quietly steal from take-home or unpaid overhead.
Simple Excel layout (yellow in, gray out)
| Cell role | Example |
|---|---|
| Yellow — target take-home | $72,000 / year |
| Yellow — tax cushion | 30% |
| Yellow — billable weeks | 46 |
| Yellow — billable hours / week | 25 |
| Gray — required revenue | take-home ÷ (1 − cushion) |
| Gray — hourly floor | required revenue ÷ (weeks × hours) |
Numbers above are examples only. Replace every yellow cell with your own before you quote a client.
Why billable hours beat “40 × 52”
- Unpaid proposals, bookkeeping, and tool setup are real hours that are not on the invoice
- Vacations, slow seasons, and client gaps shrink the year more than people plan for
- A high sticker rate with few billable weeks still misses take-home
If your floor looks “too high,” the fix is usually more billable work or lower take-home targets — not pretending admin is free.
From floor to day and project fees
Once the hourly floor is locked, the same sheet can multiply by day length and estimated project hours (plus a contingency %). That keeps day rates and fixed project quotes from contradicting each other when a client asks for both.
Put the rate on an invoice
The calculator is for you. The client sees a clean invoice: description, hours or units, rate, tax if any, amount due, and payment terms. Copy the locked hourly (or day / project) number into your invoice workbook so the quote and the bill match.