We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 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!
2011 mfw
Options
Comments
-
As a matter of nerd-ish curiosity - can I ask those that keep spreadsheets if they have anything particularly special on their record/forecast. Here's my column headings - anyone with anything any different?
Date
No. Of years into Mortgage
No. Of years left on full term
Interest Rate
BOE Actual
BOE Prediction
Min Monthly Payment
Monthly Payment on 1st
Over-payment
Cumulative OP
Total Monthly Payment
Monthly Capital Paid Off
Monthly Interest Paid
Daily Interest Paid
Month-end Balance
Month-end Balance as if no future OP's will be made
Month-end Balance as if no OP's or adjustments have been or will be made
Balance of Savings Accounts
Mortgage Less Savings = Net Debt0 -
Very similar - but I also have hourly interest (currently 7p on smallest, projected to drop to 6p in July :rotfl::o ) and the date of the month in a separate field (i.e. 1,2 etc) so I can easily filter by date to amend or add a regular payment.A positive attitude may not solve all your problems, but it will annoy enough people to make it worth the effort
Mortgage Balance = £0
"Do what others won't early in life so you can do what others can't later in life"0 -
Not too late to join the party is it?
Current mortgage £43k (as of 31/12/2010)
Target: Take £20k off (by 31/12/2011)Feb 2012 - onwards MF achieved
September 2016 - Back into clearing a mortgage - Was due to be paid off in 32 years in March 2047 -
April 2018 down to 28.00 months vs 30.04 months at normal payment.
Predicted mortgage clearing 03/2047 - now looking at 02/2045
Aims: 1) To pay off mortgage within 20 years - 20370 -
It depends........Do you speak Welsh
0 -
curlygirl1971 wrote: »As a matter of nerd-ish curiosity - can I ask those that keep spreadsheets if they have anything particularly special on their record/forecast. Here's my column headings - anyone with anything any different?
Date
No. Of years into Mortgage
No. Of years left on full term
Interest Rate
BOE Actual
BOE Prediction
Min Monthly Payment
Monthly Payment on 1st
Over-payment
Cumulative OP
Total Monthly Payment
Monthly Capital Paid Off
Monthly Interest Paid
Daily Interest Paid
Month-end Balance
Month-end Balance as if no future OP's will be made
Month-end Balance as if no OP's or adjustments have been or will be made
Balance of Savings Accounts
Mortgage Less Savings = Net Debt
Would you be willing to share your spreadsheet (obviously with your data removed)? It looks considerably more advanced than mine which is
mortgage, monthly payments, overpayments, total!
Simple, but I like the idea of your more complicated spreadsheet Feb 2012 - onwards MF achieved
September 2016 - Back into clearing a mortgage - Was due to be paid off in 32 years in March 2047 -
April 2018 down to 28.00 months vs 30.04 months at normal payment.
Predicted mortgage clearing 03/2047 - now looking at 02/2045
Aims: 1) To pay off mortgage within 20 years - 20370 -
bachigyn! (If my rudimentary Welsh isn't too rusty) Feb 2012 - onwards MF achieved
September 2016 - Back into clearing a mortgage - Was due to be paid off in 32 years in March 2047 -
April 2018 down to 28.00 months vs 30.04 months at normal payment.
Predicted mortgage clearing 03/2047 - now looking at 02/2045
Aims: 1) To pay off mortgage within 20 years - 20370 -
Siaradwch yn arafach, os gwelwch yn dda (but only if it's in English)Feb 2012 - onwards MF achieved
September 2016 - Back into clearing a mortgage - Was due to be paid off in 32 years in March 2047 -
April 2018 down to 28.00 months vs 30.04 months at normal payment.
Predicted mortgage clearing 03/2047 - now looking at 02/2045
Aims: 1) To pay off mortgage within 20 years - 20370 -
LOL. Okay everyone speaks Welsh on this thread apart from me. Rwyf wrth fy modd Cymru (the bits I've been to) if that helps. Although if I had to say it out loud I would need 4 wine gums to attempt it.
My spreadsheet: I would do, but I can't.
1) It wasn't mine to start off with and the originator does have some conditions of use
2) I don't understand it all - I've found that if I delete my info then the whole thing collapses
The best thing to do is search for a User called 'Locoblade' - he has a thread and on his first post there is a link to the latest version of his spreadsheet. I used his spreadsheet but added a couple of columns myself - but before you start messing about with it make sure you save a version. Don't delete anything - just add!
Also be aware that Locoblades spread sheet calculates interest on a monthly basis - not daily which is what the majority of mortgages use. My monthly balance is always slightly out - usually by £2-ish. So I just over-write the figure with the actual balance (from online banking) so that it calculates the future balances slightly more accurately.0 -
Diolch a chroeso (thanks and you're welcome, diolch=thank you)curlygirl1971 wrote: »Only when my hair colour goes wrong
Wierdly you are a very pretty slab of pale pink sponge cake with white icing when I see you. <snip>
But thanks for the suggestions (What's Welsh for Thank-you?) 0 -
Croeso, dych chi'n rhif 220. Dw i'n mor falch i weld pobl eraill sy'n siarad cymraegoriginalmiscellany wrote: »Not too late to join the party is it?
Current mortgage £43k (as of 31/12/2010)
Target: Take £20k off (by 31/12/2011) 0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 350.8K Banking & Borrowing
- 253.1K Reduce Debt & Boost Income
- 453.5K Spending & Discounts
- 243.8K Work, Benefits & Business
- 598.7K Mortgages, Homes & Bills
- 176.8K Life & Family
- 257.1K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards