Debt calculator spreadsheet

Hey all

I am sort of counselling a friend through her debt problems at the moment. She is doing really well but I think it would really really help me and her if we had some sort of whizz bang spreadsheet that calculates debts, aprs, and repayments (hopefully with some fancy charts as well!)

Would anyone be willing to share theirs with us? I would love you forever!

Thanks

Annie
Xx
"Debt makes plans for you" - A quote from my friend Catherine. How true!

Comments

  • hypno06
    hypno06 Posts: 32,296 Forumite
    10,000 Posts Combo Breaker
    I use the old favourite www.whatsthecost.com which is fab fab fab!

    But today I have also found www.spendingdiary.com which is exactly as it says - it has graphs of where exactly you are spending your money - quite an eye opener!!
    Successful women can still have their feet on the ground. They just wear better shoes. (Maud Van de Venne)
    Life begins at the end of your comfort zone (Neale Donald Walsch)
  • Crown
    Crown Posts: 1,377 Forumite
    Eagerlearner (a respected member of this forum) has a good debtbuster spreadsheet what is easy to use and has charts but doesnt calculate the interest im afraid or didnt do when I got it.

    tkaea look at the thread as it probally has been updated by now.

    http://forums.moneysavingexpert.com/showthread.html?t=391856&highlight=debt+buster
    Official DFW Nerd Club - Member no. 297 - Proud To Be Dealing With My Debts :D
  • Hi You may find this useful in proving min payments are futile:
    Monthly Credit Card Rates and Time Taken to
    Payoff £$1000* and the Interest Paid

    Monthly% APR% Time Interest
    1 12.68 11y 1m 470.93
    1.1 14.03 11y 6m 544.93
    1.2 15.38 12y 1m 627.18
    1.3 16.76 12y 8m 718.86
    1.4 18.15 13y 4m 821.88
    1.5 19.56 14y 1m 938.45
    1.6 20.98 15y 0m 1071.47
    1.7 22.42 15y 11m 1224.44
    1.8 23.87 17y 1m 1402.70
    1.9 25.34 18y 5m 1612.80
    2 26.82 20y 0m 1864.30
    2.1 28.32 21y 11m 2170.94
    2.2 29.84 24y 3m 2553.00
    2.3 31.37 27y 4m 3043.14
    2.4 32.92 31y 3m 3693.72
    2.5 34.48 36y 10m 4602.18
    2.6 36.07 45y 0m 5959.51
    2.7 37.67 58y 6m 8211.90
    2.8 39.29 85y 3m 12699.05
    2.9 40.92 164y 5m 26099.39

    *Assumes minimum payment of the higher of £$5 or 3% per month
  • hypno06 wrote: »
    I use the old favourite www.whatsthecost.com which is fab fab fab!

    But today I have also found www.spendingdiary.com which is exactly as it says - it has graphs of where exactly you are spending your money - quite an eye opener!!

    Love the pie charts on Spending diary. Realise now how much money i waste a month.


    36_19_2.gif

    ym
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
  • 350K Banking & Borrowing
  • 252.7K Reduce Debt & Boost Income
  • 453.1K Spending & Discounts
  • 243K Work, Benefits & Business
  • 619.9K Mortgages, Homes & Bills
  • 176.5K Life & Family
  • 255.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 15.1K Coronavirus Support 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.