Pricing & Rate Calculator
A spreadsheet-based pricing calculator that helps freelancers set profitable rates for hourly, project-based, and retainer engagements. Factors in business expenses, taxes, desired take-home pay, and utilization rate so you never undercharge again.
What's Included
| File | Description |
|---|---|
hourly-rate-calculator.md |
Bottom-up hourly rate formula sheet |
project-pricing-calculator.md |
Fixed-price project estimation framework |
retainer-pricing-calculator.md |
Monthly retainer value calculator |
value-based-pricing-guide.md |
Guide to pricing based on client outcomes |
rate-comparison-worksheet.md |
Market rate research template |
pricing-scenarios.md |
5 pre-built pricing scenarios with examples |
annual-revenue-planner.md |
Reverse-engineer income targets |
config.example.yaml |
Default rates, expense assumptions, tax rates |
Quick Start
- Extract the ZIP archive
-
Open
hourly-rate-calculator.md— start with the bottom-up formula - Input your annual expenses, desired salary, and target hours
- Calculate your minimum viable hourly rate
-
Use
project-pricing-calculator.mdto convert hourly into project fees -
Reference
rate-comparison-worksheet.mdto validate against market rates
Template Examples
Bottom-Up Hourly Rate Formula
═══════════════ HOURLY RATE CALCULATOR ═══════════════
Step 1: Desired Annual Take-Home Pay
Target salary: $__________
Step 2: Annual Business Expenses
Software & tools: $__________
Office / coworking: $__________
Insurance: $__________
Marketing & advertising: $__________
Professional development: $__________
Equipment depreciation: $__________
Accounting & legal: $__________
Miscellaneous (5% buffer): $__________
──────────────────────────────────────
TOTAL EXPENSES: $__________
Step 3: Tax Obligation
Self-employment tax (15.3%): $__________
Federal income tax (est. ____%): $__________
State income tax (est. ____%): $__________
──────────────────────────────────────
TOTAL TAX: $__________
Step 4: Required Gross Revenue
Take-home + Expenses + Taxes = $__________
Step 5: Billable Hours
Working weeks per year: 48 (minus vacation/sick)
Hours per week: 40
Utilization rate: 60% (admin, marketing, learning)
──────────────────────────────────────
BILLABLE HOURS: 1,152
Step 6: MINIMUM HOURLY RATE
= Required Revenue / Billable Hours
= $__________ / 1,152
= $__________/hr
★ Add 15-20% profit margin: $__________/hr
Project Pricing Calculator
## Project Price Estimation
### Method: Hours × Rate + Risk Buffer
| Phase | Estimated Hours | Rate | Subtotal |
|------------------|-----------------|---------|----------|
| Discovery | ___ | $___/hr | $___ |
| Design | ___ | $___/hr | $___ |
| Development | ___ | $___/hr | $___ |
| Testing/QA | ___ | $___/hr | $___ |
| Revisions (est.) | ___ | $___/hr | $___ |
| Project mgmt | ___ | $___/hr | $___ |
| | | | |
| **Subtotal** | **___** | | **$___** |
| Risk buffer (20%)| — | | $___ |
| **PROJECT FEE** | | | **$___** |
### Complexity Multipliers
| Factor | Multiplier |
|-------------------------------|------------|
| Tight deadline (<2 weeks) | 1.25x |
| Rush job (<1 week) | 1.5x |
| Complex integrations | 1.2x |
| Enterprise client (legal/IT) | 1.15x |
| New technology for you | 1.1x |
Retainer Pricing Calculator
## Retainer Value Calculator
### Formula: (Hours × Rate) - Retainer Discount + Guaranteed Income Premium
Monthly hours committed: ___ hrs
Your hourly rate: $___/hr
Gross monthly value: $___
Retainer discount (10-15%): -$___
Guaranteed income premium: +$___ (value of predictable income)
──────────────────────────────
MONTHLY RETAINER FEE: $___
### Retainer Tiers
| Tier | Hours/Month | Rate | Monthly Fee | Savings vs Hourly |
|----------|-------------|----------|-------------|-------------------|
| Starter | 10 | $___/hr | $___ | 10% |
| Growth | 20 | $___/hr | $___ | 12% |
| Partner | 40 | $___/hr | $___ | 15% |
Unused hours: □ Roll over (max 1 month) □ Use-it-or-lose-it
Worked Example
EXAMPLE: Web Developer in a mid-cost-of-living city
Target take-home: $85,000
Business expenses: $12,000
Taxes (~30%): $41,571
Required revenue: $138,571
Billable hours: 1,152
Minimum rate: $120.28/hr
With 20% margin: $145/hr
Project pricing:
Simple website (40 hrs): $5,800 (40 × $145)
Complex web app (120 hrs): $20,880 (120 × $145 × 1.2 complexity)
Monthly retainer (20 hrs): $2,552 (20 × $145 × 0.88 discount)
Usage Tips
- Start with the bottom-up formula. Most freelancers undercharge because they skip this step
- Use 60% utilization, not 100%. You won't bill 40 hours every week — be realistic
- Calculate quarterly. As expenses and goals change, so should your rates
- Never quote hourly for large projects. Use project pricing — it rewards efficiency
- Round up to the nearest $5 or $10. $145/hr sounds more deliberate than $143.27
Best Practices
- Know your floor. Your minimum rate covers costs. Below this, you're losing money
- Price for value, not time. A logo worth $50K to the client shouldn't cost $500
- Raise rates annually. Minimum 5-10% increase, ideally tied to new skills or results
- New clients get new rates. Grandfather existing clients at old rates for 6 months
- Track your effective rate. Divide actual payment by actual hours for every project
- Don't compete on price. Compete on quality, reliability, and specialization
This is 1 of 11 resources in the Freelancer Toolkit Pro toolkit. Get the complete [Pricing & Rate Calculator] with all files, templates, and documentation for $19.
Or grab the entire Freelancer Toolkit Pro bundle (11 products) for $149 — save 30%.
Top comments (0)