Re: 求教：这事有人做过吗？# Living
e*s
1 楼
It is like a reversed process as you get interest from bank. The more
frequently they do a recalc., the more interest you get. So you do save more
money by paying more frequently but I do not think it will save much.
If you want to quantify, try this:
Assuming a loan of 400K, 30 Year fix at 5%, you can figure out the total
interest you would have paid by end of year 30 is $373023 by employing the
function: cumipmt(5%/12, 360, 400K, 1, 360, 0) in Excel;
and you monthly payment is: $2147.
While ch
frequently they do a recalc., the more interest you get. So you do save more
money by paying more frequently but I do not think it will save much.
If you want to quantify, try this:
Assuming a loan of 400K, 30 Year fix at 5%, you can figure out the total
interest you would have paid by end of year 30 is $373023 by employing the
function: cumipmt(5%/12, 360, 400K, 1, 360, 0) in Excel;
and you monthly payment is: $2147.
While ch