Most freelancers underprice their work by 30-50%. Not because they're bad at what they do — but because they forget to account for taxes, overhead, non-billable hours, and profit margin.
I built a spreadsheet to fix this.
The Problem
Here's what most freelancers do:
"I want to make $80K/year. There are ~2,000 work hours in a year. So my rate is $40/hour."
Wrong. Here's why:
- You won't bill 2,000 hours. Realistically, 1,200-1,400 hours are billable (the rest is admin, sales, learning, breaks).
- Taxes eat 20-30% of your income.
- Business expenses (software, equipment, insurance) add up to $5-10K/year.
- You forgot profit margin — are you building a business or just paying bills?
The real math:
Total costs (personal + business): $85,000
After tax (25% rate): $113,333
With 20% profit margin: $136,000
Billable hours (25hrs/week × 48 weeks): 1,200
Real hourly rate needed: $113/hr (not $40!)
That's almost 3x what most people charge.
The Solution: A Pricing Calculator That Does the Math
I created a spreadsheet that calculates your real rate based on YOUR numbers:
What it covers:
- 9 personal cost categories (rent, food, health insurance, etc.)
- 8 business expense categories (software, equipment, marketing, etc.)
- Working hours configuration (weeks/year, billable hours/week)
- Tax rate and profit margin inputs
What it outputs:
- Minimum rate (break-even — you survive but don't grow)
- Recommended rate (with profit margin — you build wealth)
- Premium rate (for rush jobs and specialized work)
- 6 what-if scenarios ("What if I raise prices 25%?")
- Annual revenue projections at each rate
Plus:
- Project pricing calculator — break a project into tasks, get a total price
- Value-based pricing check — compare your price to the value you create for the client
- Client profitability tracker — see which clients make you money and which cost you
- Dashboard — visual overview with KPI cards and charts
Three Pricing Models Every Freelancer Should Know
1. Hourly Rate
The default. Simple but limiting — you trade time for money.
When to use: Ongoing retainers, maintenance work, consulting.
2. Project-Based
Estimate hours, multiply by your rate, add a 15% scope creep buffer.
When to use: Websites, branding projects, apps — anything with a defined scope.
3. Value-Based
Price based on what the client GAINS, not what it costs you.
If your website redesign will earn the client $50,000 in new revenue, charging $5,000 (10%) is fair — even if it only takes you 40 hours.
When to use: When you can quantify the ROI of your work.
The Free vs Paid Version
I offer two versions:
| Feature | LITE (Free) | Full ($19) |
|---|---|---|
| Personal costs input | ✅ | ✅ |
| Business expenses input | ✅ | ✅ |
| Minimum & recommended rate | ✅ | ✅ |
| Premium rate | ❌ | ✅ |
| What-if scenarios (6) | ❌ | ✅ |
| Project pricing calculator | ❌ | ✅ |
| Value-based pricing check | ❌ | ✅ |
| Client profitability tracker | ❌ | ✅ |
| Visual dashboard | ❌ | ✅ |
| EN + PT-BR versions | ❌ | ✅ |
Both are Google Sheets + Excel compatible.
The One Thing to Do Today
Open the spreadsheet. Fill in your real costs. Look at the recommended rate.
If it's higher than what you're currently charging — you now know exactly how much money you're leaving on the table every single month.
One correct pricing decision pays for itself forever.
What's your experience with pricing freelance work? Have you ever calculated your real rate? Drop a comment — I'm curious how your number compares to what you're actually charging.
Top comments (0)