QUOTE(b00n @ May 26 2008, 03:19 PM)
Like I say, the way you calculate interest shows that you're not familiar with housing loan interest at all....
mortgage interest is using amortising method.
excel PMT function:
(from excel help)
Calculates the payment for a loan based on constant payments and a constant interest rate.
Syntax
PMT(rate,nper,pv,fv,type)
For a more complete description of the arguments in PMT, see PV.
Rate is the interest rate for the loan.
Nper is the total number of payments for the loan.
Pv is the present value, or the total amount that a series of future payments is worth now; also known as the principal.
Fv is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
Type is the number 0 (zero) or 1 and indicates when payments are due.
And according to your first post example, you'll be paying RM599.55 per month.
Logically if you've dumped in RM50k the next month your monthly repayment should reduced to RM300.07 but the fact is flexi doesn't work that way. You'll still have to pay monthly RM599.55 till you finish finish paying down your principal.
ok, so i can conclude that, mortgage interest is using amortising method.
excel PMT function:
(from excel help)
Calculates the payment for a loan based on constant payments and a constant interest rate.
Syntax
PMT(rate,nper,pv,fv,type)
For a more complete description of the arguments in PMT, see PV.
Rate is the interest rate for the loan.
Nper is the total number of payments for the loan.
Pv is the present value, or the total amount that a series of future payments is worth now; also known as the principal.
Fv is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
Type is the number 0 (zero) or 1 and indicates when payments are due.
And according to your first post example, you'll be paying RM599.55 per month.
Logically if you've dumped in RM50k the next month your monthly repayment should reduced to RM300.07 but the fact is flexi doesn't work that way. You'll still have to pay monthly RM599.55 till you finish finish paying down your principal.
100k loan @ 6%
50k @ 6% = RM3k /year interest
599.55 X 12mont = RM7194.60 (total payment per year)
So after 1year, my outstanding loan amount would be
7194.6 - 3k(50k interest for 1year)
So i'll paying RM4194.60 on principle
instead of if i loan 100k no extra 50k payment
RM 7194.6 - 6k(10k interest for 1year)
pying RM 1194.6 on pinciple.
This post has been edited by ychwang: May 26 2008, 07:21 PM
May 26 2008, 07:20 PM

Quote
0.0295sec
0.34
6 queries
GZIP Disabled