Stop Guessing Your Freelance Rates: A Free Google Sheets Profit Calculator

The Problem

Every freelancer I know has underpriced a project at least once. You quote based on "what feels right" or "what the client expects," and three months later you realize you worked for $12/hour after taxes.

I built a simple Google Sheets calculator that takes the guesswork out.

The Solution

The Freelance Profit Margin Calculator does four things:

1. Calculates your true hourly rate based on actual expenses + desired profit margin
2. Tracks project profitability per client and per project type
3. Shows you which clients are profitable and which are costing you money
4. Breaks even at different revenue levels

How to use it

1. List all your monthly expenses (software, rent, insurance, etc.)
2. Set your target profit margin (20%? 30%? 50%?)
3. Enter your current rates
4. Add your actual project data

The sheets auto-calculate everything using standard formulas — no macros, no plugins.

A real example

I ran my own numbers. My expenses were about $1,100/month. At 30% margin and 120 billable hours per month, I needed to charge $95/hour. My current rate was $75. That gap cost me about $2,000/month in lost profit.

Get the template

If you want the exact template I use, I made it available on Gumroad for $27 — it's the same one I use for my freelance coaching clients.

Freelance Profit Margin Calculator on Gumroad

The template includes 4 sheets, 12 pre-built formulas, sample data, and full instructions. It works in Google Sheets (free to use) and Excel.