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@.

Search
  • FIRST POST
    • Little Miss Uni-Debt
    • By Little Miss Uni-Debt 13th Sep 09, 5:37 AM
    • 832Posts
    • 2,875Thanks
    Little Miss Uni-Debt
    Addicted to sums, totals & spreadsheets....Am I the only one?
    • #1
    • 13th Sep 09, 5:37 AM
    Addicted to sums, totals & spreadsheets....Am I the only one? 13th Sep 09 at 5:37 AM
    Right, I have to admit it - being on here and debt busting for nearly the last two years has turned me into a total maths geek!

    Give me a scrap of paper and a writing implement and i've covered it in numbers, worked out a formula for something and come up with an answer to a rediculous question that I've set myself in under 4minutes!!!

    I guess it comes from wanting to be in control and I feel that when I am fully aware of my situation numerically I am satisfied that I am still doing an ok job at killing my debt monster. :rolleyes:

    I was wondering if this was a phenomenon that came with MSE or is it just me?

    Some may say I probably have too much time on my hands however I think it has helped me to become far more focussed and improved my maths and excel abilities ten fold.

    Ok, so these are just some of the things that I've worked out over the past few weeks. They range from the average to the completely random.

    I am exactly 75% through my debt free journey
    My debt free date is 21st Nov which is in 2.7 months
    When I have paid everything off I will have paid a total of £115.38 per week for the last 102 weeks!!!
    Last year I took home just under 11,000 in wages and paid off over £5700 to my debt!!!
    This year I earned 17,000 and will have paid off over £7000 to my debt.
    Next year - it will be ALLLL mine

    To me this is free motivation!!

    Have any of you worked out any random facts about your debt journey to help you on the way??? Or should I just seek help right away
    Total@ LBM - Nov07 £14k - Nov 08 £5765 - Aug 09 £3k Dec 09 £998 - May 11 £6900 - Jun 12 £8k Sept12 £7k 19.5k Done - 0k to go
    DEBT FREE! Nov 15
    Proud DFW Club Member - #1073
    '1% at a time' Member - #1!
