Contractor Day Rate Excel - Free Template

1. Open Day Rate Calculator and review the supplied assumptions, including £75,000 desired annual personal income, £6,000 annual business costs and 260 calendar working days.
2. Amend the editable planning inputs for your own income goal, costs, pension contribution, subscriptions, equipment, leave and non-billable time.
3. Set your target profit margin, editable corporation tax estimate, allowance adjustment and VAT selection. The calculator updates the rate outputs automatically.
4. Review the minimum, recommended and VAT-inclusive rate outputs. Check that the available billable days reflect how much time you can realistically sell.
5. Move to Contract Scenarios and enter a Scenario ID, contractor, client, role, location, dates, contract days and day rate ex VAT.
6. Select a VAT category and IR35 status from the supplied lists, then add estimated costs and notes. Calculated columns show VAT per day, gross value, estimated profit, margin and status.
7. Use Instructions to check the workbook guidance, then revisit assumptions whenever your costs, availability or engagement terms change.

A contractor day rate calculator is useful when you are pricing a new engagement, reviewing a renewal or deciding whether a proposed contract supports your income target. Software developers, project managers, engineers, consultants and other independent professionals can compare a commercial rate with the number of days they expect to invoice.

Pricing around real availability

The workbook does not treat every calendar working day as billable. Its supplied example starts with 260 calendar working days, then deducts 25 unpaid leave days, 8 bank holidays and 20 non-billable days. That leaves 207 available days in the planning example. If the same annual target must be earned across fewer billable days, the required rate rises.

For example, a contractor planning £75,000 of personal income also enters £6,000 of general business costs, £5,000 of employer pension contribution, £2,000 of professional subscriptions and insurance, and £2,500 of equipment and software costs. Those figures are sample assumptions, not a forecast of your own position.

Comparing engagements

Contract Scenarios is suited to a weekly pipeline review or a decision about competing offers. The sample includes Oliver Smith working as a Software Developer for London FinTech Ltd at £650 ex VAT for 120 contract days, alongside Amelia Jones as a Project Manager at £550 ex VAT for 90 days.

At £650 across 120 days, the gross contract value calculates to £78,000 before estimated costs. At £550 across 90 days, it calculates to £49,500. These examples show why the day rate alone is not enough: contract length and estimated costs change the result materially.

The workbook separates assumptions from calculated outputs. On Day Rate Calculator, the inputs run from desired annual personal income through to the VAT rate and current tax year. The formulas then turn those entries into available days, turnover assumptions, daily rates and monthly planning figures.

From assumptions to recommended rate

Available days are calculated by taking the calendar working days assumption and deducting unpaid leave, bank holidays and non-billable days. In the supplied example, 260 minus 25, 8 and 20 gives 207 days. A zero or negative availability position is not a sensible pricing basis, so review these inputs before relying on an output.

The calculator uses SUM to combine cost inputs and IF logic to prevent negative available days from producing a negative result. It calculates a minimum rate excluding the target profit margin, then a recommended rate that includes the target margin. A monthly figure is also calculated from the recommended daily rate and available days.

VAT and scenario controls

Contract Scenarios calculates VAT per day by multiplying the ex-VAT day rate by the percentage associated with the selected VAT Category. The category is looked up with VLOOKUP from the reference values for Standard, Reduced and Zero. With a £650 ex-VAT rate and a supplied 20% Standard rate, VAT per day is £130 and the displayed day rate including VAT is £780.

Use the validation lists rather than typing alternative labels. The IR35 Status list accepts Outside IR35, Inside IR35 or Not assessed. Dates drive the Status formula: an end date before today becomes Completed, a future start date becomes Planned, and another dated engagement becomes Active. These are workbook labels for planning, not a legal determination.

The largest pricing error is usually overstating billable availability. If you leave the supplied 260 calendar working days unchanged but expect to spend 20 days on administration, sales and training, the calculator can understate the rate needed to meet the same annual goal. Adding 25 unpaid leave days and 8 bank holidays makes the example availability 207 days rather than 260.

Confusing rate and contract value

A £650 day rate may look stronger than £550, but a shorter engagement can produce less total revenue. The sample £650 rate over 120 days gives £78,000 gross contract value, while £550 over 90 days gives £49,500. Compare the Gross Contract Value and Estimated Profit columns rather than ranking offers only by the daily figure.

Entering the wrong VAT category

The VAT category controls the VAT per Day and Day Rate Inc VAT calculations. If a £650 rate is accidentally marked Zero instead of Standard, the displayed inclusive rate is £650 rather than £780 in the supplied 20% example. That £130-per-day difference across 120 days would change the illustration by £15,600.

Do not overwrite calculated columns with manual numbers. The Contract Scenarios formulas are designed to stay blank until a Scenario ID is entered and then calculate across the row. Replacing a formula in VAT per Day, Gross Contract Value or Profit Margin can leave one scenario looking correct while later changes no longer flow through.

Using tax and IR35 fields as conclusions

The workbook includes an editable corporation tax estimate, tax allowance adjustment and IR35 Status field for planning. They are not a tax calculation or status assessment. Treat the supplied 2026/27 entry, 20% VAT example and IR35 labels as workbook assumptions, and obtain appropriate advice when the engagement requires a detailed review.

Use the workbook at a fixed point in your commercial routine rather than only when a contract is about to be signed. A Friday pipeline review works well for updating scenario dates, contract days, day rates and estimated costs; a month-end review can then compare the plan with current negotiations.

Keep the calculator current

Review the main assumptions whenever your circumstances change. For example, adding 10 days of planned training to the supplied 20 non-billable days reduces available billing capacity from 207 to 197 days, so the recommended rate should be checked rather than carried forward automatically.

• Update annual costs when insurance, subscriptions or software change.
• Revisit unpaid leave and non-billable days before accepting a long engagement.
• Check the target profit margin when moving from a single contract to several clients.
• Review the VAT reference table when your planning assumption changes.

Use scenario rows consistently

Give each opportunity a distinct Scenario ID, such as CS-003, and complete the same core fields every time. Enter £650 as the ex-VAT rate rather than £780 inclusive, then let the VAT Category calculate the inclusive figure. This keeps comparisons consistent across the sample 120-day and 90-day engagements.

Use the Status output as a quick pipeline view, but keep dates accurate because the formula compares them with TODAY. Once the workbook becomes difficult to maintain across more than 100 scenario rows, or you need invoicing, timesheets, cash collection and accounting integration, a dedicated contractor management or accounting system may be more suitable.