WorksheetFunction.Ispmt(Double, Double, Double, Double) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Calculates the interest paid during a specific period of an investment. This function is provided for compatibility with Lotus 1-2-3.

public:
 double Ispmt(double Arg1, double Arg2, double Arg3, double Arg4);

public double Ispmt (double Arg1, double Arg2, double Arg3, double Arg4);

Public Function Ispmt (Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double) As Double

Parameters

Arg1: Double

Rate - the interest rate for the investment.

Arg2: Double

Per - the period for which you want to find the interest, and must be between 1 and nper.

Arg3: Double

Nper - the total number of payment periods for the investment.

Arg4: Double

Pv - the present value of the investment. For a loan, pv is the loan amount.

Returns

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.

Applies to