Mortgage annual repayment calc broken down into monthly repayments

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

Replies

This discussion has been closed.
Latest MSE News and Guides

Boost your Nectar points

Get up to £25 this Saturday

MSE News

Preparing for summer

What MoneySaving things can you do now to get ready?

MSE Forum

Hot Diamonds 40% off code

Including already-reduced outlet stock

MSE Deals