Hi,
i know there are lots of "calculators" out there advising how much you have to repay on mortgages etc.
However, I'm trying to find out if the following is accurate
You borrow 400,000
Term 25 years
Intrest Rate 3.5%
Calculating repayment as follows???
400,000 divided by 3.5% gives you a years repayment
a years repayment divided by 12 gives me a monthly repayment
Or what am i leaving out - i'm not that clever!!
Thanks,
This will give you you intrest payments - which will not reduce you capital and therefore will be the same for ever - i.e. no 25yrs!
You can use the likes of: "Karl Jeacle's Mortgage Calculator" (google it) to work out the payments and has great features for exploring overpayments, lump sum payments...
Based on your figures above you are looking at repayments of €2,002.49 p/m.
Break down of P&I from calc (its in dollars, but numbers are the same):
YR Intrest Principal Balance
2010 $12,698.07 $9,329.32 $390,670.68
2011 $13,505.71 $10,524.17 $380,146.51
2012 $13,131.39 $10,898.49 $369,248.02
2013 $12,743.77 $11,286.11 $357,961.91
2014 $12,342.36 $11,687.52 $346,274.39
2015 $11,926.69 $12,103.19 $334,171.20
2016 $11,496.21 $12,533.67 $321,637.53
2017 $11,050.43 $12,979.45 $308,658.08
2018 $10,588.77 $13,441.11 $295,216.97
2019 $10,110.71 $13,919.17 $281,297.80
2020 $9,615.65 $14,414.23 $266,883.57
2021 $9,102.99 $14,926.89 $251,956.68
2022 $8,572.09 $15,457.79 $236,498.89
2023 $8,022.29 $16,007.59 $220,491.30
2024 $7,452.95 $16,576.93 $203,914.37
2025 $6,863.36 $17,166.52 $186,747.85
2026 $6,252.80 $17,777.08 $168,970.77
2027 $5,620.52 $18,409.36 $150,561.41
2028 $4,965.77 $19,064.11 $131,497.30
2029 $4,287.71 $19,742.17 $111,755.13
2030 $3,585.54 $20,444.34 $91,310.79
2031 $2,858.40 $21,171.48 $70,139.31
2032 $2,105.39 $21,924.49 $48,214.82
2033 $1,325.62 $22,704.26 $25,510.56
2034 $518.09 $23,511.79 $1,998.77
2035 $5.83 $1,996.66 $2.11
I would recommend you play around with this as it will give you a great insite into *what* you are actually paying...
For example: you are paying over 200k in intrest over 25 years, but if you could afford to reduce the term to 20 years, you would only be paying 156k (mind you your monthly repayments increase to €2319.84). I find it very useful to look at the raw data it provides.
- NOTE: I have no association with the above, but find it very useful.
All the Best.