Forum Home» Mortgages & Endowments

My Excel mortgage spreadsheet - Page 6

New Post Advanced Search
Important update! We have recently reviewed and updated our Forum Rules and FAQs. Please take the time to familiarise yourself with the latest version.

My Excel mortgage spreadsheet

edited 7 May 2010 at 8:29PM in Mortgages & Endowments
465 replies 399.5K views
13468947

Replies

  • 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.
  • LocobladeLocoblade Forumite
    771 posts
    Part of the Furniture 500 Posts
    ✭✭✭
    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
  • LocobladeLocoblade Forumite
    771 posts
    Part of the Furniture 500 Posts
    ✭✭✭
    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
  • 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.
  • 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
  • Important update! We have recently reviewed and updated our Forum Rules and FAQs. Please take the time to familiarise yourself with the latest version.
  • LocobladeLocoblade Forumite
    771 posts
    Part of the Furniture 500 Posts
    ✭✭✭
    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
  • LocobladeLocoblade Forumite
    771 posts
    Part of the Furniture 500 Posts
    ✭✭✭
    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
  • That's an amazing tool. Nice work :)
  • Excellent! I'm due to remortgage next year and this will come in really useful.
  • 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!
Sign In or Register to comment.

Quick links

Essential Money | Who & Where are you? | Work & Benefits | Household and travel | Shopping & Freebies | About MSE | The MoneySavers Arms | Covid-19 & Coronavirus Support