In this video, we'll cover how to calculate your 2021-22 UK National Insurance (employed) payment in Excel. Paying National Insurance is based on a progressive system meaning that if have a higher income then you pay a higher rate. The main difference in 2021-22 compared to last year is that the National Insurance thresholds have increased slightly to £9,568 and £50,270, while the NI rates have remained the same. What we want to do in this video is create a calculator which allows you to input a taxable income figure and automatically retrieve your annual National Insurance payment. We’re going to start by calculating the inputs which will first involve setting up a calculation table. Following this, we'll perform intermediary calculations which we will use to calculate the annual NI payment.
DISCLAIMER: Although I have taken great care to check all of the calculations, I am not a qualified accountant and you should not use this video to substitute financial advice. Make sure you talk to your own accountant before you use this calculator to make any financial decisions.
2020-21 UK National Insurance rates and bands:
https://www.gov.uk/national-insurance/how-much-you-pay
Calculate 2022-23 UK Income Tax in Excel:
https://youtu.be/WR3o2Dw7u7E
Calculate 2020-21 UK National Insurance:
https://youtu.be/cPnqR8Vbumk
VLOOKUP Function Tutorial:
https://youtu.be/KvS-1o1C--g
Subscribe for weekly Excel tutorials, techniques and examples:
https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation1
Please share this video with others that may find it useful:
https://youtu.be/153OqYdPLog
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
The Excel Hub website: https://theexcelhub.com/
Instagram: https://www.instagram.com/theexcelhub/
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]Overview: (0:00)
Format Table: (1:05)
Intermediary Calculations: (2:38)
Calculate Annual NI Payment: (4:43)