Simple Pound

A trip down personal finance lane.
  • rss
  • Home
  • About
  • Best Of…
  • Progress
  • Library
  • Book reviews
  • Archive
  • Contact

What the taxman claims

April 13, 2007

Note: an updated version of this post for 2008/09 can be found here.

When I first read through my job offer I couldn’t have been happier with my stated salary and benefits package and I starting daydreaming immediately. However, once I realised how much money would actually end up in my account and how much of that nice sum would go into Her Majesty’s pockets, life suddenly seemed a lot crueller. It took me a while to understand how the UK tax system works and I thought I would share my newly-gained knowledge with you! :-)

First things first: income tax. Any UK resident in employment has a personal allowance of at least £5,225 for the tax year 2007/08 - you can get more if you’re older than 65 or blind, but I’m assuming the majority of my readers won’t be… This personal allowance means that you won’t pay tax on the first £5,225 you earn per tax year (starting April 6th, 2007).

The next £2,230 you earn during 2007/08 will be taxed at a starting rate of 10%. The basic rate of 22% covers all money earned that exceeds £7,455 (= £5,225 + £2,230) up to a total amount of £39,825. That means, for the next £32,370 earned after you covered your personal allowance and starting tax rate in full, you will pay 22 pence of every pound earned to the government. Anything that exceeds the £39,825 will be taxed with the higher rate of 40%.

You can find an overview of the 2007/08 tax rates here. But beware that HM Revenue & Customs quotes the values without taking account of the personal allowance. The values in their table should look familiar if I’ve done a good enough job of explaining how I got to the abovementioned values.

Once you’ve paid all your tax duties, there’s another institution patiently waiting in line to grab their share of your money: National Insurance. This money is used to fund the NHS, social security, job seeker’s benefits and the like. National insurance contributions highly confused me - but, good news, I’ve got them figured out! :-D

The two important values for your NI contributions are the earning threshold and the upper earning limit. The earning threshold is currently set at £5,225 (does that value look familiar to you? ;-) ) and you are exempt from NI contributions up to this amount. For any annual income that lies between the earning threshold and the upper earning limit of £34,840 you need to contribute 11% of your salary (if it’s any consolation: your employer needs to pay 12.8% for your whole salary, without caps). Anything beyond £34,840 is taxed at 1%, which means that those poor folks paying 40% income tax get at least a little relief with NI.

Now you are probably thinking: “Those numbers really confuse me… I just want to know what money is gonna come into my account each month… Does it have to be this difficult?” The answer is - No.

I’ve been procrastinating hugely and set up an Excel sheet that will give you a detailed breakdown of all the things I’ve discussed in this post - but with numbers relevant to your situation! All you have to do is download the spreadsheet here, type in your annual salary (as given in your contract) and any bonuses you might be expecting. Once you’ve done that and also resisted the urge of changing the formulae behind the individual cells, you’ll see a breakdown of

  • your share of taxes at 10%, 22% and 40% (if applicable)
  • your total tax contributions for the tax year 2007/08
  • your annual salary after tax deductions
  • your NI contributions at 11% and 1% (if applicable)
  • your annual NI contributions
  • your annual salary after tax and NI contributions
  • and finally: your net monthly salary, i.e. the money that should end up in your hands/pockets/wallet/purse

Hope you enjoy playing with the Excel sheet… I certainly do… :-)

Once I’m actually receiving that salary I’ve based my own calculations on, I will let you know whether my predictions came out right! Any questions? Leave a comment.

Update: Upon request I have updated the Excel sheet to include student loan repayments. According to Student Finance Direct you must earn at least £15,000 per annum to be required to pay back your student loan. If you exceed this amount, you need to repay 9% of everything beyond this threshold, i.e. if you get £20,000 a year, you are required to pay 9% of (£20,000 - £15,000 =) £5,000 back to the loan company.

The spreadsheet does not account for your individual circumstances. That means, if the calculated amount exceeds what you have left to pay back, you’re lucky! :-)

Since the student loan repayments won’t necessarily apply to everyone out there who might think this spreadsheet could be of any use, you will see two different numbers for monthly salaries in the spreadsheet now: before and after student loan repayments.

Enjoy!

Bookmark It

Add to Del.icio.us Add to digg Add to Facebook Add to Google Bookmarks Add to Newsvine Add to reddit Add to Stumble Upon Add to Technorati Add to Yahoo My Web
Hide Sites
Categories
Misc, Popular
Tags
national insurance, spreadsheets, tax
Comments rss
Comments rss
Trackback
Trackback

« Insights First Milestone »

10 responses

OK, I have a question for you. PhD income is

Luke Church | April 13, 2007 | 3:41 pm

OK, I have a question for you. PhD income is not taxable through some mechanism that I don’t understand.

My question is how much can I earn *as well* as my PhD stipend before I start paying income tax, further, once I start paying tax, I assume that I only pay tax on my income, I don’t suddenly have to magically start paying tax on my PhD stipend as well?

