Calculation guide
Start the first band at zero and enter subsequent lower thresholds in ascending order; the last band has no upper limit. Only this marginal tax applies.
Gross pay = sum of net pay in each band divided by its retained fraction.
Inputs
Target take-home pay
Example entry 32000 (in the selected currency).
Gross income at start of band
Example entry 0 (in the selected currency).
Marginal tax rate
Example entry 10 %. Allowed range 0.0 to 99.99.
Worked example
| Input | Value |
|---|---|
| Target take-home pay | 32,000 |
Marginal tax bands
| Gross income at start of band | Marginal tax rate |
|---|---|
| 0 | 10% |
| 10,000 | 20% |
| 30,000 | 30% |
| Result | Value |
|---|---|
| Required gross pay | 40,000 |
| Total marginal-band tax | 8,000 |
| Effective tax rate | 20% |
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 |
|---|---|---|---|---|---|
| Target take-home pay | 32,000 | 35,200 | Required gross pay | 40,000 | 44,571.428571 |
| Gross income at start of band (row 2) | 10,000 | 11,000 | Required gross pay | 40,000 | 39,857.142857 |
| Marginal tax rate (row 1) | 10% | 11% | Required gross pay | 40,000 | 40,142.857143 |
