Outline ·
[ Standard ] ·
Linear+
how to count monthly payment?, help me please
|
TSSeng_Kiat
|
Sep 22 2008, 11:56 AM, updated 18y ago
|
|
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
|
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.
|
|
|
|
|
|
TSSeng_Kiat
|
Sep 22 2008, 12:01 PM
|
|
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) ..  .. This post has been edited by Seng_Kiat: Sep 22 2008, 12:02 PM
|
|
|
|
|
|
b00n
|
Sep 22 2008, 12:18 PM
|
delusional
|
Search up amortising formula... Maybe you could start by searching up threads here....
|
|
|
|
|
|
a6meister
|
Sep 22 2008, 12:23 PM
|
|
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
|
Sep 22 2008, 01:23 PM
|
|
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
|
Sep 22 2008, 04:11 PM
|
New Member
|
Alliance bank: 1-2 yr blr-2.30% 3-5 yr BLR-2.05% Theareafter Blr-2.05% want more infor PM me.
|
|
|
|
|
|
ed0gawa
|
Sep 22 2008, 06:01 PM
|
|
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
|
Sep 24 2008, 12:42 AM
|
|
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.
|
|
|
|
|