(And don’t worry, I know that ‘not a lawyer stuff’, I’m not asking you for an opinion to stand up in court, it just seemed that it might be of interest to your audience)

That's a tough one. Ok, based on my understanding and

Kirsten | April 13, 2007 | 4:00 pm

That’s a tough one. Ok, based on my understanding and assuming the information you were given that the PhD money won’t be taxed is correct, you should be able to earn an additional 5,225 pounds (or whatever the personal allowance is) a (tax) year…

Having said that, the government might well not use the common sense approach here (i.e. special rules/regulations applying for PhD students), so to be on the safe side I would simply contact the University… they should know for sure. And if they don’t, HM Revenue & Customs will hopefully be able to give you a conclusive answer… :-) (get it in writing!)

PS: No one ever asked me to mention the money

Kirsten | April 13, 2007 | 4:02 pm

PS: No one ever asked me to mention the money from my scholarship in my tax forms… hence I believe the PhD allowance should be *reasonably* safe ;-)

Hey That's a useful spreadsheet, but seeing as your shiny new

Sparkie | April 13, 2007 | 7:49 pm

Hey

That’s a useful spreadsheet, but seeing as your shiny new site has a ’student’ theme to it can you add another expense to the list: Student Loan repayments!

Cheers
Rob

Done :-)

Kirsten | April 13, 2007 | 8:54 pm

Done :-)

Thank you - now I can see even more money

Sparkie | April 14, 2007 | 12:40 am

Thank you - now I can see even more money disappearing away :-(

** Decides to delay getting a job and worrying about earnings **

Great spreadsheet :-) Just thought I'd point out something that might

Adrien | April 15, 2007 | 4:34 pm

Great spreadsheet :-)

Just thought I’d point out something that might get misinterpreted:

the NI earning threshold is currently set at £5,225 (does that value look familiar to you? ;-) ) and you are exempt from NI contributions up to this amount.

I believe the earning threshold is actually on a weekly basis ( about £100/week ). Whilst this makes no difference to full-time employees, it does mean that students are unable to claim back NI contributions for say summer internships - even if their total income over the year was under £5225, their weekly income probably was over £100, hence the contributions.

Thanks for clarifying :-) I didn't know that... but then

Kirsten | April 16, 2007 | 6:08 pm

Thanks for clarifying :-) I didn’t know that… but then my NI for the summer internship was messed up anyway, which is why I didn’t bother to even try to claim any of it back :-D

Great little tool Kirsten! Having recently been given a pay

Money Watch | April 16, 2007 | 9:34 pm

Great little tool Kirsten! Having recently been given a pay rise, and not knowing how much I was going to be earning a month, this has helped me out.

Cheers,

Rob
http://money-watch.co.uk

How Much Tax Will I Pay?... An Excel sheet to help

Money Watch | April 16, 2007 | 10:25 pm

How Much Tax Will I Pay?…

An Excel sheet to help you work out how much Income Tax and National Insurance you pay.
……

Leave a comment

You can use these tags : <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Net Worth

39.2%

Categories

  • Budgeting (6)
  • General (11)
  • Goals (7)
  • Housing (8)
  • Insurance (1)
  • Investing (36)
    • Bonds (5)
    • Funds (13)
    • Shares (3)
  • Misc (15)
  • News (17)
  • Popular (11)
  • Read this! (20)
  • Reviews (19)
    • Books (3)
    • End of month (16)
  • Savings (16)
  • Uncategorized (1)

Library

I am reading...

Just finished...
The Art of Asset Allocation
The Essays of Warren Buffet

Blogroll

  • Dividend Money
  • Fat Pitch Financials
  • Get Rich Slowly
  • I Will Teach You To Be Rich
  • Money Watch (UK)
  • Money, Matter, and More Musings
  • MoneyPot (UK)
  • My Open Wallet
  • My Wealth Builder
  • No Credit Needed
  • Plonkee Money (UK)
  • Punny Money
  • The Digerati Life
  • The Dividend Guy Blog
  • The Finance Buff
  • The Simple Dollar
  • This is Money (UK)
  • Well-Heeled
  • Wise Bread

Financial Sites

  • Digital Look
  • Fool
  • Morningstar (UK)
  • Totally Money

Sponsors

Financial Web
Information about everything from Debt Consolidation to Credit Cards

Tags

Asia bank charges bond prices Bonds Books Budgeting calculations compound interest CPI credit risk Dilbert downloads emergency fund end of month Europe Excel Fixed Income funds Goals graduates house prices index tracker inflation interest rates Investing ISA national insurance net worth News overdraft charges parents piano portfolio quotes risk return Savings Shares Simple Dollar spreadsheets statistics stock indices student loans tax Tom Brennan Zopa
rss Comments rss valid xhtml 1.1 design by jide powered by Wordpress get firefox