Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 how to count monthly payment?, help me please

views
     
TSSeng_Kiat
post Sep 22 2008, 11:56 AM, updated 18y ago

Look at all my stars!!
*******
Senior Member
5,580 posts

Joined: Jan 2005
hi guys,

let say i buy a house worth RM150k and loan for 30 years, how to calculate the monthly installment? as for interest rate, i am not sure how many percent for house loan. Could you help me on this?
Lord_Ashe
post Sep 22 2008, 11:58 AM

Old Treasure Hunter Sidekick
******
Senior Member
1,495 posts

Joined: Sep 2005
From: Damansara Perdana - KL


When you apply for a loan from the bank, they'll have the handy calculator which takes into account the interest rate etc etc. Just walk into any bank to find out.
TSSeng_Kiat
post Sep 22 2008, 12:01 PM

Look at all my stars!!
*******
Senior Member
5,580 posts

Joined: Jan 2005
QUOTE(Lord_Ashe @ Sep 22 2008, 11:58 AM)
When you apply for a loan from the bank, they'll have the handy calculator which takes into account the interest rate etc etc. Just walk into any bank to find out.
*
the problem is i need to budget first before go to bank. from that, at least i have rough amount.

to calculate house loan, is it same as car loan?

x% * y years + 1 * v value / (y*12) .. smile.gif ..

This post has been edited by Seng_Kiat: Sep 22 2008, 12:02 PM
b00n
post Sep 22 2008, 12:18 PM

delusional
Group Icon
VIP
9,137 posts

Joined: Jun 2007
From: Wouldn't be around much, pls PM other mods.
Search up amortising formula...
Maybe you could start by searching up threads here....
a6meister
post Sep 22 2008, 12:23 PM

Casual
***
Junior Member
462 posts

Joined: Feb 2007
call up a loan officer near to you. ask him to get amortising calculation for you for first year, second year, third year, and subsequent year.

no need to calculate yourself.
jchong
post Sep 22 2008, 01:23 PM

****************
*******
Senior Member
5,989 posts

Joined: Nov 2005
Just use online loan calculators, like this one from RHB. Easy peasy.

As for interest rate, you might be able to get BLR - 2%.
skybees
post Sep 22 2008, 04:11 PM

New Member
*
Junior Member
33 posts

Joined: May 2008
Alliance bank: 1-2 yr blr-2.30%
3-5 yr BLR-2.05%
Theareafter Blr-2.05%
want more infor PM me.smile.gif


ed0gawa
post Sep 22 2008, 06:01 PM

coconut
*******
Senior Member
4,398 posts

Joined: Jan 2003




zzz.. people asking for how much he need to pay, not asking what offer he can get..

Property price : RM150k
Loan amount : 90% i.e RM135k
Interest Rate : BLR - 1.7%
Tenure : 30 years

Monthly Installment : RM728.84
Total Repayment after 30yrs : RM262,382.44
Total Interest charged : RM127,382.44

Well, interest rate varies among different banks, thus ... treat this as a reference
clieman
post Sep 24 2008, 12:42 AM

Enthusiast
*****
Senior Member
731 posts

Joined: Nov 2006
From: Shah Alam


Use Excel. The function is PMT(rate,nper,pv,{fv,type})

Rate is in %, nper is number of years X 12, PV is your loan. The result will be a negative value which is your monthly installment.

You can ignore the parameters in {}. Look up Excel help if you need more example.

 

Change to:
| Lo-Fi Version
0.0154sec    0.32    5 queries    GZIP Disabled
Time is now: 15th December 2025 - 03:02 PM