WorksheetFunction.Ispmt Method
Calculates the interest paid during a specific period of an investment. This function is provided for compatibility with Lotus 1-2-3.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Ispmt ( _
Arg1 As Double, _
Arg2 As Double, _
Arg3 As Double, _
Arg4 As Double _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim Arg2 As Double
Dim Arg3 As Double
Dim Arg4 As Double
Dim returnValue As Double
returnValue = instance.Ispmt(Arg1, Arg2, _
Arg3, Arg4)
double Ispmt(
double Arg1,
double Arg2,
double Arg3,
double Arg4
)
Parameters
Arg1
Type: System.DoubleRate - the interest rate for the investment.
Arg2
Type: System.DoublePer - the period for which you want to find the interest, and must be between 1 and nper.
Arg3
Type: System.DoubleNper - the total number of payment periods for the investment.
Arg4
Type: System.DoublePv - the present value of the investment. For a loan, pv is the loan amount.
Return Value
Type: System.Double
Remarks
Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 12%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 12% for rate and 4 for nper.
For all the arguments, the cash you pay out, such as deposits to savings or other withdrawals, is represented by negative numbers; the cash you receive, such as dividend checks and other deposits, is represented by positive numbers.
For additional information about financial functions, see the Pv(Double, Double, Double, Object, Object) function.