Spreadsheets

Freelance hourly rate calculator sheet built from your expenses

Build a freelance hourly rate calculator in Excel or Google Sheets from monthly costs, a tax set-aside and realistic billable hours, with a worked example.

Editorial illustration for Freelance hourly rate calculator sheet built from your expenses

To price your time, add up what a month costs you at home and in the business, add a tax set-aside, and divide by the hours you can realistically bill. The result is your minimum hourly rate. The catch is that billable hours are far fewer than working hours, so a sheet that divides by 160 will quote you too low. The layout below ends in one cell that gives a floor you can defend.

What goes into the sheet

Put a label in column A and a value in column B. Every number here is made up to show the arithmetic, so replace them with your own.

CellLabelExample value
B2Monthly personal costs (rent, food, EMIs, insurance, school fees)₹45,000
B3Monthly business costs (software, internet, co-working, phone share)₹8,000
B4Savings and buffer you want out of this income each month₹5,000
B5Tax set-aside as a share of what you invoice15%
B6Hours you work in a normal week40
B7Share of those hours you can bill50%
B8Working weeks in a year after leave, festivals and illness46

The 15% is only a placeholder. Ask your CA what share to set aside for your situation and type that in B5.

How do you turn costs into a minimum hourly rate?

  1. Money you need each month, in B9: =B2+B3+B4. With the example that is ₹58,000.
  2. Money you must invoice, in B10: =B9/(1-B5). The set-aside comes out of the invoice, so you divide by 0.85 rather than adding 15% on top. ₹58,000 divided by 0.85 is about ₹68,235.
  3. Billable hours a month, in B11: =B6*B7*B8/12. That is 40 x 0.5 x 46 / 12, about 76.7 hours.
  4. Minimum hourly rate, in B12: =B10/B11. That is ₹68,235 divided by 76.7, about ₹890.
  5. Rate to quote, in B13: =ROUNDUP(B12,-1), which gives ₹900. A day rate is simply B13 times the hours you are willing to sell in a day.

Why not just divide by 160 hours?

Because nobody bills 160 hours a month. The same ₹68,235 over 160 hours comes to about ₹426 an hour, less than half of the ₹890 above. The gap is proposals, invoicing, chasing payments, learning and the weeks between clients. Cell B7 is where you are honest about that. Track one ordinary month of real hours before you trust any percentage there.

What happens if your billable share changes?

Copy the block, change only B7, and watch B12 move. With the other inputs unchanged:

Billable share of the weekBillable hours a monthMinimum hourly rate
40%61.3about ₹1,113
50%76.7about ₹890
60%92.0about ₹742

A part-time freelancer who bills only two days of a five-day week is in the first row. That is not a failure, but it does mean the rate has to carry more.

Where do the monthly cost numbers come from?

Rows B2 to B4 decide everything, and most people guess them low. Use the last three months of actual statements and take the average, including the annual bills spread over twelve months. If your spending is already categorised, the totals are quick to pull out: SpendixAI imports bank and card statements and its reports can be downloaded as CSV, so personal and business spending can be totalled per month without retyping.

Checklist before you send a quote

  • Costs taken from statements, not memory.
  • Tax set-aside agreed with your CA; GST treatment, if you are registered, confirmed with them as well.
  • Billable share based on a tracked month.
  • A cushion for late payments, since a client who pays in 45 days is a cost too.
  • Sheet reviewed every quarter, because rent and school fees change.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports