IPMT

回答: 回複:Formula for calculating mortgagerenata2009-05-09 00:29:03

Sorry, I dashed out this morning before I replied the second question.

Please use IPMT(Rate, Period, No.ofMonth, Capital Amount) to calculate the interest only.

As I never used interest-payment-only mortgage thus I didn't check and compare the results yet.
請您先登陸,再發跟帖!