Pricing & Rate Calculator
Spreadsheet calculator for hourly, project, and retainer pricing. Factors in expenses, taxes, and desired profit margin.
📄 Product Preview
Try the interactive reader and demo tools below, or get the full product with all content unlocked.
📖 Interactive Reader (Free Preview) ⚙ Try Demo Tools 📦 Download Free Sample📁 File Structure 19 files
📖 Documentation Preview README excerpt
Freelance Rate Calculator
By Freelancer Toolkit Pro | $19
A spreadsheet-based calculator for determining your hourly, project, and retainer rates. Stop guessing what to charge. This calculator factors in your expenses, taxes, desired income, profit margin, and realistic utilization to compute the exact rate you need.
Disclaimer: This product is for informational and organizational purposes only. It is not tax or financial advice. Consult a licensed accountant for your jurisdiction.
What's Inside
Spreadsheets (CSV → Google Sheets / Excel Import)
| File | Purpose | Content |
|---|---|---|
sheets/hourly-rate-calculator.csv | Compute your minimum hourly rate | 6 scenarios from $60K to $150K target income |
sheets/project-quote-calculator.csv | Build project quotes with all cost layers | 8 worked project examples with line-by-line pricing |
sheets/retainer-calculator.csv | Structure monthly/quarterly/annual retainers | 5 retainer models with discount tiers and overage rates |
sheets/billable-hours-model.csv | Track and project your actual utilization | 8 weeks of realistic time data with non-billable breakdown |
Formulas Reference
| File | Purpose |
|---|---|
formulas/FORMULAS.md | 20 Google Sheets formulas: rate calculation, project quoting, retainer pricing, utilization tracking |
Documentation
| File | Purpose |
|---|---|
docs/pricing-methodology.md | The math behind your rate: 5 variables explained with benchmarks and worked examples |
docs/raise-your-rates-guide.md | When and how to raise rates: 5 signals, 4 strategies, pushback scripts, annual calendar |
docs/CUSTOMIZATION.md | Adapt every calculator for your profession, tax situation, and business stage |
Pages (Guides)
| File | Purpose |
|---|---|
pages/calculator-setup.md | Import, format, link sheets, add interactivity, protect formulas |
Features
- Bottoms-Up Rate Calculation — Starts from your target income and works up to include expenses, taxes, and profit
- 6 Pre-Built Scenarios — Conservative to Premium, with realistic numbers you can compare against
- Project Quote Builder — Layer labor + materials + buffer + overhead + profit for accurate fixed-price quotes
- Retainer Pricing Models — Monthly, quarterly, annual pricing with commitment discounts and overage rates
- Billable Hours Tracker — 8 weeks of sample data showing how utilization affects your real earnings
- 20 Ready-to-Use Formulas — Every formula documented with worked examples and cell references
- Rate Raise Framework — Scripts, strategies, and a calendar for increasing rates without losing clients
- The Three-Tier Proposal — How to structure proposals so clients choose your preferred price point
Quick Start
1. Download and unzip the product files
2. Create a Google Sheets workbook with 4 tabs
... continues with setup instructions, usage examples, and more.
📄 Content Sample docs/CUSTOMIZATION.md
Customization Guide — Rate Calculator
How to adapt the calculator spreadsheets for your specific freelance situation.
Disclaimer: This is not tax or financial advice. Consult a licensed accountant for your jurisdiction.
Customizing the Hourly Rate Calculator
Your Input Variables
Replace the sample scenarios with your actual numbers:
| Cell | What to Enter | How to Determine |
|---|---|---|
| Target Annual Income | Your desired take-home pay | Sum of living expenses + savings goals + lifestyle buffer |
| Annual Business Expenses | Total yearly business costs | Add up all subscriptions, rent, insurance, tools for 12 months |
| Annual Tax Burden | Estimated total taxes | Use 25-35% of (income + expenses) as a starting estimate |
| Desired Profit Margin | Business growth fund (%) | Start at 10-15%, increase as you establish your business |
| Available Work Weeks | Weeks you'll actually work | 52 minus vacation, sick days, holidays (typically 46-50) |
| Hours Per Week | Hours at your desk | Be honest — include only focused work time |
| Billable Utilization | % of time on client work | Track for 2-4 weeks to get your real number |
Adding Your Own Scenarios
The sample includes 6 scenarios. Add rows for your own "what-if" analysis:
- What if I only work 30 hours/week?
- What if I take 6 weeks of vacation?
- What if I hire a virtual assistant (increasing expenses but also utilization)?
- What if I move to a state with no income tax?
Customizing the Project Quote Calculator
Your Service Types
Replace the sample projects with your typical project types:
For designers: Logo Design, Brand Package, Website Mockup, Print Collateral, Social Media Kit
For developers: Landing Page, Full Website, Web App, API Integration, Mobile App
For writers: Blog Post Series, White Paper, Email Sequence, Sales Page, Content Strategy
For consultants: Strategy Session, Audit, Training Workshop, Implementation Support
Your Buffer Percentages
... and much more in the full download.