Mumsnet has not checked the qualifications of anyone posting here. Free legal advice is available from a Citizen's Advice Bureau, and the Law Society can supply a list of local solicitors.

Cost of credit cards and mortgages .... the spreadsheets

(103 Posts)

MNHQ have commented on this thread. Read here.

Talkinpeace Sat 23-Mar-13 22:07:13

A while ago I wrote a spreadsheet to help a client understand that if he bought a Bugaboo on his credit card he'd still be paying for it when the child started University

here it is
https://docs.google.com/spreadsheet/ccc?key=0AiZqlQ7-gn07dHRoTXA5Qnlld25UWkw1TEhZZk9IYVE&authkey=CMjc4JEB&authkey=CMjc4JEB#gid=0

And then on a thread this evening, somebody asked about how to explain the risks of an interest only mortgage
so I wrote this
https://docs.google.com/spreadsheet/ccc?key=0AiZqlQ7-gn07dDN4clg5OXhLMGJWbHZhOEo4UTJINEE#gid=0

Enter your figures into the highlighted boxes and the sheets do the rest ....
I check them every few weeks and correct any glitches ...

BooksandaCuppa Sat 23-Mar-13 22:09:31

Good stuff, Talkin

rhondajean Sat 23-Mar-13 22:10:42

This is a brilliant resource MNHQ

Thanks, that's really interesting. smile very useful.

Have you considered turning it into an iphone/android app?

Talkinpeace Sat 23-Mar-13 22:41:01

a tad technical for me!
and actually those sheets are best on a big screen - seeing the interest keep clocking up down to row 498 is quite sobering ....

Talkinpeace Sun 24-Mar-13 16:56:07

Delighted to see that so many people are using the sheets
but please try to ONLY put stuff in the highlighted boxes .....

rhondajean Sun 24-Mar-13 19:36:25

Could people save them to their own desktop perhaps before inputting data?

I'm going to alert mnhq to this thread tomorrow and see if they can put a downloadable version somewhere if you are happy with that?

Talkinpeace Sun 24-Mar-13 22:48:31

Rhonda
I think it can be downloaded - I have no problem with that except that so long as it stays on the Goggle drive I can check that the formulae stay right.
And actually, playing with different numbers is interesting for all users to see ...

rhondajean Sun 24-Mar-13 23:34:47

Ah right sorry! My pc is playing up - some memory issue - so I've been stuck on iPad.

Talkinpeace Thu 02-May-13 21:52:53

In light of the current news story about Interest Only Mortgages, just bumping my thread

Talkinpeace Sun 19-May-13 14:32:27

formula over types corrected ...

Talkinpeace Sat 25-May-13 14:37:56

and delighted to see that people are putting their numbers in to see the impact of overpayment of debts

Talkinpeace Wed 26-Jun-13 22:54:52

just for DiscoDonkey

Talkinpeace Fri 05-Jul-13 17:44:06

bump for monkeychops

TheDoctrineOfAllan Fri 05-Jul-13 22:55:04

That's so cool of you, TP.

al88 Sun 07-Jul-13 12:33:31

Hi Talkin. Just wanted to say thanks for this. Its awesome! thanks

Talkinpeace Sun 07-Jul-13 16:46:38

grin
please feel free to download, share, link, anything you like.
I'm not in the least precious about them,
I regard them as a force for good
(a bit like my Ebay me page which I gather the HMRC now refer to!!!)

AND
if you can think of a scenario I've missed, please let me know as I can either write a new sheet or add it in ...

Fluffycloudland77 Sun 07-Jul-13 17:15:21

Thank you, very interesting.

Talkinpeace Thu 11-Jul-13 09:30:05

There is a discussion in credit crunch about budgeting.
I'm happy to write a sheet that people can play with, but suspect that it will be more to download than post figures online.
on the other hand it could be fun to allow people to add a column and compare themselves (utterly anonymously) with others ...
your thoughts?

frissonpink Thu 11-Jul-13 12:25:02

I would love a budgeting sheet! grin

FasterStronger Thu 11-Jul-13 12:33:46

excellent, I love a good spreadsheet.

Yoghurty Thu 11-Jul-13 12:39:46

This is great, thanks so much for taking the time to do this.
I'm going to sit down with it tonight- eeek!

Talkinpeace Thu 11-Jul-13 13:37:40

Okey dokey, before I start juggling

Income:
His salary / freelance earning (after tax)
Her salary / freelance earnings (after tax)
Child benefit
Tax credits
Maintenance / CSA income
Savings / investment income (after tax)
Rental income (after tax)

Outgoings: Unavoidable ...
CSA payments
Maintenance Payments
Rent / Mortgage
Endowment / Life insurance
House insurance
Council tax
Car tax
Car insurance

Outgoings : Adjustable
Water bill
Gas bill
Electric bill
Oil / wood bill
Food shopping
School uniform / shoes
School trips and extras
Basic toiletries and cleaning products
Car fuel

Outgoings : Capital spend
House maintenance
House decorating
Cars
2 week holiday per year

Outgoings : Optional
Adult clothes
Makeup
Monthly meal out

Outgoings : Luxuries
Overseas travel
Cleaners or domestic staff (including ironing)
Coffee and lunches out
Amusement parks etc
Private health insurance
School fees

what have I missed / misallocated

caramelwaffle Thu 11-Jul-13 13:43:49

Good idea

Talkinpeace Thu 11-Jul-13 13:44:49

I forgot pets ..... grin

Join the discussion

Join the discussion

Registering is free, easy, and means you can join in the discussion, get discounts, win prizes and lots more.

Register now