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