Free Freelancer Rate Planner Template
Calculate a cost-covering hourly rate and estimated day-rate scenario based on the income goals, business expenses, and billable hours you enter.
What Is This Template?
One of the most common financial mistakes freelancers make is setting rates based on guesswork, competitor pricing, or what "feels right" — without ever checking whether those rates actually cover their costs and personal income goals. The result is a freelancer who is busy but broke: working full-time hours, paying all their bills, but never generating enough surplus to save, invest, or grow.
The freelancer rate planner template solves this problem by working backwards from your financial goals. Instead of starting from what you think the market will bear, you start from what you need: your desired annual income, your business expenses, your tax obligations, and the number of hours you can realistically bill each year. The template calculates a cost-covering rate based on the assumptions entered. It is an illustrative planning figure, not a recommendation about what you should charge.
The template also shows an editable buffer, an eight-hour day-rate scenario and a weekly-rate scenario. It has no project-pricing or monthly-revenue worksheet. It includes a billable hours calculator that accounts for the unpaid time freelancers spend on admin, proposals, marketing, and professional development — one of the most overlooked factors in freelance pricing.
Whether you are a designer, developer, writer, consultant, photographer, or any other type of freelancer, this template gives you the clarity to price your services with confidence and profitability.
Who Should Use This Template
- Freelancers setting rates for the first time who want a data-driven starting point rather than guessing or copying competitors
- Established freelancers reviewing their pricing to ensure their current rates still cover rising expenses and income goals
- Consultants and coaches who charge project fees or retainers and need to know their equivalent hourly rate
- Self-employed professionals transitioning from employment who need to understand how much more they need to earn to replace their salary after tax and expenses
- Side freelancers who want to know whether their side income is generating real profit after all business costs
How To Use This Template
- Step 1 — Enter your annual income target. What do you want to take home from your freelance business after business expenses and the estimated personal tax included in this simplified model? Be specific — "I want to pay myself $65,000 this year."
- Step 2 — List annual business expenses. Include software, equipment, professional memberships, marketing, insurance, home office costs, accountant fees, and any other business overhead. This is separate from what you pay yourself.
- Step 3 — Add tax reserve. Enter your estimated tax rate. The template divides your after-tax income target by (1 − tax rate), then adds business expenses. This assumes a single effective tax rate on profit; it does not calculate tax brackets, deductions or jurisdiction-specific liabilities.
- Step 4 — Enter your working weeks. How many weeks per year do you plan to work? Subtract holidays, sick days, and business development time. Use the number of weeks that reflects your own plan.
- Step 5 — Enter your billable hours per week. Enter total working hours and your billable percentage in the workbook. For example, 40 hours at 70% billable gives 28 billable hours. Estimate these inputs from your own tracked time.
- Step 6 — Read your minimum rate. The template calculates: Cost-Covering Rate = (After-tax income target ÷ (1 − tax rate) + Expenses) ÷ Annual Billable Hours. This is an illustrative figure based on the assumptions you entered.
Formula and calculation model
- Required Pre-tax Income = After-tax Income Target ÷ (1 − Tax Rate)
- Minimum Gross Revenue = Required Pre-tax Income + Business Expenses
- Annual Billable Hours = Working Weeks × Hours per Week × Billable Percentage
- Minimum Hourly Rate = Minimum Gross Revenue ÷ Annual Billable Hours
- Buffered Hourly Rate = Minimum Hourly Rate × (1 + Buffer Percentage). The day-rate scenario uses this buffered rate × 8.
Assumptions in this version
- Uses a single effective tax rate for the full planning year.
- Working weeks, weekly hours, and billable percentage must give more than zero billable hours. Use a tax rate from 0% to below 100% and a billable percentage above 0% up to 100%. Invalid tax or time inputs show N/A rather than a misleading rate.
- Owner pay, tax reserve, and business expenses are modeled as planning inputs, not payroll engine outputs.
What this template does not include
- This is not tax advice and does not calculate bracket progression, deductions, or jurisdiction-specific filing rules.
- It is a planning baseline only; your market-rate and positioning decisions are separate from this cost-covering figure.
- Income timing assumptions, late payments, and project complexity can materially change the practical rate required.
Example Scenario
Maria's Web Design Business — Minimum Rate Calculation
- Desired annual after-tax income: $72,000
- Annual business expenses: $8,400 (software, equipment, marketing)
- Tax rate: 22% (selected solely for illustration) → required pre-tax profit: $72,000 ÷ 0.78 = $92,307.69; estimated tax: $20,307.69
- Total revenue required: $92,307.69 + $8,400 = $100,707.69
- Working weeks: 47
- Working hours per week: 40; billable percentage: 70%; billable hours: 28
- Annual billable hours: 47 × 28 = 1,316 hours
- Cost-covering hourly rate: $100,707.692307… ÷ 1,316 = $76.53/hour
In this hypothetical example, the calculated cost-covering rate of $76.53/hour is above Maria's current $60/hour, so the assumptions entered would not meet her stated income target. This is an illustration of how the calculation works and does not indicate what any freelancer should charge or what results they would obtain.
Common Mistakes to Avoid
- Assuming 100% billable hours. No freelancer bills 40 hours every week, 52 weeks a year. Account for non-billable admin time, marketing, professional development, and the reality that some weeks have no client work. Overestimating billable hours leads to an underpriced minimum rate.
- Ignoring taxes. Freelancers pay both income tax and self-employment tax. Gross revenue requirements depend entirely on your own tax situation; enter your own estimated tax rate rather than relying on a general figure.
- Treating the calculated rate as a target. The calculated rate only reflects the assumptions you entered. Actual pricing decisions depend on risk, expertise, market value, and your own circumstances.
- Not reviewing rates annually. Business expenses increase every year. A rate calculated two years ago may no longer cover current costs. Recalculate at least annually.
- Forgetting unpaid project time. Proposals, revisions, client communications, and project management are real work. If a project takes 20 hours of billable work but 5 additional hours of unpaid admin, factor that into project pricing.
Methodology & Accuracy
How this template produces its results, and the limits you should keep in mind when using them.
- Formula source
- The result is produced by the exact mathematical formula shown on this page. The formula is derived from the definition of the relationship between the inputs and the output (for example, profit margin is profit divided by revenue by definition). Where a formula relies on an external rule, rate, or convention, the authoritative source supporting that claim is linked in the Sources section below. The calculation has not been certified or approved by any professional body.
- Assumptions
- Calculations assume the figures you enter are accurate and apply to your situation. These are simplified models that may not capture every business scenario, and the estimates depend entirely on the values you select.
- Uncertainty and limitations
- Results are estimates based on the information entered. Actual financial outcomes may differ depending on business circumstances, market conditions, taxes, location, and other factors.
- Jurisdiction limitations
- Financial rules, taxes, lending practices, and business requirements may vary by location. Consider local requirements when making financial decisions based on these results.
- Tested with sample inputs
- The formulas in this template have been checked using the sample figures shown in the workbook to confirm the calculation logic produces expected results.
- Ownership and testing
- This template is maintained by Small Business Finance Toolkit. Its calculation can be checked using the sample figures shown on this page. It has not been certified or reviewed by a licensed financial professional. Found an error or outdated information? Contact us.
- Review status
- Sample checks are listed above where available. This page is documented as an educational tool and is updated before major edits using a documented review process.
Download Free Template
A comprehensive freelancer rate calculator in Google Sheets or Excel. Enter your income goals, expenses, tax rate, and billable hours to get your minimum hourly and day rate.
No sign-up required. Download, customize, and use the template for your own business needs.
- Free to use
- Editable formulas
- Example data included
- Instructions tab
- Google Sheets compatible
- No sign-up needed
Sources and references
The notes below identify the topics each reference supports. Worked scenarios and calculator outputs are illustrations, not endorsements by these organizations.
- IRS — Self-Employed Individuals Tax CenterU.S.Explains that self-employed individuals generally pay income tax and self-employment tax, and covers estimated tax and recordkeeping.https://www.irs.gov/businesses/small-businesses-self-employed/self-employed-individuals-tax-center
- IRS — Self-Employment Tax (Social Security and Medicare Taxes)U.S.States the U.S. self-employment tax rate of 15.3%, consisting of Social Security and Medicare components.https://www.irs.gov/businesses/small-businesses-self-employed/self-employment-tax-social-security-and-medicare-taxes
- IRS — About Form 1040-ES (Estimated Tax)U.S.Describes estimated tax for income not subject to withholding, including quarterly payments by some self-employed taxpayers.https://www.irs.gov/forms-pubs/about-form-1040-es
- IRS — Estimated TaxesU.S.Guidance on how and when estimated tax payments are made for income that is not subject to withholding.https://www.irs.gov/businesses/small-businesses-self-employed/estimated-taxes
Published and maintained by Small Business Finance Toolkit
Content updated: September 2026
This template was created around common freelancer pricing and income planning concepts. It helps independent professionals consider expenses, working time, and income goals when evaluating sustainable rates. Actual pricing decisions depend on individual circumstances and business goals.