Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 House 🏡 Loan Calculation

views
     
SUSAznRicy
post Sep 22 2017, 07:36 AM, updated 8y ago

Getting Started
**
Junior Member
59 posts

Joined: Jun 2015
I hav a house loan

Duration = 30 years
Loan amount = 443 220 (89%)
Monthly pay = 2200

Outstanding = 416 000
Advanced paid = 40000
Pay since Oct 2012 = 4 years (2200 x 48 months) = 105 600

My question is how is the Outstanding calculated?
Interest around 4.3% I think.

Can someone please explain how does the calculation work?
Has the outstanding Minus off Advanced?
Or when Advanced > Outstanding = Fully Paid?

sonic31s
post Sep 22 2017, 07:47 AM

Getting Started
**
Junior Member
212 posts

Joined: Apr 2016
Did you include the BLR rate?
v1n0d
post Sep 22 2017, 07:52 AM

Another roof, another proof.
*******
Senior Member
3,197 posts

Joined: Mar 2007
From: Kuala Lumpur, Malaysia


Interest is computed on daily rest based on your outstanding amount. Unless you're on a full-flexi loan, the outstanding amount does not take into account the advance payment.
cybpsych
post Sep 22 2017, 08:08 AM

---------------------
*********
All Stars
65,332 posts

Joined: Jan 2003
better post at its proper place?

https://forum.lowyat.net/topic/3437581 or https://forum.lowyat.net/PropertyQ&A
SUSAznRicy
post Sep 22 2017, 08:13 AM

Getting Started
**
Junior Member
59 posts

Joined: Jun 2015
QUOTE(v1n0d @ Sep 22 2017, 07:52 AM)
Interest is computed on daily rest based on your outstanding amount. Unless you're on a full-flexi loan, the outstanding amount does not take into account the advance payment.
*
So, from info here, can we know roughly how much interest had been paid?

Loan Amount - Outstanding = Principal paid?
443 220 - 416 000 = 27 220

Installment - Principal = Total Interest Paid?
105 600 - 27 220 - advance (40000) = 38 380?
Around 800 per month paid for interest?
AskarPerang
post Sep 22 2017, 08:14 AM

~tUPaI...~
*********
All Stars
23,688 posts

Joined: Aug 2007
From: Outer Space



amortisation formula
your monthly repayment in the early years will be used to serve the bank interest more rather than to reduce the outstanding loan amount.
AskarPerang
post Sep 22 2017, 08:16 AM

~tUPaI...~
*********
All Stars
23,688 posts

Joined: Aug 2007
From: Outer Space



QUOTE(AznRicy @ Sep 22 2017, 08:13 AM)
So, from info here, can we know roughly how much interest had been paid?

Loan Amount - Outstanding = Principal paid?
443 220 - 416 000 = 27 220

Installment - Principal = Total Interest Paid?
105 600 - 27 220 - advance (40000) = 38 380?
Around 800 per month paid for interest?
*
yes correct. refer to my answer above.
v1n0d
post Sep 22 2017, 08:21 AM

Another roof, another proof.
*******
Senior Member
3,197 posts

Joined: Mar 2007
From: Kuala Lumpur, Malaysia


QUOTE(AznRicy @ Sep 22 2017, 08:13 AM)
So, from info here, can we know roughly how much interest had been paid?

Loan Amount - Outstanding = Principal paid?
443 220 - 416 000 = 27 220

Installment - Principal = Total Interest Paid?
105 600 - 27 220 - advance (40000) = 38 380?
Around 800 per month paid for interest?
*
You can use online calculators such as this to see how much of your monthly installment is being used for principal repayment and interest respectively. By right, your bank should have provided you an amortization schedule together with your loan contract.

Personally, I use Karl's Mortgage Calculator. It's available on both the App Store and Google Play. Works well, and allows you to see the effect of extra payments etc.
SUSAznRicy
post Sep 22 2017, 08:31 AM

Getting Started
**
Junior Member
59 posts

