Stop Guessing Your Freelance Rate — Use This Simple Formula (Free Google Sheets Template)

Are you a freelancer who has no idea what to charge? You're not alone.

Most independents pick a number out of thin air — and end up either underpaid or pricing themselves out of work. The truth is, your hourly rate isn't an opinion. It's math.

In this post, I'll show you a simple formula any freelancer can use to land on a profitable minimum rate — and I've built a free Google Sheets template to do it for you in 5 clicks.

The 7 numbers you need

You only need 7 inputs:

1. Your desired annual salary (after tax)
2. Your tax rate (self-employment + income)
3. Business overhead per year
4. Working weeks per year
5. Billable hours per week
6. Desired profit margin
7. Emergency buffer

Let me walk through an example.

Example: Sarah, freelance designer

• Desired salary: $80,000
• Tax rate: 30%
• Overhead: $5,000
• Working weeks: 48
• Billable hours/week: 25
• Profit margin: 20%
• Buffer: 10%

Step 1: Gross income needed
Gross = 80,000 / (1 - 0.30) = $114,285 + $5,000 = $119,285

Step 2: Total billable hours
48 weeks × 25 hours = 1,200 hours

Step 3: Base rate
$119,285 / 1,200 = $99.40/hr

Step 4: Add profit margin
$99.40 × 1.20 = $119.28/hr

Step 5: Add buffer
$119.28 × 1.10 = $131.21/hr

Sarah's minimum rate: $131/hr

That's more than she expected. But now she knows exactly where the number comes from — and she can negotiate with confidence.

Why a spreadsheet beats gut feel

When you see the math, you realize:

• A higher tax bracket means you need to charge more — not less
• Non-billable time is your biggest hidden cost
• Profit margin isn't greedy — it's survival

I wrapped all this logic into a Google Sheets template that auto-calculates your rate. It also converts to daily and weekly rates, and lets you model part-time vs full-time income.

👇 Get the template here (free):

Freelance Rate Calculator — Google Sheets

No email required. No upsell. Just a clean, transparent calculator you can use today.

Final thought

Freelancing is a business. Businesses need pricing models. Stop charging what you think you're worth — start charging what the numbers say you need.

Drop a comment if you have questions. I read every one.