Tabellab
Business & operations

Freelance hourly rate: how to calculate the rate you need

Your minimum freelance hourly rate is the revenue you need in a year divided by the hours you can actually bill: rate = (target income + overheads) × (1 + margin) ÷ billable hours. Most new freelancers divide their old salary by 2,080 hours instead and end up working for far less than they think. This guide builds a freelance hourly rate calculator in Excel for a designer who wants to pay herself $70,000 a year: with overheads, a 15% margin, seven weeks off and 60% utilisation, her floor is $84.12 an hour, two and a half times the naive $33.65. Rates and costs are examples, not the rules of any country.

Updated 19 Oct 2026 5 min read By Tabellab team

The formula

Revenue needed = (target income + overheads) × (1 + margin)
Billable hours = (52 − holiday weeks − sick and training weeks) × hours per week × utilisation
Minimum hourly rate = revenue needed ÷ billable hours

  • Target income: what you want to pay yourself before income tax, the equivalent of a gross salary. If you compare with a job, add what the employer paid on top, such as pension contributions and health cover.
  • Overheads: software, equipment, insurance, accountant, coworking, phone, training, marketing.
  • Margin: a buffer for quiet months, late payers and reinvestment. 10–20% is a common choice.
  • Utilisation: the share of your working time you can bill. Sales, admin, quotes and email are work, but nobody pays for them.

Working through the example

Nora wants $70,000 a year and has $9,000 of overheads. With a 15% margin she needs (70,000 + 9,000) × 1.15 = $90,850 in revenue. She takes five weeks of holiday and plans two weeks for illness and training, which leaves 45 working weeks of 40 hours, 1,800 hours. At 60% utilisation she bills 1,080 hours.

$90,850 ÷ 1,080 hours = $84.12 an hour. That is a floor: below it she subsidises her clients. Rounded up to the next $5 with =CEILING(B12,5) she quotes $85, which is a day rate of $680 for an 8-hour day. The naive rate, $70,000 ÷ 2,080 hours = $33.65, would leave her with less than half the income she wanted.

Worked example: a freelance hourly rate calculator

The yellow cells are Nora's inputs. Change them to your own numbers and every result updates.

Worked example: a freelance hourly rate calculator
ABFormula in B
1ItemValue
2Target income per year (before income tax), $70,000
3Business overheads per year, $9,000
4Margin for quiet months and reinvestment15%
5Revenue needed = (income + overheads) × (1 + margin)90,850=(B2+B3)*(1+B4)
6Holiday weeks5
7Sick and training weeks2
8Working hours per week40
9Utilisation (share of hours you can bill)60%
10Working weeks = 52 − holiday − sick45=52-B6-B7
11Billable hours per year = weeks × hours × utilisation1,080=B10*B8*B9
12Minimum hourly rate = revenue ÷ billable hours, $84.12=B5/B11
13Quoted rate, rounded up to the next $585=CEILING(B12,5)
14Day rate at 8 hours, $680=B13*8
15Salary ÷ 2,080 hours (the naive rate), $33.65=B2/2080
16Minimum rate if utilisation is only 50%, $100.94=B5/(B10*B8*0.5)
Yellow cells are inputs, green cells are formulas. Hover a result to see its formula.

The freelancer and all figures are fictional examples. Tax and fee rules depend on your country and platform.

Utilisation is the number that matters most

A full-time freelancer rarely bills more than 60–70% of their working hours, and in the first year often less. If Nora bills only 50%, her floor rises from $84.12 to $100.94 for the same income. Each 10 percentage points of utilisation moves the rate by roughly 15–20%, more than any other input.

Track your real utilisation for a few months: billable hours ÷ total hours worked. Use that, not the number you hope for. Also count unpaid gaps between projects as non-billable time, either through a lower utilisation or through more weeks off.

Tax, fees and other things to add

  • Income tax: the target income in this calculator is before income tax, like a gross salary, so tax is paid out of it. If you start from the net amount you want to keep, gross it up first. Set tax money aside from every payment, because nobody withholds it for you.
  • Platform and payment fees: if a marketplace keeps a percentage, divide your rate by (1 − fee %) to keep the same net amount. Adding the fee percentage on top is not enough, because the fee is charged on the higher price as well.
  • VAT or sales tax: where you must charge it, it comes on top of your rate and is passed on, so it is not part of this calculation.
  • Late payment: long payment terms do not change the rate, but they change how much cash buffer you need.

From the floor to your actual price

The calculator gives the lowest rate that works for you. What you charge also depends on the market rate for your skills, your experience and the value of the work to the client. If the market pays well above your floor, charge the market rate. If it pays below, raise utilisation, cut overheads, specialise or switch to day rates and project prices that reward working fast.

For fixed-price projects, estimate the hours, multiply by your rate and add a buffer for scope creep, then check the effective hourly rate after the project: price ÷ hours actually worked. That number, tracked over time, tells you whether your pricing works. For a quick check on margins, see markup vs margin.

Common mistakes

  • Dividing a salary by 2,080 hours. That assumes 52 paid weeks and 100% billable time. Freelancers have neither.
  • Forgetting overheads. An employer paid for your laptop, software, insurance and desk. Now you do.
  • Assuming full utilisation. Sales, admin and quotes take time. 50–70% billable is realistic for most solo freelancers.
  • Leaving out holidays and sick days. Weeks you do not work still have to be paid for by the weeks you do.
  • Treating the minimum rate as the price. It is a floor. Charge the market rate if it is higher.
  • Adding platform fees on top instead of grossing up. Divide by (1 − fee %), because the fee is taken from the higher price too.

Frequently asked questions

How do I calculate my freelance hourly rate?

Add your target income and your yearly overheads, add a margin of 10–20%, and divide by the hours you can bill in a year: working weeks × hours per week × utilisation.

How many billable hours does a freelancer have per year?

Often 1,000–1,400. With 45 working weeks of 40 hours and 60% utilisation it is 1,080 hours, about half of the 2,080 hours of a full-time job.

Should the rate include tax?

If your target income is a gross, before-tax figure like a salary, income tax is paid out of it. VAT or sales tax, where it applies, is charged on top of the rate and passed on.

How do I turn an hourly rate into a day rate?

Multiply the hourly rate by the billable hours in a day, usually 7 or 8. At $85 an hour and 8 hours, the day rate is $680.

Practise it in a lab

Related guides

Reading is step one. Doing is step two.

Every guide links to a lab where you build the same calculation in an online spreadsheet and get instant feedback.

Open the lab