Is there a useful calculator out there, to work out how much I'll be taxed if I take it? (I know how much I'll be getting before tax).
All the ones on google appear to be focused on statutory redundancy pay, which I'm guessing you don't get if your organisation has enhanced redundancy package (?), and how much pay I'll be entitled to (which I already know).
Or alternatively, does anyone have a pre-prepared spreadsheet template they could send me?
Are you getting more than £30k anything more than £30k will be taxed at what is referred to as your "marginal rate". The first £30k is a tax free allowance.
To work out your marginal rate you need to know what you will earn in the whole tax year 6 april 24 to 5 april 25 before the redundancy pay ( so obviously depend on whether you are then going to work elsewhere after the redundancy)
So if those 24-25 earning are under £50k then you get some tax at 20% but then potentially some at 40% as the
redundancy money in excess of £30k acts as your top slice of income. see below table.
However is slightly more complicated than that simple table if your total pot goes over £100k as you lose £1 of the 12570 0% band/ personnel allowance for every £2 earned over £100k, so effectively anything in between £100K and £125140 is taxed at 60%
Also, any pay in lieu of notice and pay for holidays owed cant be included in your £30k tax free part, it just gets taxed as normal pay.*
* sometimes you can waive your right to pay in lieu of notice and if that was going to be worth say £2k and your redundancy was £20k, you could get your employer to enhance the redundancy to £22k and you waive the PILON. Clearly this is only worth doing if the normal redundancy is under £30k.
So if for example you reckon you will earn £40k this tax year 24-25 as a combo of to date pay plus future jobs, and your redundancy settlement is £35k plus £2k pay in lieu of notice/holidays (£37k in total)
£30k you pay no tax.
£7k (the remaining £5k from redunc and the £2k pilon) will be taxed at your marginal rate of 20%.
but if your 24-25 earnings will be £60k, that £7k will be taxed at 40%
and if you are lucky/ unlucky enough to have 24-25 earnings of £110k then the £7k will be taxed at 60%
hope that helps