Hello all,
I'm pretty new to Excel and I have learnt the basics over the past couple of weeks but i'm really struggling now i'm trying to add more in depth formulas.
Basically I have just starting my own company and I have created a basic Excel template for my accounts but I would like to add to the total a percentage for tax and national insurance once the total goes over a certain amount but only on the wages not the dividends
National Insurance:
Class 2 if your profits are £6,025 or more a year (£2.85 a week)
Class 4 if your profits are £8,164 or more a year (9% on profits between £8,164 and £45,000, 2% on profits over £45,000)
Income TAX:
£11,501 - £45,000 20 per cent (basic rate)
£45,001 - £150,000 40 per cent (higher rate)
Over £150,000 45 per cent (additional rate)
I have attached the excel file for you to have a look at
Thanks
James
Bookmarks