2011 mfw

Lois_E

curlygirl1971 wrote: »

I've not seen one that works out daily balance but I use a spreadsheet by a MSE'er called Locoblade (if you search for him you'll find his thread and therefore his spreadsheet)

It gives you a monthly balance and will handle random OP's......to a point. If you make more than one OP a month, and regardless of when during the month you make them; you'd have to add them all together and show them as one value. It calculates your interest on a monthly (not daily) basis - so if you make no OP until the end of the month then the interest calculation will be slightly out as the spreadsheet will assume your payment was deducted at the beginning of the month.

When I use the spreadsheet it calculates a 'closing' balance for the month (after interest applied, payments deducted). I then check this online against my real Mortgage balance - I have a small mortgage with the Halifax, and the difference between the Real mortgage balance and the spreadsheet value is only a couple of £. I then over-write the spreadsheet value with the real one so that it doesn't get too out of synch.

The spreadsheet also shows a Monthly Interest figure. I just inserted an extra column and calculated a daily interest figure. I suppose this would then help you get an idea of what your mortgage value is on a daily basis - but not 100% accurate. To be honest I can't imagine any spreadsheet giving you a 100% accurate or a daily balance - it would be really complicated.

I have written a spreadsheet that can calculate interest even if there are several OPs on different days of the month. I am happy to share it with people but not sure how to. Can anyone suggest a way for me to enable people to copy the interest calculation part of it?

cake21

.....................................2011 OVERPAYMENT TARGET JUNE TOTAL YEAR TO DATE (spreadsheet version here)

2. cha97michelle - £5000 / £901 / £3832
6. pammyj74 - £5000 / £800 / £4450
7. CathT - £2500 / £458 / £1918
8. sheslookinhot - reduce mortgage to £6000 / £500 / £3000
14. SOandSO - £20000 / £550 / £3500
19. uzubairu - reduce mortgage to £46000 (£11000 OP) / £2150 / £11900 Target reached June! :j:j
20. Little Mama - £5000 / £1209 / £2408
23. gratefulforhelp - £3000 / £48 / £288
26. waughc01 - £15000 / £750 / £12500
29. financialbliss - £2050 / £200 / £862
31. Perkipsie - £10000 / £940 / £1240
33. fillyfop - £6000 / £52 / £2785
37. ironman1 - £1000 / £397 / £1433
38. sarahevie - £5000 / £6053 / £6053 Target reached June! :j:j
41. Kerry Woman - £1500 / £100 / £1020
42. ajmoney - £1700 / £250 / £1030
44. grn.w.nv - £1200 / £100 / £400
48. SmileyG - £1200 / £50 / £1050
51. Di-Dough - £2000 / £138 / £956
52. fluffysox - £1200 / £674 / £1200 Target reached June! :j:j
55. lincoln-potter - £19500 / £3000 / £9800
56. narnie1 - £11000 / £1924 / £8224
60. glitterball - £7500 / £639 / £4132
61. kazvinny - £10805 / £1073 / £1615
62. saver-j - £5988 / £499 / £2994
65. UnionGirl - £15600 / £83 / £334
66. puddle96 - £12000 / £1023 / £3702
76. coldstreamalways - £11940 / £995 / £5075
78. Froggy-G - £10000 / £1400 / £5635
83. jaywhoopee - £4000 / £395 / £2252
91. AvidSaver - £3000 / £507 / £2304
93. ekroys17 - £6000 / £2448 / £3364
94. lippy1923 - £1500 / £200 / £1100
96. Needhelpsaving - £1000 / £50 / £357
98. goobergirl - £1000 / £325 / £325
99. wilsons - £2000 / £172 / £1032
102. canne - A$15000 / A$83 / A$6629
104. MsWow - £3200 / £500 / £1300
106. kkgree1 - reduce mortgage to £100000 / £640 / £640
107. miss_corerupted - repay £10000 capital / £80 / £80
109. ButterflyBee - reduce mortgage to £189790 / £150 / £150
111. Poppycat1 - £6000 / £600 / £1372
112. evi3000 - £55000 / £3000 / £30700
117. laurasavon - £3000 / £250 / £1500
119. fieldofdreams - Completely clear £8500 mortgage! / £400 / £2400
121. vwchris - £7000 / £500 / £3400
123. shala_moo - £10000 / £1214 / £5881
128. froddington - £5000 / £600 / £2165
138. anthonini - £6000 / £500 / £5000
139. curlygirl1971 - £6000 / £278 / £5337
149. skaps - £2011 / £160 / £961
160. Emsky123 - £7000 / £1000 / £4400
163. gerbiljo - reduce mortgage to £34700 / £3080 / £16005
173. greent - £5000 / £739 / £4689
177. Parnott - £7200 / £600 / £4288
183. lighthousescotland - £2000 / £205 / £1230
184. newgirly - £15000 / £306 / £5932
192. ElusiveLucy - £6500 / £500 / £3500
201. sara1979 - £5000 / £499 / £2994
204. skintscotslass - £2400 / £200 / £1200
205. blizeH - £14000 / £1000 / £5500
213. AnnaBeth - £4500 / £3049 / £3049
215. COOLTRIKERCHICK - £2000 / £400 / £400
217. pavlovs_dog - £1500 / £90 / £1110
219. MoneyMission - £1200 / £9 / £109
220. originalmiscellany - £22000 / £2500 / £20000 Original target reached June! :j:j


TOTAL - £1,286,521 / £53,965 / £425,727

mummyofonechild

I don't think I exist anymore now my mortgage is paid off :-(

cake21

cake21 wrote: »

150. mummyofonechild - mortgage-free by end 2011! (£2000 OP) / £ / £5280 :j:money::jMortgage Free Graduate!!! :j:money::j

mummyofonechild wrote: »

I don't think I exist anymore now my mortgage is paid off :-(

You do exist as an ongoing inspiration on the front page :beer::A:T...but you didn't make any OPs in June (like me, only I don't have such a good excuse! ;))