Joined: Jun 2015
QUOTE(v1n0d @ Sep 22 2017, 08:21 AM)
You can use online calculators such as this to see how much of your monthly installment is being used for principal repayment and interest respectively. By right, your bank should have provided you an amortization schedule together with your loan contract.

Personally, I use Karl's Mortgage Calculator. It's available on both the App Store and Google Play. Works well, and allows you to see the effect of extra payments etc.
*
Thank you for all the replies.
I will take a look later. smile.gif
dewill
post Sep 22 2017, 08:59 AM

Regular
******
Senior Member
1,720 posts

Joined: Feb 2006


1st of all, what type is your house loan? conventional loan, islamic loan or flexi loan?

SUSAznRicy
post Sep 22 2017, 09:06 AM

Getting Started
**
Junior Member
59 posts

Joined: Jun 2015
QUOTE(dewill @ Sep 22 2017, 08:59 AM)
1st of all, what type is your house loan? conventional loan, islamic loan or flexi loan?
*
Conventional. BLR that time Year 2012 when signed up for loan was 6.6, if I remember correctly, bank ?rate was ?2.3%. So, interest rate is 6.6 - 2.3 = 4.3%?
lifebalance
post Sep 22 2017, 09:11 AM

Licensed Financial Planner & Financial Adviser's Rep.
********
All Stars
10,162 posts

Joined: Nov 2014
QUOTE(AznRicy @ Sep 22 2017, 07:36 AM)
I hav a house loan

Duration = 30 years
Loan amount = 443 220 (89%)
Monthly pay = 2200

Outstanding = 416 000
Advanced paid = 40000
Pay since Oct 2012 = 4 years (2200 x 48 months) = 105 600

My question is how is the Outstanding calculated?
Interest around 4.3% I think.

Can someone please explain how does the calculation work?
Has the outstanding Minus off Advanced?
Or when Advanced > Outstanding = Fully Paid?
*
Hi there

The interest is calculated on a daily rest based on your interest rate per annum and the current outstanding balance.

I've calculated for you as per attachment

Your outstanding should be around 411,714.89

If you mentioned that you are paying RM2,200 on the dot, then your interest rate is 4.325%, not 4.3%

This post has been edited by lifebalance: Sep 22 2017, 09:13 AM


Attached thumbnail(s)
Attached Image
dewill
post Sep 22 2017, 09:18 AM

Regular
******
Senior Member
1,720 posts

Joined: Feb 2006


QUOTE(AznRicy @ Sep 22 2017, 09:06 AM)
Conventional. BLR that time Year 2012 when signed up for loan was 6.6, if I remember correctly, bank ?rate was ?2.3%. So, interest rate is 6.6 - 2.3 = 4.3%?
*
for conventional loan has been show from the above post. while for your advance payment, need to check on your loan contract for any penalty if pay in advanced by yourself and not write-in to the bank.

Some case, those advance payment will be bring forward to the last month of the loan which is month-n. It will not be auto deduct from the current outstanding payment.
SUSAznRicy
post Sep 27 2017, 12:13 PM

Getting Started
**
Junior Member
59 posts

Joined: Jun 2015
QUOTE(lifebalance @ Sep 22 2017, 09:11 AM)
Hi there

The interest is calculated on a daily rest based on your interest rate per annum and the current outstanding balance.

I've calculated for you as per attachment

Your outstanding should be around 411,714.89

If you mentioned that you are paying RM2,200 on the dot, then your interest rate is 4.325%, not 4.3%
*
Let say if I were to fully pay today, I only need to pay the outstanding, RM 411 714 right?

Does the interest 300k need to be pay too?
v1n0d
lifebalance
post Sep 27 2017, 12:15 PM

Licensed Financial Planner & Financial Adviser's Rep.
********
All Stars
10,162 posts

Joined: Nov 2014
QUOTE(AznRicy @ Sep 27 2017, 12:13 PM)
Let say if I were to fully pay today, I only need to pay the outstanding, RM 411 714 right?

