Paid parental leave budget shortfall · Calculation guide

Compare household spending with paid leave income over the leave period.

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.

gap = max(0,weeks*(spend-other-min(cap,pay*share/100))+once) · benefits = weeks*min(cap,pay*share/100) · expenses = weeks*spend+once

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

InputValue
Weeks of leave10
Usual weekly pay1,000
Pay replacement rate60%
Weekly benefit cap500
Other weekly income200
Weekly household spending800
One-time costs500
ResultValue
Funding shortfall1,500
Total replacement pay5,000
Total expenses8,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Weeks of leave1011Funding shortfall1,5001,600
Usual weekly pay1,000500Funding shortfall1,5003,500
Pay replacement rate60%30%Funding shortfall1,5003,500
Weekly benefit cap500550Funding shortfall1,5001,000
Other weekly income200220Funding shortfall1,5001,300
Weekly household spending800880Funding shortfall1,5002,300
One-time costs500550Funding shortfall1,5001,550
Paid parental leave budget shortfall →