How to Calculate Your Freelance Hourly Rate in Excel
You're not bad at freelancing. You're bad at the maths behind it. Here's how to fix that — one formula at a time.
To calculate your freelance hourly rate in Excel, divide your required annual income (after expenses and taxes) by your total billable hours for the year. Add a buffer for unpaid admin, sick days, and business costs. The formula is:
The Sunday Night Panic That Turns Into a Monday Morning Crisis
Meet Sipho. He's a freelance graphic designer in Cape Town. He's good. Clients love him. His Instagram looks sorted. But every third Monday he does the same thing: opens his bank account, stares at the number, and wonders what went wrong.
He's been charging R450 an hour because a friend told him that's the going rate. He's been busy for three months straight. He's tired. And he's somehow still short on rent.
The problem isn't his work. It's his rate. And his rate is wrong because he guessed it.
This is Sipho's story, but it's also Priya's story in London, Marcus's story in Austin, and Adaeze's story in Lagos. The currency changes. The Sunday night panic does not.
Your rate isn't what the market will bear. It's what your life actually costs — plus tax, plus the time nobody pays you for.
This guide shows you how to calculate the real number. In Excel. With formulas you can understand, not copy-paste from a Reddit thread and hope for the best.
Why Most Freelancers Get Their Rate Wrong
The most common method for setting a freelance hourly rate is one of the following:
Method A: Ask another freelancer what they charge, then round it up slightly so you don't look cheap.
Method B: Take your last salary, divide by 2,080 working hours, and double it. Call that your rate.
Method C: Pick a number that feels professional. R500 sounds more legit than R499, right?
None of these are wrong exactly. They're just not right. They don't account for the hours you work that nobody pays for. They don't account for tax. They don't account for the month when three clients are on leave and you have exactly zero invoices going out.
A rate built on vibes is a rate that slowly eats your savings while you convince yourself you're just in a slow patch.
The key insight: As a freelancer, you are not comparing yourself to an employee earning a salary. You are running a business that sells one product — your time — and that business has costs, gaps, and tax obligations that an employment contract used to absorb invisibly.
The Five Numbers You Need Before You Open Excel
Before touching a formula, gather these five inputs. You can get them from your bank statements, your last tax return, or — honestly — an educated guess that you'll tighten up over time.
Your Annual Income Target
What do you need to take home this year, after tax? Not what you'd love. Not what you'd be embarrassed to admit. What does your life actually cost — rent, groceries, medical, transport, savings, the occasional weekend away — and what does that number add up to over 12 months? Write it down.
Your Annual Business Expenses
Software subscriptions. Adobe CC. A Canva Pro account. Laptop repayments. Accounting fees. A co-working space. Internet at home. These are costs the business carries — not you personally — and they need to be baked into your rate. Add them up for a full year.
Your Tax Rate (or a Safe Estimate)
If you're in South Africa, provisional tax means you pay SARS twice a year — and if you've never done this before, the bill arrives like a surprise party nobody wanted. A conservative buffer for many freelancers earning in the R200,000–R500,000 range is around 25–30%. Use your actual marginal rate if you know it. Use 30% if you don't and sort it out with an accountant later.
Your Total Working Weeks Per Year
Start with 52 weeks. Subtract your planned leave (let's say 3 weeks). Subtract public holidays (roughly 1.5 weeks in South Africa). Subtract a realistic sick day allowance (1 week). That leaves you with approximately 46–47 working weeks per year. Use 46 to be conservative.
Your Weekly Billable Hours
This is the uncomfortable one. You work 40 hours a week. But how many of those hours are actually billed to clients? Proposals, emails, admin, invoicing, chasing payments, social media, professional development — none of that is billable. For most freelancers, 4–6 billable hours per day is realistic. Let's say 25 hours a week to start. You can adjust.
Building the Formula in Excel, Step by Step
Open a blank Excel workbook. Set it up with two columns: a label column on the left and an input/formula column on the right. Here's exactly what to put where.
Sheet Setup: Your Rate Calculator
| Cell (Column A) | Label | Cell (Column B) | Value / Formula |
|---|---|---|---|
| A2 | Annual Take-Home Target | B2 | R 360,000 (your number) |
| A3 | Annual Business Expenses | B3 | R 36,000 (your number) |
| A4 | Tax Rate (%) | B4 | 30% |
| A5 | Working Weeks Per Year | B5 | 46 |
| A6 | Billable Hours Per Week | B6 | 25 |
| A8 | Total Billable Hours/Year | B8 | =B5*B6 |
| A9 | Gross Revenue Required | B9 | =(B2+B3)/(1-B4) |
| A10 | Minimum Hourly Rate | B10 | =B9/B8 |
Breaking Down the Key Formula
The formula in B9 is doing the heavy lifting. It works backwards from your take-home target:
Gross Revenue Required = (Take-Home + Expenses) ÷ (1 - Tax Rate)
= (R360,000 + R36,000) ÷ (1 - 0.30)
= R396,000 ÷ 0.70
= R565,714
That's the revenue your business needs to generate before tax and expenses eat their share. Then you divide that by your billable hours:
Minimum Hourly Rate = R565,714 ÷ 1,150 hours = R492/hour
Sipho was charging R450. He needed R492 at a minimum. That's a R42 gap. Not a lot per hour — but across 1,150 billable hours, that's R48,300 he left on the table over the year.
The Sunday panic makes a lot more sense now.
Pro tip: Once B10 gives you your minimum rate, add 15–20% on top before you quote a client. Your minimum rate is survival. Your market rate is sustainability. Price for sustainability.
Skip the Setup. Use Our Freelance Rate Calculator.
The Excel template does all of this automatically — multi-currency support, tax rate inputs, a built-in scenario planner, and a 12-month earnings tracker. Drop in your numbers. Get your rate. Done.
Browse Freelance Templates → Instant download · Works in Excel and Google SheetsThe Variables That Actually Change Your Rate
The power of building this in Excel — rather than using an online calculator — is that you can change one variable and watch every downstream number update in real time. Here's what's worth testing:
What Happens If You Reduce Billable Hours?
Let's say you're more honest with yourself and change B6 from 25 to 20 hours per week. Your total billable hours drop from 1,150 to 920. Your minimum rate jumps from R492 to R615/hour. The same income target — just fewer hours sold means each hour has to carry more weight.
Most freelancers are shocked by this. They assume more hours = more money. But fewer hours, properly priced, is often better for both income and sanity.
What Happens If You Take More Leave?
Reduce working weeks from 46 to 40 — a proper six weeks off, which is not unreasonable — and your billable hours drop from 1,150 to 1,000. Your rate needs to climb to R566/hour minimum. Still manageable. But you need to know this before you book the flights to Lisbon, not after.
What Happens When You Scale?
Now flip it the other way. What if you could charge R700/hour and work 20 hours a week? Drop those numbers in and you'll see your gross revenue potential: R700 × 20 × 46 = R644,000. After tax and expenses, your take-home would be approximately R416,000. That's not a fantasy number. That's a rate conversation you haven't been having because you didn't know this was achievable.
The formula doesn't lie to you. It just shows you which number you've been avoiding.
Four Common Mistakes to Avoid
1. Forgetting About Slow Months
January and December are graveyard months for most freelancers. Clients are on leave. Decisions are deferred. Your 46-week assumption already accounts for some of this, but if your industry has longer slow seasons, reduce that number further. Don't price for a world where every week is a full week.
2. Not Counting Client-Chasing Time
You know that client who takes 14 days to respond to a 3-line email, then marks your invoice as "approved in principle" for another 30 days? That time costs you. It's not billable. And it's not zero. Account for it by keeping your billable hours estimate conservative.
3. Using Pre-Tax Salary as the Starting Point
If you previously earned R40,000 per month as an employee, your take-home after tax was probably around R29,000–R32,000 depending on your situation. Use your take-home as the baseline for B2 — not your gross salary. Otherwise, you'll double-count your tax burden and your rate will be inaccurate from the first input.
4. Never Reviewing the Rate
A rate you set in January 2024 is not necessarily the right rate in June 2026. Inflation happened. Your expenses went up. Your skills improved. Your minimum rate should be reviewed at minimum twice a year. The Excel model exists precisely so this review takes 10 minutes instead of a whole existential spiral.
Adding a Scenario Planner (Optional But Worth It)
Once your base model is built, you can extend it with a simple scenario planner. Create three columns next to your base inputs and label them Conservative, Base, and Optimistic. In each column, adjust the key variables:
| Variable | Conservative | Base | Optimistic |
|---|---|---|---|
| Billable Hours/Week | 18 | 25 | 30 |
| Working Weeks | 42 | 46 | 48 |
| Tax Buffer | 32% | 30% | 28% |
| Annual Expenses | R50,000 | R36,000 | R30,000 |
| Minimum Rate | R782/hr | R492/hr | R398/hr |
This tells you three things: your floor, your target, and what the world looks like when things go well. Use it to decide how to quote on different types of projects — a quick 5-hour job for a known client might use your base rate, while a long-haul project with an unknown client should be quoted closer to your conservative scenario.
Presenting Your Rate With Confidence
Here's the part nobody tells you: once you know your number, you have to say it out loud without apologising for it.
Sipho knows he needs R492 minimum. He rounds to R550 for a 12% market buffer and says: "My rate is R550 per hour." Full stop. No "is that okay?" No "I usually charge less for smaller projects." No hedging.
Priya does the same in London. Her number comes out at £68/hour. She says £75. She doesn't say "I was thinking maybe around £60–80 depending on the scope, if that works for you." That is not a rate. That is an invitation to negotiate you into your worst-case scenario.
The formula gives you confidence not because it's magic, but because it converts a guess into a calculation. And it's a lot harder to talk yourself out of a number you derived from your actual rent, your actual tax rate, and your actual working hours.
Remember: Your rate is not a personality. It's a business output. Calculating it properly is the same category of task as reconciling a bank statement or paying a supplier. It's admin, and it should be done once, correctly, and then revisited quarterly.
The Freelance Rate Calculator Is Already Built.
Pre-formatted Excel workbook with income targets, billable hour inputs, tax buffers, a three-scenario planner, and a 12-month earnings projection. All formulas. Zero guessing.
Get the Template → Works in Excel and Google Sheets · Instant downloadFrequently Asked Questions
The standard formula is: Hourly Rate = (Annual Take-Home Target + Annual Business Expenses) ÷ (1 − Tax Rate) ÷ Total Billable Hours Per Year. For example, if your take-home target is R360,000, your expenses are R36,000, your tax rate is 30%, and you have 1,150 billable hours per year, your minimum hourly rate is approximately R492.
Most freelancers can realistically bill between 20 and 25 hours per week out of a 40-hour working week. The remaining time goes to admin, client communication, proposals, professional development, and non-billable project overhead. Using a conservative estimate of 20–25 hours in your rate calculation is recommended.
Use the formula: Gross Revenue = Net Income Required ÷ (1 − Tax Rate). This works backwards from your take-home target to determine the total revenue your business needs to generate before taxes. In South Africa, freelancers on provisional tax should set aside 25–30% as a conservative buffer unless they know their exact marginal rate.
Yes. DocxDrop offers a Freelance Rate Calculator Excel template with pre-built formulas for income targets, expense inputs, tax buffers, billable hour tracking, and a three-scenario planner (conservative, base, and optimistic). It is compatible with both Microsoft Excel and Google Sheets and available as an instant digital download.
Review your freelance rate at least twice a year — typically at the start of the year and mid-year. Key triggers for a review include a significant change in your living costs, a change in your tax situation, a meaningful increase in your skill level or market position, or if you find yourself consistently turning down work due to rate-related friction.