Skip to main content

How to calculate mortgage loan instalments?

There exists many automated tools for the calculation of mortage loan such as this website.
However, I believe having a detailed mathematical understanding for the calculation of mortage payments is paramount as undeniably, this formula plays such a key role in the lives of many.
The formula is:
M = P [ i(1 + i) ^n ] / [ (1 + i)^n - 1]
To illustrate the working of this formula.

Say for a $100,000 mortgage at 5% compounded monthly for 15 years, we would first solve for i as

i = 0.05 / 12 = 0.004167 and
n as 12 x 15 = 180 monthly payments

Next we would solve for (1 + i)^n = (1.004167)^180 using the xy key on the calculator, which yields 2.11383

Now our formula reads M = P [ i(2.11383)] / [ 2.11383- 1] which simplifies to

M = P [.004167 x 2.11383] / 1.11383 or
M = $100,000 x 0.00791 = $791.81
Labels:

Comments

Anonymous said…
I am curious if the mortgage rates r fixed for 15yrs ? Ours was fixed every 5yrs. During each term, a same amount is deducted monthly from our acount.

As more principal were paid off, the equation within this amount is more principal n less interest.

The bank did profit from 3 times the principal borrowed. We r allowed to deduct the interest paid via income tax(scale of 38% to 52%). Real estate is not a money maker here, so we cant recoup back the great expense.

I know that most buyers in Sg pay via CPF. Is there a provision for tax deduction for those who borrowed from the banks ?
Fri Jan 30, 05:27:00 AM GMT+8
Singapore Short Stories said…
Oh Dutchie, it was just an example. Usually for flats here in Singapore, its 20 years.

I am not too sure of the provision though.
Sat Jan 31, 11:30:00 AM GMT+8
Post a Comment

Popular posts from this blog

Vernon Leong Jun Wei

What happens to the 31 year old bride groom, Vernon Leong Jun Wei? As the news of this latest unnatural and bizzare death developed, it seemed that Vernon did not jump from the 24th storey of Hilton Hotel as was believed earlier. There were 3 video camera footages which might prove otherwises for the cause of Vernon's death. The first video footage showed Vernon at the 24th storey, making his way hurriedly into the fire escape staircase. The next video footage showed Vernon at the 2nd storey which also holds some shops and the final footage showed an unconscious Vernon motionless at the ground of the hotel. Vernon was cladded casually in a T-shirt and pants and have left his hotel room while his wife was taking a shower. It seemed that he might be escaping from something or somebody or that he might be chasing after something or somebody. What did Vernon see and experience at his last moments? The police is still investigating the case. It is really a very tragical and sad
Post a Comment
Read more

Kampong Lorong Buangkok

Amidst the blazing afternoon sun today, my Dear and I made our way to Kampong Lorong Buangkok. The visit was a timely one as there is such a high buzz being generated over the last kampong in modern Singapore. After alighting from Bus 854 from Eunos, it was not difficult to find our way to the kampong. The entrance of the kampong was distinct as you could see from the picture: the 'ulu-ness' (rural charm) is evident from the attap-roofed buildings and more unkempt conditions. A signboard with hand-written text welcome my Dear and I to the last kampong in Singapore: As we entered the kampong, I spotted a middle-aged woman talking to an old man. I had seen the old woman before on TV. She was none other than the owner of the kampong land. In the documentary, I learnt that the whole kampong land was passed to her by her late father. She has kept the land and have not gone on to sell the land to the government. If she were to sell the land, she would be an instant multi-millionair
Post a Comment
Read more

Performance Bonus

It is the time of the year civil servants receive their performance bonuses (PBs). In the coming two weeks, civil servants will not only receive their performance bonuses, special ‘growth bonuses’, would also await them for the very first time. These PBs and growth bonuses are only applicable to performers, defined as officers with assessed performance gradings above the ‘D’ grade. Typically, civil servants receive their performance bonuses in March, a 0.5 month of bonus in July and a 13th month plus AVC in December. Are all the bonuses good? To be frank, the bonuses dished out in Civil Service are averages at best. With the various bonuses being given out in these months: July, December and March, a civil servant who would like to quit would most likely try to find a ‘suitable’ month to quit so as not to forfeit his bonuses. The December bonus is generally the most generous portion. To quantify for this bonus, an officer would have to be in service till the end of January ne
1 comment
Read more