Calculate Interest Method

The Calculate Interest method calculates, and then returns the interest portion of a payment for a given period of an annuity.

Format

IPmt(rate, period, nper, pv, fv, due)

For more information, see Arguments You Can Use with Financial Methods.

Example

The following example calculates the interest portion of a loan payment amount for payments made in the last month of the first year. The loan is for $25,000 to be paid back over 5 years at 9.5% interest:

Sub Button_Click
   Dim aprate, periods
   Dim payperiod
   Dim loanpv, due
   Dim loanfv, intpaid
   Dim msgtext
   aprate = .095
   payperiod = 12
   periods = 120
   loanpv = 25000
   loanfv = 0
   ' Assume payments are made at end of month
   due = 0
   intpaid = IPmt(aprate/12,payperiod,periods, _
   loanpv,loanfv,due)
   msgtext = "For a loan of $25,000 @ 9.5% for 10 years," _ 
    & Chr(10)
   msgtext = msgtext + "the interest paid in month 12 is: "_
         & Format(intpaid, "Currency")
End Sub