Freelance Hourly Rate Calculator (Free Spreadsheet)

Most freelancers set their rate by feel: a little above the last job’s salary math, a little below what feels embarrassing to say out loud. The result is almost always the same — a rate that looks fine per hour and quietly starves you per year, because it ignores the three taxes of self-employment: unbillable time, unpaid weeks, and business costs.

This calculator works backwards from the life you want instead. Four inputs, and the sheet — formulas verified against the worked example in the file — tells you the rate that actually funds it.

The worked example, and why the number surprises people

The example freelancer wants $70,000/year of income, carries $6,500/year of business costs (software, equipment, insurance, accounting), takes 6 weeks off (vacation plus sick days plus the slow weeks nobody plans but everybody has), and bills 24 hours per week.

That last number is where honesty matters most. A 40-hour freelance week does not contain 40 billable hours — it contains proposals, invoicing, email, calls that don’t convert, and learning. Twenty to twenty-five billable hours in a full-time week is the widely observed reality; 24 is not pessimism.

The math runs: 46 working weeks × 24 hours = 1,104 billable hours. Revenue needed = $70,000 + $6,500 = $76,500. Minimum rate = $70/hour. And the recommended rate, with a 20% buffer, is $84/hour — call it $85, or a $630 day rate.

An $84/hour rate to earn a $70k income shocks people who anchor on salary math ($70k ÷ 2,080 hours = “$34/hour”). The gap isn’t greed; it’s the invisible 40% of freelance life that salary math doesn’t see.

What the 20% buffer is actually for

The minimum rate assumes every planned billable hour gets billed and paid. Reality leaks: a project cancels, a client pays 45 days late, a gap opens between engagements, and some hours get eaten by scope creep you don’t invoice. The buffer absorbs those leaks. It also fixes a negotiation problem — if your opening rate is your minimum, every discount a client negotiates comes directly out of your income. Open at the buffered rate and the negotiation has somewhere to go that isn’t your rent.

One thing the calculator deliberately does not model: income tax. Tax situations vary too much by country, state, and structure for one cell to be honest. Treat the target-income input as your pre-tax income goal — the same way a salary is quoted — and the output rates stay comparable to employment offers. (Not financial or tax advice; a professional can tune this to your situation.)

Using the result in the real world

Check it against your market, not your fear. If the sheet says $84 and your niche tops out at $50, the calculator has still done its job — it’s told you that at $50 and 24 billable hours you’re building a $40k year, and the fix is either positioning (raise the market you’re in) or hours, not wishing.

Recompute twice a year. Costs drift, your speed improves, your off-weeks change. Ten seconds of new inputs, new rate.

Quote projects from the day rate. Estimate days, multiply by the $630, then quote a fixed price. Clients prefer the certainty, and you keep the upside of working faster than estimated.

Pairs directly with the freelance invoice template — the calculator sets the number, the invoice collects it — and the mileage log for the cost side.

Using it in Google Sheets

1. Google Sheets → blank sheet → File → Import → Upload → choose the file → Replace spreadsheet.
2. Only the four green cells are inputs; everything below computes.

Frequently asked questions

I freelance part-time — does the math change? No, just the inputs: 10 billable hours a week and 2 weeks off works the same way. Part-timers are usually more under-priced because they anchor on their day job’s hourly wage.

Should costs include health insurance? If you pay it because you’re self-employed, yes — that’s a real cost of the freelance structure, and pricing that ignores it subsidizes your clients.

Is it free? Free for personal and commercial use, no signup. Problem with the math? Tell us — we re-verify against the example and fix it.