Calculation guide
Use annual salaries on the same full-time basis, the number of affected monthly periods and the employment fraction. Subtract prior arrears payments.
Inputs
Prior full-time annual salary
Example entry 48000 (in the selected currency).
Revised full-time annual salary
Example entry 54000 (in the selected currency).
Affected monthly periods
Example entry 6.
Employment percentage
Example entry 80 %. Allowed range 0.0 to 100.0.
Arrears already paid
Example entry 250 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Prior full-time annual salary | 48,000 |
| Revised full-time annual salary | 54,000 |
| Affected monthly periods | 6 |
| Employment percentage | 80% |
| Arrears already paid | 250 |
| Result | Value |
|---|---|
| Gross arrears due | 2,150 |
| Monthly gross adjustment | 400 |
Calculation steps
Gross arrears due = (((((Revised full-time annual salary − Prior full-time annual salary) × Affected monthly periods) × Employment percentage) ÷ 1,200) − Arrears already paid)
(((((54,000 − 48,000) × 6) × 80) ÷ 1,200) − 250) = 2,150
Monthly gross adjustment = (((Revised full-time annual salary − Prior full-time annual salary) × Employment percentage) ÷ 1,200)
(((54,000 − 48,000) × 80) ÷ 1,200) = 400
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 |
|---|---|---|---|---|---|
| Prior full-time annual salary | 48,000 | 52,800 | Gross arrears due | 2,150 | 230 |
| Revised full-time annual salary | 54,000 | 59,400 | Gross arrears due | 2,150 | 4,310 |
| Affected monthly periods | 6 | 7 | Gross arrears due | 2,150 | 2,550 |
| Employment percentage | 80% | 88% | Gross arrears due | 2,150 | 2,390 |
| Arrears already paid | 250 | 275 | Gross arrears due | 2,150 | 2,125 |
