We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 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!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Mortgage annual repayment calc broken down into monthly repayments
delluver
Posts: 568 Forumite
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
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
0
Comments
-
Mortgage Free Wannabe 2009 Challenge
Mortgage Free Wannabe 2009 Challenge £1,000 overpayment.
Total Mortgage £90,000 (as at 01/01/09)0 -
Class, just what I'm looking for!
Thanks,
Delluver0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.7K Banking & Borrowing
- 254.2K Reduce Debt & Boost Income
- 455.1K Spending & Discounts
- 246.8K Work, Benefits & Business
- 603.3K Mortgages, Homes & Bills
- 178.2K Life & Family
- 260.8K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards