🎉 Black Friday: off every tracker · Or get all 8 for $49.99 → 🎉 Get all 8 spreadsheets for $49.99, save $109.93 vs buying separately →

What it does

A first or next hire is one of the biggest commitments a small business makes. The wage is only part of it: employer payroll costs, benefits, equipment, recruitment, onboarding, and the months it takes a new person to get up to speed all hit your cash before the hire starts paying for itself. This calculator puts all of that on one page. Choose salary or hourly pay, set paid and productive hours, enter your own employer burden %, and add one-time costs in the hire month. Set how productive the person is in month one and how many months it takes to reach full speed. Then tell it how the hire earns revenue — billable hours × rate, or a monthly revenue figure — and your contribution margin.

What's inside

Workbook tabs: Start Here · Assumptions · Dashboard · Monthly Plan · Scenarios · Employee vs Contractor. Download: one .zip with 2 Excel workbooks (.xlsx), a PDF user guide and a licence.

Who it's for

Frequently asked questions

Does it calculate CPP, EI, FICA or FUTA for me?

No. Those rates change every year and depend on location, so you enter your total employer burden %. The Assumptions tab lists what to include.

Can it tell me whether to use a contractor or an employee?

It compares cost only. Legal classification depends on the working relationship, not cost — get professional advice.

What if the person starts partway through the year?

Set the hire month (1–12). Earlier months carry no cost for the hire, and one-time costs land in the hire month.

What is contribution margin?

The share of the revenue this person brings in that's left after direct delivery costs (materials, supplies, card fees), before their own pay.

Does it work in Google Sheets?

It hasn't been tested there yet. It's built for Microsoft Excel.

⚠ Important: please readA planning tool for information only. It is not tax, legal, accounting, lending, investment or financial advice, and it doesn't replace a qualified professional. Results depend on the figures you enter; lenders, platforms and tax authorities apply their own rules. Check important decisions with a professional. Images show the real workbook with sample data.

You might also like