Templates

Agency Profitability Calculator

Most agencies don't know their actual margins.

You quote $20k for a project. You spend 100 hours. You think you made money.

Then you realize: Salary, software, overhead, taxes, benefits. You made $5/hour.

The profitability calculator prevents this. It shows you what you're actually making.

The Basic Formula

Profit = Revenue - All Costs

Margin = (Revenue - All Costs) / Revenue

Example:

  • Revenue: $20,000
  • Direct costs: $5,000 (freelancer, tools, hosting)
  • Overhead: $8,000 (your salary per hour, software, rent)
  • Total costs: $13,000
  • Profit: $7,000
  • Margin: 35%

Simple math. But many agencies don't do it.

The Calculator

Step 1: Revenue

Project fee: $[Amount]

This is what the client pays.

Step 2: Direct Costs

Direct costs are specific to this project.

  • Freelancer subcontractors: $[Amount]
  • Tools (licenses, subscriptions per project): $[Amount]
  • Hosting/domain: $[Amount]
  • Third-party integrations: $[Amount]
  • Other: $[Amount]

Total direct costs: $[Amount]

Step 3: Labor Costs

How many hours will this take your team?

  • Project manager: [Hours] x $[Hourly rate] = $[Cost]
  • Designer: [Hours] x $[Hourly rate] = $[Cost]
  • Developer: [Hours] x $[Hourly rate] = $[Cost]
  • Other: [Hours] x $[Hourly rate] = $[Cost]

Total labor costs: $[Amount]

Step 4: Overhead Allocation

Overhead = Everything else (rent, software, payroll, utilities, accounting, etc.)

Calculate: Monthly overhead / Monthly revenue = Overhead %

Example: $10,000 monthly overhead / $50,000 monthly revenue = 20%

Overhead for this project: 20% x $20,000 = $4,000

Step 5: Total Costs

Direct costs + Labor costs + Overhead allocation

Example:

  • Direct costs: $2,000
  • Labor costs: $8,000
  • Overhead: $4,000
  • Total: $14,000

Step 6: Profit and Margin

  • Revenue: $20,000
  • Total costs: $14,000
  • Profit: $6,000
  • Margin: 30%

Interpreting Your Numbers

Margin below 20%: You're basically working for free after all costs. Red flag.

Margin 20-35%: You're making money but not much room for error. Tight.

Margin 35-50%: Healthy. You've got breathing room.

Margin 50%+: Excellent. You're either highly efficient or premium positioned.

Common Mistakes in Calculation

Forgetting overhead. You just count direct costs and labor. You forget rent, software, accounting, etc.

Your margin looks better than it is.

Underestimating labor. Project takes 100 hours, you estimated 60.

Your margin evaporates. Next time, estimate 120 hours.

Not accounting for waiting time. Client is slow. You're waiting. You're still paying your team.

Build this into hours.

Assuming 100% billable. You bill 30 hours per week. But you spend time on admin, sales, training.

Account for 60-70% billable, not 100%.

The Red Flag Projects

If a project has:

  • Margin below 20%
  • Constant scope creep
  • Difficult client (slow feedback)
  • High revision requests

Flag it. Either raise the price next time or decline it.

These projects are killing your profitability.

Improving Margins

Raise prices. A 10% price increase is a 30-50% profit increase.

Lower labor costs. More efficiency, better processes, better estimation.

Reduce overhead. Shared space, cheaper software, lower payroll.

Reduce scope. Tighter project definition. Less "extras."

Focus on high-margin work. Do the work that's profitable. Turn away low-margin work.

The Estimation Impact

If you consistently underestimate, your margins evaporate.

Example: You estimate 60 hours, it takes 80. That's a 33% error.

On a $20k project with 40% margin:

  • Estimated hours: 60 = $20,000 / 60 = $333/hour
  • Actual hours: 80 = $20,000 / 80 = $250/hour

You made $83/hour less.

Over a year, if this happens on 10 projects, you lose $83k in profit.

Better estimation is more profitable than raising prices.

The Profitability Timeline

Year 1: You're probably at 20-30% margin. You're still learning.

Year 2: You're at 30-40% margin. Processes are cleaner.

Year 3+: You're at 40-50%+ margin. You've got estimation down.

If you're not improving year-over-year, something's broken.

FAQ

Should overhead be per-project or annual?

Per-project. Some projects are profitable even after overhead allocation. Some aren't.

How do I calculate my hourly rate from margin?

(Revenue - (Revenue x Margin)) / Total hours = Real hourly rate

If you're making $6k on $20k (30% margin) in 100 hours: $6,000 / 100 = $60/hour profit.

What if a client negotiates the price down?

Recalculate margin. If it drops below 30%, decline. Or reduce scope.

Should I share margins with my team?

Yes. It helps them understand pricing and why you make certain decisions.

How do I compare profitability across different service types?

Calculate margin for each service separately. Website design might be 35%, consulting might be 55%.

Focus on the high-margin services. They're more profitable even at lower revenue.

What's the difference between project margin and company margin?

Project margin is for individual projects. Company margin is all revenue minus all costs for the whole year.

Project margins can vary (25-50%). Company margin should target 40%+ or you're losing money overall.

Should I accept low-margin projects if they might lead to higher-margin work?

Only if the low-margin project is a genuine foot in the door with a new client who'll buy retainers later.

Don't sacrifice margins for vague promises. Make sure the follow-up work is probable and worth it.

Ready to see all your tasks in one place?

Sync all your project management tools.

Start Free Trial