18
Feb
2016
A question about : 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
Best answers:
- Try here https://forums.moneysavingexpert.com/....html?t=155630
- Class, just what I'm looking for!
Thanks,
Delluver
Category:
- 365 reads
Popular
- Getting post for someone never lived at address Views: 78,843
- Letter from po box 8743 bellshill Views: 50,389
- Transaction on my current account from "who internet internet" Who are they??? Views: 40,104
- What is EESA? Views: 37,286
- Lloyds TSB Trustcard loyalty points Views: 26,088