Skip to content

Latest commit

 

History

History
114 lines (107 loc) · 15 KB

EXAMPLES.md

File metadata and controls

114 lines (107 loc) · 15 KB

Examples: National Insurance contributions and Tax calculations (Tax year 2016-17)

  • National Insurance contributions table (illustrated using both annual and monthly gross salaries):

    ------------------------+---------------+----------------------------+-----------------------------+------------------
                            |  NI           |                            |                             |
                            |  Deductible   | Basic contributions        |    Higher contributions     |  
                            |  Income       | (£8,060.00 - £43,000.00)   |    (above £43,000.00)       |   Total
     Annual Gross Salary /  |  after        |                            |                             |   National 
     Monthly Gross Salary   |  deducting    |           12%              |             2%              |   Insurance
             (£)            |  £8,060 from  +------------+---------------+-------------+---------------|   contributions
                            |  annual gross |   Excess   |               |   Excess    |               |       (£)
                            |  salary       |   Income   | Contributions |   Income    | Contributions |
    ------------------------+---------------+------------+---------------+-------------+---------------+------------------
              5,000.00      |        0.00   |       0.00 |         0.00  |       0.00  |         0.00  |        0.00
                416.67      |        0.00   |       0.00 |         0.00  |       0.00  |         0.00  |        0.00
    ------------------------+---------------+------------+---------------+-------------+---------------+------------------
              8,060.00      |        0.00   |       0.00 |         0.00  |       0.00  |         0.00  |        0.00
                671.67      |        0.00   |       0.00 |         0.00  |       0.00  |         0.00  |        0.00
    ------------------------+---------------+------------+---------------+-------------+---------------+------------------
              9,060.00      |    1,000.00   |   1,000.00 |       120.00  |       0.00  |         0.00  |      120.00
                755.00      |       83.33   |      83.33 |        10.00  |       0.00  |         0.00  |       10.00
    ------------------------+---------------+------------+---------------+-------------+---------------+------------------
             40,000.00      |   31,940.00   |  31,940.00 |     3,832.80  |       0.00  |         0.00  |    3,832.80
              3,333.33      |    2,661.67   |   2,661.67 |       319.40  |       0.00  |         0.00  |      319.40
    ------------------------+---------------+------------+---------------+-------------+---------------+------------------
             43,000.00      |   34,940.00   |  34,940.00 |     4,192.80  |       0.00  |         0.00  |    4,192.80
              3,583.33      |    2,911.67   |   2,911.67 |       349.40  |       0.00  |         0.00  |      349.40
    ------------------------+---------------+------------+---------------+-------------+---------------+------------------
             45,000.00      |   36,940.00   |  34,940.00 |     4,192.80  |   2,000.00  |        40.00  |    4,232.80
              3,750.00      |    3,078.33   |   2,911.67 |       349.40  |     166.67  |         3.33  |      352.73
    ------------------------+---------------+------------+---------------+-------------+---------------+------------------
             50,000.00      |   41,940.00   |  34,940.00 |     4,192.80  |   7,000.00  |       140.00  |    4,332.80
              4,166.67      |    3,495.00   |   2,911.67 |       349.40  |     583.33  |        11.67  |      361.07
    ------------------------+---------------+------------+---------------+-------------+---------------+------------------
             60,000.00      |   51,940.00   |  34,940.00 |     4,192.80  |  17,000.00  |       340.00  |    4,532.80
              5,000.00      |    4,328.33   |   2,911.67 |       349.40  |   1,416.67  |        28.33  |      377.73
    ------------------------+---------------+------------+---------------+-------------+---------------+------------------
    
  • Tax calculation table (illustrated using both annual and monthly gross salaries):

    ------------------------+-------------+-------------+-------------------------+---------------------------+------------------------+---------------
                            |             |             |   Basic rate band       |    Higher rate band       |  Additional rate band  |
                            |             |  Taxable    |   (between £11,000.00   |    (between £43,000.00    |  (above £150,000.00)   |  
                            |  Personal   |  Income     |   and £43,000.00)       |    and £150,000.00)       |                        |     Total 
     Annual Gross Salary /  |  Allowance  |  after      |                         |                           |                        |     Tax  
     Monthly Gross Salary   |  (Tax-free  |  deducting  |           20%           |            40%            |           45%          |     Payable
             (£)            |  Allowance) |  Personal   +------------+------------+-------------+-------------+-----------+------------+       (£)
                            |             |  Allowance  |  Excess    |   Tax      |   Excess    |    Tax      |  Excess   |   Tax      | 
                            |             |             |  Income    |   Payable  |   Income    |    Payable  |  Income   |   Payable  |
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
              5,000.00      |  11,000.00  |       0.00  |       0.00 |      0.00  |        0.00 |       0.00  |      0.00 |      0.00  |        0.00
                416.67      |     916.67  |       0.00  |       0.00 |      0.00  |        0.00 |       0.00  |      0.00 |      0.00  |        0.00
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
             11,000.00      |  11,000.00  |       0.00  |       0.00 |      0.00  |        0.00 |       0.00  |      0.00 |      0.00  |        0.00
                916.67      |     916.67  |       0.00  |       0.00 |      0.00  |        0.00 |       0.00  |      0.00 |      0.00  |        0.00
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
             12,000.00      |  11,000.00  |   1,000.00  |   1,000.00 |    200.00  |        0.00 |       0.00  |      0.00 |      0.00  |      200.00
              1,000.00      |     916.67  |      83.33  |      83.33 |     16.67  |        0.00 |       0.00  |      0.00 |      0.00  |       16.67
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
             40,000.00      |  11,000.00  |  29,000.00  |  29,000.00 |  5,800.00  |        0.00 |       0.00  |      0.00 |      0.00  |    5,800.00
              3,333.33      |     916.67  |   2,416.67  |   2,416.67 |    483.33  |        0.00 |       0.00  |      0.00 |      0.00  |      483.33
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
             45,000.00      |  11,000.00  |  34,000.00  |  32,000.00 |  6,400.00  |    2,000.00 |     800.00  |      0.00 |      0.00  |    7,200.00
              3,750.00      |     916.67  |   2,833.33  |   2,666.67 |    533.33  |      166.67 |      66.67  |      0.00 |      0.00  |      600.00
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
             50,000.00      |  11,000.00  |  39,000.00  |  32,000.00 |  6,400.00  |    7,000.00 |   2,800.00  |      0.00 |      0.00  |    9,200.00
              4,166.67      |     916.67  |   3,250.00  |    2666.67 |    533.33  |      583.33 |     233.33  |      0.00 |      0.00  |      766.67
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
             60,000.00      |  11,000.00  |  49,000.00  |  32,000.00 |  6,400.00  |   17,000.00 |   6,800.00  |      0.00 |      0.00  |   13,200.00
              5,000.00      |     916.67  |   4,083.33  |   2,666.67 |    533.33  |    1,416.67 |     566.67  |      0.00 |      0.00  |    1,100.00
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
            100,000.00      |  11,000.00  |  89,000.00  |  32,000.00 |  6,400.00  |   57,000.00 |  22,800.00  |           |            |      
                            |             |             |            |            |       +0.00 |      +0.00  |           |            |
                            |             |             |            |            |  =57,000.00 | =22,800.00  |      0.00 |      0.00  |   29,200.00                                           
              8,333.33      |     916.67  |   7,416.67  |   2,666.67 |    533.33  |    4,750.00 |   1,900.00  |      0.00 |      0.00  |    2,433.33
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
            105,500.00*     |   8,250.00  |  97,250.00* |  32,000.00 |  6,400.00  |   62,500.00 |  25,000.00  |           |            |
                            |             |             |            |            |   +2,750.00 |   1,100.00  |           |            |
                            |             |             |            |            |  =65,250.00 | =26,100.00  |      0.00 |      0.00  |   32,500.00*
              8,791.67      |     687.50  |    8,104.17 |   2,666.67 |    533.33  |    5,437.50 |   2,175.00  |      0.00 |      0.00  |    2,708.33
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
            111,000.00*     |   5,500.00  | 105,500.00* |  32,000.00 |  6,400.00  |   68,000.00 |  27,200.00  |           |            |
                            |             |             |            |            |   +5,500.00 |   2,200.00  |           |            | 
                            |             |             |            |            |  =73,500.00 | =29,400.00  |      0.00 |      0.00  |   35,800.00* 
              9,250.00      |     458.33  |   8,791.67  |   2,666.67 |    533.33  |    6,125.00 |   2,450.00  |      0.00 |      0.00  |    2,983.33
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
            122,000.00*     |       0.00  | 122,000.00* |  32,000.00 |  6,400.00  |   79,000.00 |  31,600.00  |           |            |
                            |             |             |            |            |  +11,000.00 |  +4,400.00  |           |            | 
                            |             |             |            |            |  =90,000.00 | =36,000.00  |      0.00 |      0.00  |   42,400.00* 
             10,166.67      |       0.00  |  10,166.67  |   2,666.67 |    533.33  |    7,500.00 |   3,000.00  |      0.00 |      0.00  |    3,533.33
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
            130,000.00*     |       0.00  | 130,000.00* |  32,000.00 |  6,400.00  |   87,000.00 |  38,400.00  |           |            |
                            |             |             |            |            |  +11,000.00 |  +4,400.00  |           |            |               
                            |             |             |            |            |  =98,000.00 | =39,200.00  |      0.00 |      0.00  |   45,600.00*                                                                                   
             10,833.33      |       0.00  |  10,833.33  |   2,666.67 |    533.33  |    8,166.67 |   3,266.67  |      0.00 |      0.00  |    3,800.00
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
            150,000.00*     |       0.00  | 150,000.00* |  32,000.00 |  6,400.00  |  107,000.00 |  42,800.00  |           |            |
                            |             |             |            |            |  +11,000.00 |  +4,400.00  |           |            |
                            |             |             |            |            | =118,000.00 | =47,200.00  |      0.00 |      0.00  |   53,600.00*
             12,500.00      |       0.00  |  12,500.00  |   2,666.67 |    533.33  |    9,833.33 |   3,933.33  |      0.00 |      0.00  |    4,466.67
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
            160,000.00*     |       0.00  | 160,000.00* |  32,000.00 |  6,400.00  |  107,000.00 |  42,800.00  |           |            |
                            |             |             |            |            |  +11,000.00 |  +4,400.00  |           |            |
                            |             |             |            |            | =118,000.00 | =47,200.00  | 10,000.00 |  4,500.00  |   58,100.00*
             13,333.33      |       0.00  |  13,333.33  |   2,666.67 |    533.33  |    9,833.33 |   3,933.33  |    833.33 |    375.00  |    4,841.67
                            |             |             |            |            |             |             |           |            |
    ------------------------+-------------+-------------+------------+------------+-------------+-------------+-----------+------------+---------------
    

*past an Annual Gross Salary of £100,000.00, the personal allowance rules change i.e. for every extra £2 earned, the personal allowance reduces by £1. Past an annual gross salary of £122,000.00, NO personal allowance is applicable. And this excess is taxed at the Higher rate tax.

See the Calculations: National Insurance contributions and Tax section to find out what the calculations tables for both National Insurance and Tax calculations.

Go back to README.md | specification.md.