Edit

Share via


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

Definition

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

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