Your browser isn't supported
It looks like you're using an old web browser. To get the most out of the site and to ensure guides display correctly, we suggest upgrading your browser now. Download the latest:

Welcome to the MSE Forums

We're home to a fantastic community of MoneySavers but anyone can post. Please exercise caution & report spam, illegal, offensive or libellous posts/messages: click "report" or email forumteam@.

    • Foraminiferum
    • By Foraminiferum 11th Nov 17, 7:15 PM
    • 7Posts
    • 0Thanks
    Excel spreadsheet to do "What If" for next tax year?
    • #1
    • 11th Nov 17, 7:15 PM
    Excel spreadsheet to do "What If" for next tax year? 11th Nov 17 at 7:15 PM
    Has anyone come across an Excel spreadsheet which could duplicate the HMRC Self Assessment calculations for the current year and for a future year (having plugged in the appropriate tax rates)?

    I have gone some way towards creating one for myself, but would like to check its results. The MSE Income Tax Checker is absolutely no use for me.

    Briefly, the Excel spreadsheet would need to take care of
    • No job (retired)
    • Company pension (taxed) and state pension, putting me in 40% tax bracket
    • Small amounts of untaxed interest on UK investments
    • Charitable giving including Gift Aid
    Fairly straightforward - allegedly...
    However, on an annual basis I am surprised by how HMRC deals with charitable giving.
Page 1
    • Dazed and confused
    • By Dazed and confused 11th Nov 17, 7:41 PM
    • 2,470 Posts
    • 1,179 Thanks
    Dazed and confused
    • #2
    • 11th Nov 17, 7:41 PM
    • #2
    • 11th Nov 17, 7:41 PM
    It will be anything but simple, ignoring the additional rate you have four possible rate bands just for the untaxed interest although two won't, based on your op, apply to you.

    Gift aid is straightforward, the gross amount i.e. your payment plus the basic rate tax relief the charity claims, increases the amount you can pay 20% tax on.

    And I'm assuming you aren't a Scottish resident for tax purposes
Welcome to our new Forum!

Our aim is to save you money quickly and easily. We hope you like it!

Forum Team Contact us

Live Stats

569Posts Today

5,902Users online

Martin's Twitter
  • I've decided my weekend starts here while the sun's glow is still baskable. So I'm signing off. Have a great weeke?

  • No not correct. The big six do, but you can get fixed tariffs guaranteed not to rise and about 25% cheaper. Just tr?

  • Baaaa! Scottish Power has bleated and followed the herd, today announcing it's putting up energy prices by 5.5%. R?

  • Follow Martin