Does the interest 300k need to be pay too?
v1n0d
*
if you put in 100% amount then yes you are paying the outstanding 411,714 without incurring any interest, but this is not possible because if you put in the full amount, it might trigger bank to think that you want to fully settle off the loan and might lead to early settlement penalty.
v1n0d
post Sep 27 2017, 04:02 PM

Another roof, another proof.
*******
Senior Member
3,197 posts

Joined: Mar 2007
From: Kuala Lumpur, Malaysia


QUOTE(AznRicy @ Sep 27 2017, 12:13 PM)
Let say if I were to fully pay today, I only need to pay the outstanding, RM 411 714 right?

Does the interest 300k need to be pay too?
v1n0d
*
lifebalance sums it up well. Check with your bank officer to confirm if there are any additional charges before you bank in the money.
SUSAznRicy
post Dec 15 2017, 06:35 PM

Getting Started
**
Junior Member
59 posts

Joined: Jun 2015
QUOTE(v1n0d @ Sep 27 2017, 04:02 PM)
lifebalance sums it up well. Check with your bank officer to confirm if there are any additional charges before you bank in the money.
*
Let say my mom wants to chip in 100k from her EPF as Advanced Payment.

Is this advisable n it will reduce overall interest since it is daily rest, right?

Because if her EPF divided after she’s gone, we, siblings n dad, may not share same objective to put into house.

The house loan is under TWO names, me n bro.
House deed is jointly including my mom.

Any future implications, u think? smile.gif lifebalance
lifebalance
post Dec 15 2017, 06:49 PM

Licensed Financial Planner & Financial Adviser's Rep.
********
All Stars
10,162 posts

Joined: Nov 2014
QUOTE(AznRicy @ Dec 15 2017, 06:35 PM)
Let say my mom wants to chip in 100k from her EPF as Advanced Payment.

Is this advisable n it will reduce overall interest since it is daily rest, right?

Because if her EPF divided after she’s gone, we, siblings n dad, may not share same objective to put into house.

The house loan is under TWO names, me n bro.
House deed is jointly including my mom.

Any future implications, u think? smile.gif lifebalance
*
well that depends on your interest rate that you pay to the bank vs the interest gain from EPF investment.

if the loan interest is higher than EPF, then by all means use EPF to pay off

but if EPF return is higher than the loan interest, then it's advisable to keep it in EPF.

Since you are mentioning that in the event your mom passes away, you and your siblings would like to go separate ways but the SPA belongs to your Mom, best is that she either change the SPA into both of your names or otherwise get her to write a will on who gets the property.

If there is no will, then there will be problems in handling down the property later on when she passes away.
CSS
post Dec 16 2017, 07:24 PM

Casual
***
Junior Member
475 posts

Joined: Mar 2009


QUOTE(AznRicy @ Sep 22 2017, 07:36 AM)
I hav a house loan

Duration = 30 years
Loan amount = 443 220 (89%)
Monthly pay = 2200

Outstanding = 416 000
Advanced paid = 40000
Pay since Oct 2012 = 4 years (2200 x 48 months) = 105 600

My question is how is the Outstanding calculated?
Interest around 4.3% I think.

Can someone please explain how does the calculation work?
Has the outstanding Minus off Advanced?
Or when Advanced > Outstanding = Fully Paid?
*
There’s bunch of home loan app calculators, I use “My Home Loan Calculator”. There’s a section that shows how much is deducted for your principle and interests each month. However, it’s still an estimate, best to check with your banker. They should provide yearly statements.

SUSAznRicy
post Dec 29 2017, 12:48 PM

Getting Started
**
Junior Member
59 posts

Joined: Jun 2015
QUOTE(lifebalance @ Dec 15 2017, 06:49 PM)
well that depends on your interest rate that you pay to the bank vs the interest gain from EPF investment.

if the loan interest is higher than EPF, then by all means use EPF to pay off

but if EPF return is higher than the loan interest, then it's advisable to keep it in EPF.

Since you are mentioning that in the event your mom passes away, you and your siblings would like to go separate ways but the SPA belongs to your Mom, best is that she either change the SPA into both of your names or otherwise get her to write a will on who gets the property.

