ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   where can i find uk tax and national insurance calculations (https://www.excelbanter.com/excel-discussion-misc-queries/26551-where-can-i-find-uk-tax-national-insurance-calculations.html)

Dr.AJ

where can i find uk tax and national insurance calculations
 
i want to set up a template for calculating take home pay after tax national
insurance etc. I would like to enter salary or hourly rate plus tax
code/allowance. I'm trying to balance possible
outgoings(rent,rates,gas,electric etc.) against salary required. i.e how
much would i need to earn if i have a bedsit @ 90 pw or a 1 bed flat @ 130pw,
diferent addresses might increase petrol used per week by 10pound or area
might increase car insurance by 100 pound, all effecting outgoins so
increasing salary requirements.

Peo Sjoblom

I'd suggest you go to a UK government site to get those rates

for a way to do marginal rates calculations onmce you have the rates see:


http://www.mcgimpsey.com/excel/variablerate.html



Regards,

Peo Sjoblom

"Dr.AJ" wrote:

i want to set up a template for calculating take home pay after tax national
insurance etc. I would like to enter salary or hourly rate plus tax
code/allowance. I'm trying to balance possible
outgoings(rent,rates,gas,electric etc.) against salary required. i.e how
much would i need to earn if i have a bedsit @ 90 pw or a 1 bed flat @ 130pw,
diferent addresses might increase petrol used per week by 10pound or area
might increase car insurance by 100 pound, all effecting outgoins so
increasing salary requirements.



All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com