Page 1
  • JoKay
    • #2
    • 13th Sep 09, 5:49 AM
    • #2
    • 13th Sep 09, 5:49 AM
    Hi there - no, you're not alone - I have a mega spreadsheet showing income & outgoings until 2030......
    • shandypants5
    • By shandypants5 13th Sep 09, 6:23 AM
    • 2,027 Posts
    • 2,777 Thanks
    shandypants5
    • #3
    • 13th Sep 09, 6:23 AM
    • #3
    • 13th Sep 09, 6:23 AM
    I am 101% certain that I am not as good as you at maths.
    “Careful. We don't want to learn from this.”

    • Little Miss Uni-Debt
    • By Little Miss Uni-Debt 13th Sep 09, 6:24 AM
    • 832 Posts
    • 2,875 Thanks
    Little Miss Uni-Debt
    • #4
    • 13th Sep 09, 6:24 AM
    • #4
    • 13th Sep 09, 6:24 AM
    Wow I bet that's a work of art!!! :rolleyes: I bet you're super organised!!!
    Total@ LBM - Nov07 £14k - Nov 08 £5765 - Aug 09 £3k Dec 09 £998 - May 11 £6900 - Jun 12 £8k Sept12 £7k 19.5k Done - 0k to go
    DEBT FREE! Nov 15
    Proud DFW Club Member - #1073
    '1% at a time' Member - #1!
    • Little Miss Uni-Debt
    • By Little Miss Uni-Debt 13th Sep 09, 6:27 AM
    • 832 Posts
    • 2,875 Thanks
    Little Miss Uni-Debt
    • #5
    • 13th Sep 09, 6:27 AM
    • #5
    • 13th Sep 09, 6:27 AM
    It is funny as I've always hated maths and was told I was very bad at it at school!

    However when it is saving money we are talking about then it is far more interesting
    Total@ LBM - Nov07 £14k - Nov 08 £5765 - Aug 09 £3k Dec 09 £998 - May 11 £6900 - Jun 12 £8k Sept12 £7k 19.5k Done - 0k to go
    DEBT FREE! Nov 15
    Proud DFW Club Member - #1073
    '1% at a time' Member - #1!
    • Happytogetdebtfree
    • By Happytogetdebtfree 13th Sep 09, 8:02 AM
    • 6,780 Posts
    • 15,515 Thanks
    Happytogetdebtfree
    • #6
    • 13th Sep 09, 8:02 AM
    • #6
    • 13th Sep 09, 8:02 AM
    Morning I love a good spread sheet hehe I can't say I'm all thatgood at them but it does help that you can put the snowballing chart into excell how do I work out percentage of debt paid ?
    I AM A MONEY MAGNET, THEY ARE MAKING MORE MONEY FOR ME AS WE SPEAKMIKES MOB, DFW NERD 1071, DFW LHS 132!MIRACLES HAPPEN I'VE SEEN IT WITH MY OWN EYES. LBM 08£77240.69 Current outstanding total £36083.01 Paid so far = £41157.68
    • Tr@cker
    • By Tr@cker 13th Sep 09, 8:16 AM
    • 517 Posts
    • 132 Thanks
    Tr@cker
    • #7
    • 13th Sep 09, 8:16 AM
    • #7
    • 13th Sep 09, 8:16 AM
    It can become an obscession but im thinking now thats why most of us ended up here-compulsive personalities.
  • honeybear
    • #8
    • 13th Sep 09, 9:07 AM
    • #8
    • 13th Sep 09, 9:07 AM
    i'm a compulsive lister, but these days along with outgoings for shopping etc there's breakdowns of what I'm saving for Pap's 100 Days Challenge, what is going off my total debt & what my budget for any treats (if any) is. And then once I've spent it I write it all again in my spending diary!

    I need help too, don't i?

    @ LBM = £15,872.65, now £10,819.82
    AF Jan = 7/? Feb = 5/14 Mar = 14/20 Apr = 6/14 May = 2/14 June 2/14 July 0/TF Aug 1/TFv Sept 6/TF Oct 4/7

    "NEVER DOUBT YOUR OWN QUALITY"
    • gilligansyle
    • By gilligansyle 13th Sep 09, 10:08 AM
    • 4,105 Posts
    • 22,135 Thanks
    gilligansyle
    • #9
    • 13th Sep 09, 10:08 AM
    • #9
    • 13th Sep 09, 10:08 AM
    I started off with a spreadsheet, but now prefer to use a notebook, its full of anticipated spend per week, actual spend, lots of little sub totals, complete work of art; makes sense only to me, but I constantly add up the money in my purse and compare it with projected figures.

    BTW best thing I ever did was start making lists and using CASH!!
    Debts at LBM - Mortgages £128497 - non mortgage £27497 Debt now £114150109032 64300 (mortgage) Credit cards left 0



    "The days pass so fast, let's try to make each one better than the last"
    • Lemon Tree
    • By Lemon Tree 13th Sep 09, 10:33 AM
    • 9,465 Posts
    • 31,245 Thanks
    Lemon Tree
    no you're definitely not the only one, i know to the penny how much is in everyone of my accounts, i know my debt to the penny, and i know the exact month i will be debt free, how it will be achieved and how many months/years i've shaved off my dfd.
    • Buffythedebtslayer
    • By Buffythedebtslayer 13th Sep 09, 10:37 AM
    • 15,336 Posts
    • 51,360 Thanks
    Buffythedebtslayer
    I wish I knew all this, I have my online banking and check that but I don't have a spread sheet, I feel quite left out!!

    xx
    Frugal Living Challenge, Pound a Day challenge, Sealed Pot Challenge Debt 4990 (March)
  • honeybear
    I wish I knew all this, I have my online banking and check that but I don't have a spread sheet, I feel quite left out!!

    xx
    Originally posted by Buffythedebtslayer


    No spreadsheet? How do you survive?

    @ LBM = £15,872.65, now £10,819.82
    AF Jan = 7/? Feb = 5/14 Mar = 14/20 Apr = 6/14 May = 2/14 June 2/14 July 0/TF Aug 1/TFv Sept 6/TF Oct 4/7

    "NEVER DOUBT YOUR OWN QUALITY"
    • gilligansyle
    • By gilligansyle 13th Sep 09, 11:29 AM
    • 4,105 Posts
    • 22,135 Thanks
    gilligansyle


    No spreadsheet? How do you survive?

    Originally posted by honeybear
    For me, the problem with spreadsheets is keeping them up to date, ( You wouldn't think I trained people to use IT would you?) I found my pen and paper method easier because I always have it with me.I constantly add it all up. Wish I could remember which challenges I'm supposed to be keeping track of though!
  • mumofseven
    I could not live without MS Money programme, I am convinced it has stopped me going under. I also have spreadsheets to calculate my net pay and my tax credits! They took a bit of time to create but can be quite useful sometimes.

    I haven't gone quite as far as the OP in calculating percentages of everything but now the idea is in my head, I am off to my excel programme........
    • roxiepie
    • By roxiepie 13th Sep 09, 11:58 AM
    • 228 Posts
    • 448 Thanks
    roxiepie
    I'm a total geek too Little Miss!

    I have what started out to be a budget calculator, but has now grown into a mega all-purpose spreadsheet. It calcalutes the rate it will take to pay off the card including interest. Has a date formula so it automatically updates when I get paid to show new debt totals based on the amount it calculates I have remaining that month to service debt.

    Oh dear. Suddenly have the urge to do something wild just to balance it out.
    NOW DEBT FREE
    NEW FINANCIAL GOALS
    CAR COSTS POT : £0.00/£550.00________ REGULAR COSTS POT : £0.00/£396.25
    £3K BEFORE 30 : £0.00/£3000.00_______£200 HOLIDAY FUNDS BY 2012 : £0.00/£200.00
    • JES_F1
    • By JES_F1 13th Sep 09, 12:06 PM
    • 671 Posts
    • 1,425 Thanks
    JES_F1
    I love my spreadsheets
    I too have spreadsheets!



    I've got them monitoring my monthly income/expenditure, working out when different debts will be paid off on my DMP (and how much more other creditors will then get), my online sales, and just about everything for my finances! And where applicable, they all 'talk' to each other.

    I'm also constantly checking my accounts online or through telephone banking.

    I know exactly how much is left in my bank account, even down to the odd pennies!

    Before my lightbulb moment at the beginning of 2008, which led to me setting up my DMP with the CCCS, I had no real idea what my outgoings were and just kept drawing out cash as I 'needed' it and just hoped there'd be enough left - and hoping that not too many direct debits would bounce!

    I love looking at my account online now as there's actually money in it and seeing it match my spreadsheet.

    This makes me sound rather obsessive and probably a little sad ...
    Last edited by JES_F1; 13-09-2009 at 12:08 PM. Reason: typo
    Debt Jan 2008: £45,566. *** June 2013: DEBT FREE! ***
    Paid back just under £50,000 due to some interest added.

    Dealt with my debt through a Step Change
    (CCCS) DMP.
    DMP Mutual Support Thread Member #240.
    • Sassers
    • By Sassers 13th Sep 09, 12:11 PM
    • 1,254 Posts
    • 8,113 Thanks
    Sassers
    I constantly think about MSE, incomings, outgoings and whether I can do what I call `the double MSE offset !!!!! method'. I'm not being offensive - just trying to make myself laugh and get motivated. It does work for me. Along the lines of: I did mystery shopping in a bookies. I won £26 after putting on the bets. I got paid for a: doing the mystery shop b: got paid to put the bet on, and C:the winnings. I put the actual MS payment and £16 of the winnings towards the PAD challenge, combined £10 of the winnings and a £4 survey luncheon voucher towards my weekly shop. The weekly shop was all whoopsies that I made into freezered meals. So really I made the cash and vouchers into a `rubber chicken' offset MSE thang.........I love MSE, it's taught me so much. lol
    Current debt and mortgage: £26, 411 Debt/Mortgage at start: £92,598 (27/09/2010) Paid off so far: £66, 187
    • Radish72
    • By Radish72 13th Sep 09, 12:11 PM
    • 1,863 Posts
    • 11,629 Thanks
    Radish72
    Its not mad and obsessive

    Its sensible and addictive

    I'm now trying to think of some random facts I can generate on my mortgage
    Mortgage Aug12 £165K, Apr18 £34500
    OP's in 2017 £3000 ish
    ISA challenge start 2017 £3000/£500 (16%)
    • Little Miss Uni-Debt
    • By Little Miss Uni-Debt 13th Sep 09, 12:58 PM
    • 832 Posts
    • 2,875 Thanks
    Little Miss Uni-Debt
    Phew! I'm glad I'm not the only one! :rolleyes:

    I think it stems from not wanting to fall back into old habits - I used to add things up in chunks that I would round up or down, just £30 here and £15 there. And then I would check my bank or purse and I'd have spent no where near what I thought I had. Usually double the estimate!

    I realised I needed to deal in absolute and accurate figures. It's similar to dieting I guess... Knowing different aspects of my finances gives me an all round picture. If you want to get fitter and lose weight you don't just go on what it says on the scales (or in this case your current bank balance) if you want to keep motivated, you go by dress sizes lost, changes in measurements at different parts of the body and mainly how you feel! It gives you a better indication as to the work you have put in so far!


    As HappyToGetDebt Free asked - here's how to work out you percentage what you have paid off...

    TOTAL DEBT AT START divided by 100 = 1% of your debt (FIG1)

    TOTAL PAID OFF divided by the answer above (FIG1)

    E.G.

    £12000 / 100 = £120

    £ 9000 / £120 = 75% PAID. Therefore I have 25% left to pay off.

    HTH. More formulas later on! Don't get me started on spreadsheets.
    Last edited by Little Miss Uni-Debt; 13-09-2009 at 1:05 PM.
    Total@ LBM - Nov07 £14k - Nov 08 £5765 - Aug 09 £3k Dec 09 £998 - May 11 £6900 - Jun 12 £8k Sept12 £7k 19.5k Done - 0k to go
    DEBT FREE! Nov 15
    Proud DFW Club Member - #1073
    '1% at a time' Member - #1!
    • Little Miss Uni-Debt
    • By Little Miss Uni-Debt 13th Sep 09, 1:06 PM
    • 832 Posts
    • 2,875 Thanks
    Little Miss Uni-Debt
    I also have trouble keeping spreadsheets up to date but they are very useful. That is why my pocket is full of lots of scraps of paper of little workings-out. :-)
    Last edited by Little Miss Uni-Debt; 13-09-2009 at 1:10 PM.
    Total@ LBM - Nov07 £14k - Nov 08 £5765 - Aug 09 £3k Dec 09 £998 - May 11 £6900 - Jun 12 £8k Sept12 £7k 19.5k Done - 0k to go
    DEBT FREE! Nov 15
    Proud DFW Club Member - #1073
    '1% at a time' Member - #1!
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

803Posts Today

5,844Users online

Martin's Twitter
  • Watching Theresa May... seriously would anyone in their right mind truly want her job right now!

  • RT @thecheekypostie: @MartinSLewis Thanks to this, I have just skim read it. To those in Scotland - on page 548, Dounreay is mentioned by n?

  • Today's twitter poll: The 585 page draft agreement of the withdrawal of the UK from the EU has been published. A? https://t.co/8YLkPyzqYM

  • Follow Martin