My Excel mortgage spreadsheet

1…34689…48

Comments

  • Ian_Griffiths_Halifax
    Ian_Griffiths_Halifax Posts: 1,690 Forumite
    You won't see Locoblade again for a while. He's getting his pitch ready for Dragons Den. It will be on the shelves of PC World and Staples by Christmas:rotfl:
    I am a Mortgage Consultant and don't like to be told what I can and can't put in a signature so long as it's legal and truthful.
  • Locoblade
    Locoblade Posts: 795 Forumite
    Name Dropper First Post First Anniversary
    Ian_Griffiths_Halifax wrote: »
    You won't see Locoblade again for a while. He's getting his pitch ready for Dragons Den. It will be on the shelves of PC World and Staples by Christmas:rotfl:

    LOL, sadly not, currently having a bit of an IT "issue" at work which meant a 24 hours shift yesterday, overnight tonight and probably more of the same for the rest of the weekend, hence the odd posting times lately. :rolleyes:

    Jnr_81, when you say the latest version of Excel, which one is it, and is it full Excel (part of Office), not OpenOffice or Works etc, because only Excel 2002 onwards will work? Also, I assume you're editing the Monthly Overpayment column and not the "Total Monthly Payment" column, because only the yellow highlighted columns are editable (in any version)?

    Thanks again for all the positive comments all, gives motivation to improve it further when I get time, maybe v1.3 will include my paypal address so you can all donate half the savings you make by using this :D
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
  • Locoblade
    Locoblade Posts: 795 Forumite
    Name Dropper First Post First Anniversary
    kjharve wrote: »
    Nice looking spreadsheet mate. Is it worth adding an APR to help comparisons?

    If you think that would be worthwhile I can knock something up for you to build in.

    I'll have a look, do many believe that APR is a good indicator of loan value when 90% of loans have an introductory rate after which people invariably jump ship to another loan rather than taking it through to term (when the APR would be relevent)?

    Its on KFI sheets you get from all the lenders I guess, so maybe its worth putting in.
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
  • Ian_Griffiths_Halifax
    Ian_Griffiths_Halifax Posts: 1,690 Forumite
    Locoblade wrote: »
    I'll have a look, do many believe that APR is a good indicator of loan value when 90% of loans have an introductory rate after which people invariably jump ship to another loan rather than taking it through to term (when the APR would be relevent)?

    Its on KFI sheets you get from all the lenders I guess, so maybe its worth putting in.

    In my opinion, APR rates add unnecessary confusion to Mortgage Key Facts Illustrations as most people will change their mortgage at some point, even if it's not immediately after their initial deal ends.
    I am a Mortgage Consultant and don't like to be told what I can and can't put in a signature so long as it's legal and truthful.
  • Bismarck
    Bismarck Posts: 2,598 Forumite
    great stuff...well done...thanks! Something to play with over the weekend.....how sad am I?
    For what I've done...I start again...And whatever pain may come ...Today this ends... I'm forgiving what I've done -AF since June 2007
  • Locoblade
    Locoblade Posts: 795 Forumite
    Name Dropper First Post First Anniversary
    Ian_Griffiths_Halifax wrote: »
    In my opinion, APR rates add unnecessary confusion to Mortgage Key Facts Illustrations as most people will change their mortgage at some point, even if it's not immediately after their initial deal ends.

    Exactly how I feel about it yup, hence not bothering putting it in the spreadsheet originally.
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
  • Locoblade
    Locoblade Posts: 795 Forumite
    Name Dropper First Post First Anniversary
    Bismarck wrote: »
    great stuff...well done...thanks! Something to play with over the weekend.....how sad am I?

    Probably not as sad as me spending many hours over the last few weeks writing it :D
    My Excel Mortgage Calculator Spreadsheet: http://forums.moneysavingexpert.com/showthread.html?t=1157173
  • Chris2685
    Chris2685 Posts: 1,212 Forumite
    That's an amazing tool. Nice work :)
  • nesssie1702
    nesssie1702 Posts: 1,345 Forumite
    Combo Breaker First Anniversary
    Excellent! I'm due to remortgage next year and this will come in really useful.
  • _dave__4
    _dave__4 Posts: 49 Forumite
    Hi Locoblade,

    First of all, excellent spreadsheet - well done!

    Now, I've been trying to look at the "cost savings" from overpayments, and I noticed your "Interest Saved by Overpayment/Offset" cell. But that seems to just add up the differences over the term, without allowing for the "time-value" of money. Is there any way to get the cost savings in "todays money" from your spreadsheet, much like the following calculator does? :-

    http://calc-calc-calc.net/get/calc/Mortgage-Overpayment/?l=100000&i=6&t=25&m=744.30&d=4

    That shows the difference in total payments as 193,290 - 166,252 = 27,038 (compared to 27,035.73 in your spreadsheet), but also the difference in "Effective Overall Cost (Present Value of all payments)" as 122,471 - 117,498 = 4,973 (when allowing for inflation at 4%).

    Can your spreadsheet produce similar figures?

    Thanks!
★ ★ ★ Meet your Ambassadors

Categories

  • All Categories
  • 343.2K Banking & Borrowing
  • 250.1K Reduce Debt & Boost Income
  • 449.7K Spending & Discounts
  • 235.2K Work, Benefits & Business
  • 608K Mortgages, Homes & Bills
  • 173K Life & Family
  • 247.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 15.9K Discuss & Feedback
  • 15.1K Coronavirus Support Boards