How to calculate effect of paying lump sum off mortgage

G

grotty

Registered User
Messages
56
Hi, I am thinking of putting 30K off my mortgage and increasing my payments a little. Is there a calculator out there that will let you see how this would effect the the term of my mortgage? I am with EBS and have a variable mortgage over 30 year.

Thanks,
Grotty
 
Jeacle Mortgage Calculator

Input your details and then mess around with increased payments and lump sums to see how much saving can be achieved. Also look at switching your payments to bi-weekly (same outgoings per month, just at slightly different timings) and see what further savings you can achieve.
 
There is a simple overpayment calculator on the Bank of Ireland website:

[broken link removed]

None of the lending institutions seem keen on providing lump sum savings calculators. Nevertheless, I've recently enquired about overpayment/lump sum payment in order to reduce my term/interest and the savings are staggering.

Best of luck getting your mortgage under control. Too many people out there with CRAZY mortgages these days.
 
Also look at switching your payments to bi-weekly (same outgoings per month, just at slightly different timings)
Click to expand...

Don't really think that is always true in the case of fortnightly payments, it's not just timing, but also actual additional payments,

e.g. 12 x 1000 = 12000 p/year 26 x 500 = 13000

painless extraction of an extra 1000 p/y.
 
irishpancake said:
Don't really think that is always true in the case of fortnightly payments, it's not just timing, but also actual additional payments
Click to expand...

Hadn't spotted this before, but it does appear to be the case.

I had assumed the bi-weekly payments would actually be twice monthly (15th of the month and final day of the month for example) giving 24 payments per year.

Looking through the Jeacle breakdown of payments (before this I only ever checked the first page which covers the period from Aug to December, and where I formed the assumption of paying twice a month vs. fortnightly) it does seem that an additional (inflated) payment is made each and every January and July (when switched to bi-weekly) in order to make up the 26 (52 [weeks in a year] / 2 [for bi-weekly]) payments.

Thanks IP for pointing out the error in my logic.... (kinda an obvious one now that I look at it).
 
Guys that is exactly what I wanted - I am shocked at how so little of an increase can save you so much. A huge thanks !
 
We are with AIB .. . Mr. HP is paid weekly so we pay the mortgage weekly ... not all banks do it, but we reckon it's saving us about 4 years on our mortgage in total.
 
One way of looking at lump sum payments is that if you don't make it you will be paying interest on that amount for the entire duration of the mortgage, i.e making a lump sum payment of €30,000 now means that that €30,000 would have been the last €30,000 that you'd pay off (in twenty years time or whatever) and you be paying interest on the €30,000 for the twenty years.

Interest at 4% per year on €30,000 for twenty years is at least 80% of the €30,000... = €24,000... that's the minimum you'd save. (This doesn't consider compound interest which means the actual savings are greater)

Cheers
Joe
 
Seems to be working OK for me as far as I can see. What seems to be going wrong for you?
 
Henny Penny said:
We are with AIB .. . Mr. HP is paid weekly so we pay the mortgage weekly ... not all banks do it, but we reckon it's saving us about 4 years on our mortgage in total.
Click to expand...

That's interesting Henny Penny. Although the actual amount paid is the same as paying fortnightly (i.e. 52 weekly payments = 26 fortnightly payments), I assume you're saving a bit more interest as the money is going in weekly rather than fortnightly. How did you set this up with your bank? Was it just a simple letter instructing them to take the mortgage out weekly? I was going to change to fortnightly but I may see if Ptsb will allow me to do it weekly instead.
 
Before switching to more regular than monthly repayments make sure that your lender calculates interest more frequently than monthly - e.g. daily. Making repayments more frequently than interest is calculated is of no benefit to the borrower.
 
We arranged with the bank to have the payments done weekly. You just need to inform the bank, they have forms for you to sign ... it;s not common practice, but it is possible. We decided this before we took out the mortgage in the first place ... so check with your bank.
Interest is calculated daily on our account.
 
If you have access to Bloomberg then BCM <GO> and then MP gives you an excellent mortgage calculator. Can prepay lump sums each year (eg bonuses in Jan/Feb) and watch the mortgage term and interest amounts fall!
 
ClubMan said:
Maybe I'm wrong but I imagine that few AAM users have access to Bloomberg in which case Karl Jeacle's calculator is probably a better bet.
Click to expand...
Well a lot of posters have quoted BB or Reuters so there are some - and even if you don't have access on your own desktop a lot of (financial) offices have at least one BB terminal. But the main reason I mentioned it was because that Jeacle calculator doesn't work on my PC for some reason :) .
 
Thanks ClubMan - my IT dept won't let me download but at least I'll be able to use it at home!
 
Tell your IT department that they may be putting PCs at risk by running out of date software.
 
You must log in or register to reply here.
Back
Top