We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

I've made a brilliant spreadsheet and want to share it!

13»

Comments

  • Right, I'll tinker with it for a few minutes and hopefully it will be self explainatory. I'm doing some uni coursework tonight so I haven't got time to offer any full instructions... :)

    Gimme 5 minutes and I'll host it up somewhere.
  • http://s24.quicksharing.com/v/2584617/Toms_Super_Snowball_and_Budget_Calc_Spread_Sheet.xls.html

    Click "Download File".

    I've added a few comments in red boxs, there are lots of tabs along the bottom, just click away, add all your figures in and bingo!!

    I love manipulating figures (overpayments etc) to see how it brings the DFD down! :D:D:D:D

    Good luck with it, please post comments here.
  • oscar52
    oscar52 Posts: 2,272 Forumite
    Not sure if its viable or not, but I have a wage calculator - works out the tax an NI on wages overtime and incentives (based on a 503L) tax code. Is extremely accuarte - was out last month by 14p (and i got paid £1700 gross)

    Might help some, as you know exactly how much you'll have coming in a month in advance.
    No Longer works for MBNA as of August 2010 - redundancy money will be nice though.

    Proud to be a Friend of Niddy.
    no idea what my nerdnumber is - i am now officially nerd 229, no idea on my debt free date
  • I too have one on the one I use personally, but thought I'd try and keep the spread sheet fairly simple until I have the chance to add some full instructions. :)
  • oscar52
    oscar52 Posts: 2,272 Forumite
    one i have made (rather crudely) only needs 3 bits of info,
    Gross annual wage
    Hours overtime(based on 1.5*)
    incentive amount

    Then it all gets calculated automatically
    No Longer works for MBNA as of August 2010 - redundancy money will be nice though.

    Proud to be a Friend of Niddy.
    no idea what my nerdnumber is - i am now officially nerd 229, no idea on my debt free date
  • Cool. I just think wages and tax vary so much, different allowances and tax credits, company cars and the such like I left it out. :)

    Have you filled the sheet in yet - want to know your debt free date! :D
  • oscar52
    oscar52 Posts: 2,272 Forumite
    I have to admit i havnt:embarasse just for the simple fact my wages arnt the same every month - i dont always have the same level of OT or the same incentive - but It is very handy and easy to use.

    I agree with your last post too, company cars, medical schemes and a whole host of other things can affect your tax payment (such as student loans :mad: - my payments dont even meet the interest - wonder if that classes them as a loan shark? :rotfl: )

    It works fine for me, but I realise there can be several reasons it wouldnt for others.
    No Longer works for MBNA as of August 2010 - redundancy money will be nice though.

    Proud to be a Friend of Niddy.
    no idea what my nerdnumber is - i am now officially nerd 229, no idea on my debt free date
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 354.3K Banking & Borrowing
  • 254.4K Reduce Debt & Boost Income
  • 455.4K Spending & Discounts
  • 247.2K Work, Benefits & Business
  • 603.9K Mortgages, Homes & Bills
  • 178.4K Life & Family
  • 261.4K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.