p**5
发帖数: 2544 | 1 从精华区看到的，第一个link说的好玄啊，是真的吗？
http://www.sideroad.com/Mortgage/bi-weekly-mortgage-payment.htm
发信人: erdos (大宗师), 信区: Living
标 题: Re: 求教：这事有人做过吗？
发信站: Unknown Space - 未名空间 (Thu Apr 21 00:35:20 2005) WWW-POST
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 change it to payment biweekly, the the total interest you would pay by
end of Year 30 is:
cumipmt(5%/24, 720, 400K, 1, 720, 0)=$372676
and your mmonthly payment is: $1073x2=$2146.
So you can save about $350 over 30 years.
It is quite different as the guy described. I am assuming the two products
have the same interest rate. I am not sure if it involves other change of
parameters or maybe he means something different. | p***o
发帖数: 1252 | 2 半月和两周差的挺远的。
more
【在 p**5 的大作中提到】
: 从精华区看到的，第一个link说的好玄啊，是真的吗？
: http://www.sideroad.com/Mortgage/bi-weekly-mortgage-payment.htm
: 发信人: erdos (大宗师), 信区: Living
: 标 题: Re: 求教：这事有人做过吗？
: 发信站: Unknown Space - 未名空间 (Thu Apr 21 00:35:20 2005) WWW-POST
: 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
| y******n
发帖数: 8667 | |
|
