🇳🇬 NTA 2025 Payroll Reverse Calculator
Goal Seek: Calculate Gross Pay based on inputs.
| Employee | Gross Pay (The Unknown) |
Rent Paid REQUIRED For Relief |
Pension REQUIRED (Input Amount) |
BIK (Value) (Deducted from Net) |
Life Assurance (Deductible) |
Mortgage Int. (Deductible) |
Taxable Inc. (Calculated) |
PAYE Tax (Calculated) |
Net Pay TARGET |
|
|---|---|---|---|---|---|---|---|---|---|---|
How to use Goal Seek (Reverse Calc)
1. Enter the target Net Pay in the green column.
2. Enter required fixed values (Rent, Pension, BIK, etc.).
3. Click the orange "Reverse Calc" button.
The system will calculate the exact Gross Pay needed to achieve that Net Pay.
Paste from Excel
You can copy multiple rows from Excel and paste them directly into the table. Ensure your Excel columns match the order of the inputs (Gross, Rent, Pension, BIK, etc.) before pasting.
Annual vs. Monthly Toggle
Use the toggle switch at the top to change the calculation mode.
Important: Switching modes will automatically clear all figures to prevent calculation errors (mixing annual figures with monthly formulas).
Understanding Deductions
Pension, Life Assurance, Mortgage Interest: These are Tax Deductible (reduce your Taxable Income) AND are deducted from your final Net Pay.
BIK (Benefit in Kind): Added to Gross for tax calculation, then deducted from Net Pay.