Mortgage Payments

MrSaver96

Generally speaking, how much of the monthly mortgage payment is used to reduce capital?

Thrugelmir

Depends , interest rate and term both have an impact.

MrSaver96

So ours is a 30 year term, fixed at 2.3% for the next 5 years.

EyeonthePrize

If you search for amortization calculators on google you will find websites were you can enter your mortgage details and it will show you the monthly breakdown of payments. I think this will give you the information you want.

MrSaver96

Thanks for that. Worked brilliantly!

dimbo61

Whatsthecost website will show how much you will clear in 5 years.
You can also see how much your mortgage would be Interested only and repayment.

getmore4less

PMT and PPMT functions do the job.

for a range of rates(across) years(down)



Y\R 00.00% 00.50% 01.00% 01.50% 02.00% 02.50% 03.00% 03.50% 04.00% 04.50% 05.00%

---

05 100.00% 97.53% 95.12% 92.78% 90.49% 88.26% 86.09% 83.97% 81.90% 79.89% 77.92%
10 100.00% 95.12% 90.49% 86.08% 81.89% 77.90% 74.11% 70.50% 67.08% 63.82% 60.72%
15 100.00% 92.78% 86.08% 79.86% 74.10% 68.76% 63.80% 59.20% 54.94% 50.98% 47.31%
20 100.00% 90.49% 81.88% 74.10% 67.05% 60.68% 54.92% 49.71% 44.99% 40.73% 36.86%
25 100.00% 88.25% 77.89% 68.75% 60.68% 53.56% 47.28% 41.74% 36.85% 32.53% 28.72%
30 100.00% 86.07% 74.09% 63.78% 54.91% 47.27% 40.70% 35.05% 30.18% 25.99% 22.38%


might look better the other way round.

R\Y	05	10	15	20	25	30
00.00%	100.00%	100.00%	100.00%	100.00%	100.00%	100.00%
00.50%	97.53%	95.12%	92.78%	90.49%	88.25%	86.07%
01.00%	95.12%	90.49%	86.08%	81.88%	77.89%	74.09%
01.50%	92.78%	86.08%	79.86%	74.10%	68.75%	63.78%
02.00%	90.49%	81.89%	74.10%	67.05%	60.68%	54.91%
02.50%	88.26%	77.90%	68.76%	60.68%	53.56%	47.27%
03.00%	86.09%	74.11%	63.80%	54.92%	47.28%	40.70%
03.50%	83.97%	70.50%	59.20%	49.71%	41.74%	35.05%
04.00%	81.90%	67.08%	54.94%	44.99%	36.85%	30.18%
04.50%	79.89%	63.82%	50.98%	40.73%	32.53%	25.99%
05.00%	77.92%	60.72%	47.31%	36.86%	28.72%	22.38%