emmmm2009-05-08 22:33:15

If you are using Excel, there are built-in function for mortgage calculating.

For example, for capitcal repayment mortgage:

=PMT(monthly interest rate, no.of months, captical amount).

if annual interest rate = 2.98%, then monthly rate = 2.98% / 12

no. of months of total payment, say 20 years term, = 12 x 20

capital amount = total amount borrowed say 300,000

PMT(2.98%/12, 240, 300,000) = 1,660.79, which is monthly payment.

IPMT function is used for Interest Payment Only Mortgage.
renata2009-05-09 08:29:03
回复:Formula for calculating mortgage
emmmm2009-05-09 09:41:40
回复:回复:Formula for calculating mortgage
emmmm2009-05-09 19:28:26
IPMT
jerff2009-05-10 01:20:13
强,但Excel的这个功能似乎有个严重错误。
emmmm2009-05-10 10:29:41
回复:强,但Excel的这个功能似乎有个严重错误。
jerff2009-05-11 16:42:38
原来如此,长了见识,谢谢。
卫明2009-05-12 10:45:05
省事的办法,上这个网下个excel calculator
卫明2009-05-12 10:55:29
http://www.simpleplanning.com/