Calculation guide
All recurring amounts are weekly and after tax. Replacement pay is capped per week. Include other weekly household income and one-time leave costs.
Inputs
Weeks of leave
Example entry 10. Allowed range 1.0 to 520.0. Use whole numbers.
Usual weekly pay
Example entry 1000 (in the selected currency).
Pay replacement rate
Example entry 60 %. Allowed range 0 to 100.
Weekly benefit cap
Example entry 500 (in the selected currency).
Other weekly income
Example entry 200 (in the selected currency).
Weekly household spending
Example entry 800 (in the selected currency).
One-time costs
Example entry 500 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Weeks of leave | 10 |
| Usual weekly pay | 1,000 |
| Pay replacement rate | 60% |
| Weekly benefit cap | 500 |
| Other weekly income | 200 |
| Weekly household spending | 800 |
| One-time costs | 500 |
| Result | Value |
|---|---|
| Funding shortfall | 1,500 |
| Total replacement pay | 5,000 |
| Total expenses | 8,500 |
Calculation steps
Funding shortfall = max(0, ((Weeks of leave × ((Weekly household spending − Other weekly income) − min(Weekly benefit cap, ((Usual weekly pay × Pay replacement rate) ÷ 100)))) + One-time costs))
max(0, ((10 × ((800 − 200) − min(500, ((1,000 × 60) ÷ 100)))) + 500)) = 1,500
Total replacement pay = (Weeks of leave × min(Weekly benefit cap, ((Usual weekly pay × Pay replacement rate) ÷ 100)))
(10 × min(500, ((1,000 × 60) ÷ 100))) = 5,000
Total expenses = ((Weeks of leave × Weekly household spending) + One-time costs)
((10 × 800) + 500) = 8,500
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Weeks of leave | 10 | 11 | Funding shortfall | 1,500 | 1,600 |
| Usual weekly pay | 1,000 | 500 | Funding shortfall | 1,500 | 3,500 |
| Pay replacement rate | 60% | 30% | Funding shortfall | 1,500 | 3,500 |
| Weekly benefit cap | 500 | 550 | Funding shortfall | 1,500 | 1,000 |
| Other weekly income | 200 | 220 | Funding shortfall | 1,500 | 1,300 |
| Weekly household spending | 800 | 880 | Funding shortfall | 1,500 | 2,300 |
| One-time costs | 500 | 550 | Funding shortfall | 1,500 | 1,550 |