cake21

Lois_E wrote: »

I have written a spreadsheet that can calculate interest even if there are several OPs on different days of the month. I am happy to share it with people but not sure how to. Can anyone suggest a way for me to enable people to copy the interest calculation part of it?

Wow! I'm impressed. I love spreadsheets :rotfl:How about uploading the spreadsheet to google docs, then posting the web address here, or by private message? You could change any numbers you didn't wish to share.

Lois_E

I've had a look at Locoblade's spreadsheet now, and gone a bit shy. Mine is nothing like as comprehensive. It's not really designed for predicting the whole course of the mortgage, more for tracking the balance as you go along.

If people think they might be interested, I'll look into the google docs possibility. If I sign into google docs with my usual gmail account, will it share my email address with people who follow the link to my spreadsheet?

cake21

Lois_E wrote: »

I've had a look at Locoblade's spreadsheet now, and gone a bit shy. Mine is nothing like as comprehensive. It's not really designed for predicting the whole course of the mortgage, more for tracking the balance as you go along.

If people think they might be interested, I'll look into the google docs possibility. If I sign into google docs with my usual gmail account, will it share my email address with people who follow the link to my spreadsheet?

No need to be shy, what you'll probably find is that people will take the bits they like from Locoblade's and the bits they like from yours

I use "anyone with the link can view", and people can't see your email address.

mummyofonechild

cake21 wrote: »

You do exist as an ongoing inspiration on the front page :beer::A:T...but you didn't make any OPs in June (like me, only I don't have such a good excuse! ;))

Thanks Cake.

Was just feeling lonely

Di-Dough

N0 51 checking in with a payment of £138.21.

Well done to those who have made their targets:j

Di

Lois_E

cake21 wrote: »

No need to be shy, what you'll probably find is that people will take the bits they like from Locoblade's and the bits they like from yours

I use "anyone with the link can view", and people can't see your email address.

Thanks for the encouragement, cake.

I've uploaded a version with fake numbers to Google Docs. If I PM you the link, would you be very kind and check I have uploaded it correctly, and that the settings are right so you can't find out my RL name? That way, if it's right, I can put the link on here for everyone, but if I've messed it up it's just one person!

Also, it would be great if you could have a quick look and see if it's working properly. Some things went wrong in the conversion from Excel to Google spreadsheet. I think I've fixed them all now, but it would be lovely to have a second opinion.

Thanks loads.