Freelancer Hourly-Rate & Project Pricing Calculator

What you get

A five-sheet Excel workbook that derives a defensible hourly rate from your actual cost of living, tax burden, benefits, and business overhead — not guesswork. All sheets are formula-linked, so every number you change on the income target flows forward through billable-hour math, rate tiers, project bids, and the annual P&L without manual recalculation.

Who it's for

Freelancers and independent consultants who need to set or raise rates with hard numbers behind them — whether that is a first client conversation, a retainer renewal, or a fixed-price bid on a project that carries real scope risk. It is equally useful to someone billing ten hours a week as to a full-time independent.

What's inside

• Income Target sheet — enter annual living costs, self-employment tax, health and retirement benefits, and business overhead to establish the minimum gross revenue you must hit
• Real Billable Hours calculator — subtracts vacation days, sick days, and non-billable admin time from the calendar year to produce the hours you can actually sell
• Hourly Rate Calculator — divides your income target by true billable hours and layers on configurable markup tiers for client type, project complexity, or rush work
• Per-Project Pricing sheet — applies risk premiums and scope-change adjustments on top of the base hourly rate so fixed-price proposals reflect genuine exposure
• Annual P&L Forecast — projects total revenue across your expected workload and compares the result directly against the income target established on sheet one
• Sample figures throughout — every input cell ships pre-filled with realistic placeholder values so the logic is legible before you enter a single number of your own

How to use it

Open the file in Microsoft Excel or upload it to Google Sheets, then replace the sample figures with your own data, working sheet by sheet in the order they appear. The formulas propagate automatically, so by the time you reach the P&L forecast you have a complete, internally consistent picture of whether your rates cover your goals.