Formula for calculating mortgage

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.

所有跟帖： 

• 回复：Formula for calculating mortgage -renata- ♀ (313 bytes) () 05/09/2009 postreply 00:29:03

• 回复：回复：Formula for calculating mortgage -emmmm- ♀ (565 bytes) () 05/09/2009 postreply 01:41:40

• IPMT -emmmm- ♀ (277 bytes) () 05/09/2009 postreply 11:28:26

• 强，但Excel的这个功能似乎有个严重错误。 -jerff- ♀ (301 bytes) () 05/09/2009 postreply 17:20:13

• 回复：强，但Excel的这个功能似乎有个严重错误。 -emmmm- ♀ (774 bytes) () 05/10/2009 postreply 02:29:41

• 原来如此，长了见识，谢谢。 -jerff- ♀ (0 bytes) () 05/11/2009 postreply 08:42:38

• 省事的办法，上这个网下个excel calculator -卫明- ♂ (168 bytes) () 05/12/2009 postreply 02:45:05

• http://www.simpleplanning.com/ -卫明- ♂ (0 bytes) () 05/12/2009 postreply 02:55:29