Freelance Rate Calculator & Project Pricing Kit — Stop Undercharging

Most freelancers set their rate by guessing what the market pays, then wonder why a “good year” leaves nothing after taxes. This spreadsheet works the math the right direction: start from the take-home income you actually want, gross up for taxes and overhead, divide by the hours you can realistically bill — and out comes the floor rate you can defend.

Four sheets, ready in minutes:

• Your Rate — enter income goal, weeks off, hours per week, utilization, tax rate, and overhead (software, insurance, hardware, other). Get your required hourly and day rate, plus a sensitivity table showing your rate at 50/60/70% utilization so you see what a slow quarter really costs.
• Project Quote — enter estimated hours, pick complexity and rush multipliers from dropdowns, add pass-through expenses. You get a suggested quote, and if you round your final price below your floor, the margin check turns red before the client ever sees the number.
• Income Tracker — a 12-month table for invoiced, collected, expenses, and billable hours, with net, running total, utilization, and yearly totals computed for you.
• Start Here — plain-English instructions, the exact math explained, and a color legend (yellow = edit, gray = computed).

Real formulas, no macros, nothing locked. Works in Excel & Google Sheets (File > Import). Instant download, use it on your next quote today.