IPMT

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.