Rate Calculator
Holiday accrual · Employers NI · Apprentice levy · AE pension · Agency mark-up
Assumptions
All rates recalculate instantly
Statutory = 28 days
Default 15%
£175/wk (only if toggle ON)
0.5% of base+holiday
AE minimum = 3%
AE lower band = £120
AE upper band = £967
Contracted hours
Working days = 5
Applied to base pay ONLY
Breeze = £10/wk (0 = off)
Excel J21 — default OFF
Add Worker
✓ Excel stress-test PASSvs Salary to Day Rate Calc_.xlsx
✓ uplifted £/hr: 28.639 (exp 28.639)✓ charge £/hr: 31.019 (exp 31.019)✓ fee £/wk: 85.192 (exp 85.192)✓ margin %: 6.866 (exp 6.866)
Uplifted Rates — Hourly
Holiday accrual 12.07% · NI 15% (all earnings)· Pension 3% (AE bands) · Mark-up 11% on base
| Worker | Base | Holiday | Base+Holiday | Emp. NI | Levy | Pension | Total cost | Uplifted | Bill rate | Margin% | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| £1.47(12.07%) | £13.68 | £2.05 | £0.07 | £0.32 | £16.13 | £16.13/hr | £17.47/hr | 7.69%margin | |||
| £1.81(12.07%) | £16.81 | £2.52 | £0.08 | £0.41 | £19.83 | £19.83/hr | £21.48/hr | 7.68%margin | |||
| £2.61(12.07%) | £24.24 | £3.64 | £0.12 | £0.64 | £28.63 | £28.63/hr | £31.01/hr | 7.67%margin |
Calculation breakdown — Worker 1 (£12.21/hr)
Base pay£12.21 × 40h
£488.40/wk£12.21/hr£97.68/day
Holiday uplift12.07% — 28d ÷ (260−28)
£58.94/wk£1.47/hr£11.79/day
Base + holidaycombined (NI/levy basis)
£547.34/wk£13.68/hr£109.47/day
Employers NI15% of all earnings (threshold OFF)
£82.10/wk£2.05/hr£16.42/day
Apprentice levy0.5% of base+holiday
£2.74/wk£0.07/hr£0.55/day
Employer pension3% (AE band £120–£967/wk)
£12.82/wk£0.32/hr£2.56/day
Total cost / weekuplifted assignment rate (excl. platform fee)
£645.00/wk£16.13/hr£129.00/day
Bill rate / weekbase × 1.11 + employer costs (platform cost reduces margin)
£698.73/wk£17.47/hr£139.75/day
Fee / weekmargin 7.69% · mark-up 8.33%
£53.72/wk£1.34/hr£10.74/day