If there is no will, then there will be problems in handling down the property later on when she passes away.
*
What is the impact of OPR increase expected on next year January on BLR interest?

OPR increase 0.25?
BLR increase 0.25? mega_shok.gif

A basis increase of 0.25 on RM400k loan? Will be around how much in long term?
Extra RM60 per month?

Current BLR = 6.85
Current interest rate = 6.85-2.3 = 4.55

Does OPR increase mean bank fixed deposits interest will also increase?
v1n0d

This post has been edited by AznRicy: Dec 29 2017, 12:49 PM
lifebalance
post Dec 29 2017, 01:25 PM

Licensed Financial Planner & Financial Adviser's Rep.
********
All Stars
10,162 posts

Joined: Nov 2014
QUOTE(AznRicy @ Dec 29 2017, 12:48 PM)
What is the impact of OPR increase expected on next year January on BLR interest?

OPR increase 0.25?
BLR increase 0.25? mega_shok.gif

A basis increase of 0.25 on RM400k loan? Will be around how much in long term?
Extra RM60 per month?

Current BLR = 6.85
Current interest rate = 6.85-2.3 = 4.55

Does OPR increase mean bank fixed deposits interest will also increase?
v1n0d
*
when OPR increases, FD rate increases as well.

Assuming 500k loan, 35 years tenure

Interest rate 4.4% - 2,335 monthly installment, total interest in 35 years - RM980,872

Interest rate 4.65% - 2,412 monthly, total interest in 35 years - RM1,013,434

So that's about extra 33k interest for 0.25% increment
SUSAznRicy
post Jan 10 2018, 02:49 PM

Getting Started
**
Junior Member
59 posts

Joined: Jun 2015
QUOTE(lifebalance @ Dec 29 2017, 01:25 PM)
when OPR increases, FD rate increases as well.

Assuming 500k loan, 35 years tenure

Interest rate 4.4% - 2,335 monthly installment, total interest in 35 years - RM980,872

Interest rate 4.65% - 2,412 monthly, total interest in 35 years - RM1,013,434

So that's about extra 33k interest for 0.25% increment
*
Y when OPR cut, suppose BLR will cut too?
Y I did not see reduction in monthly payment?

But when OPR increased, BLR increased I see need pay extra rm50 every month. sad.gif

v1n0d
v1n0d
post Jan 10 2018, 02:51 PM

Another roof, another proof.
*******
Senior Member
3,197 posts

Joined: Mar 2007
From: Kuala Lumpur, Malaysia


QUOTE(AznRicy @ Jan 10 2018, 02:49 PM)
Y when OPR cut, suppose BLR will cut too?
Y I did not see reduction in monthly payment?

But when OPR increased, BLR increased I see need pay extra rm50 every month. sad.gif

v1n0d
*
Sorry, not sure why myself. Hopefully someone from the banking line can help explain.
lifebalance
post Jan 10 2018, 06:18 PM

Licensed Financial Planner & Financial Adviser's Rep.
********
All Stars
10,162 posts

Joined: Nov 2014
QUOTE(AznRicy @ Jan 10 2018, 02:49 PM)
Y when OPR cut, suppose BLR will cut too?
Y I did not see reduction in monthly payment?

But when OPR increased, BLR increased I see need pay extra rm50 every month. sad.gif

v1n0d
*
BR and BLR runs on a different system

the movement of the BLR depends on the major bank in Malaysia, in this case (MBB)
HP Computer
post Jan 11 2018, 04:39 PM

Getting Started
**
Junior Member
183 posts

Joined: Dec 2017
Newbie on housing loan. hope someone can answer my question.

I have a semi-flexi house loan (daily interest) and my understanding is if i have made advance payment, my principle amount will reduce so as my loan tenure? Am i right?


 

Change to:
| Lo-Fi Version
0.0209sec    0.70    6 queries    GZIP Disabled
Time is now: 15th December 2025 - 12:26 AM