Your browser isn't supported
It looks like you're using an old web browser. To get the most out of the site and to ensure guides display correctly, we suggest upgrading your browser now. Download the latest:

Welcome to the MSE Forums

We're home to a fantastic community of MoneySavers but anyone can post. Please exercise caution & report spam, illegal, offensive or libellous posts/messages: click "report" or email forumteam@.

Search
  • FIRST POST
    delluver
    Mortgage annual repayment calc broken down into monthly repayments
    • #1
    • 23rd Feb 06, 3:29 PM
    Mortgage annual repayment calc broken down into monthly repayments 23rd Feb 06 at 3:29 PM
    Hi, I am looking for a decent calculator/spreadsheet to show mortgage repayments over a year - broken down, each calculation shown:

    example:

    95000 x 4% = 3800 divided by 12 = 670 (316.67 interest, 353.33 capital) so, 95000 - 353.33 = 94646.67, and do the same again to work out monthly repayment.
    and so forth for another 11 months.


    Can anyone help? Would save me setting out formulas and trying to get Ecxel spreadsheets to formulate correctly. Could do it by hand, but wanted an auto calculator for ease of use and time saving.

    Thanks, Delluver
Page 1
Welcome to our new Forum!

Our aim is to save you money quickly and easily. We hope you like it!

Forum Team Contact us

Live Stats

134Posts Today

1,297Users online

Martin's Twitter