WorksheetFunction.NPer Method

Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function NPer ( _
    Arg1 As Double, _
    Arg2 As Double, _
    Arg3 As Double, _
    Arg4 As Object, _
    Arg5 As Object _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim Arg2 As Double
Dim Arg3 As Double
Dim Arg4 As Object
Dim Arg5 As Object
Dim returnValue As Double

returnValue = instance.NPer(Arg1, Arg2, _
    Arg3, Arg4, Arg5)

double NPer(
    double Arg1,
    double Arg2,
    double Arg3,
    Object Arg4,
    Object Arg5
)

Parameters

• Arg1
  Type: System.Double

  Rate - the interest rate per period.

• Arg2
  Type: System.Double

  Pmt - the payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes.

• Arg3
  Type: System.Double

  Pv - the present value, or the lump-sum amount that a series of future payments is worth right now.

• Arg4
  Type: System.Object

  Fv - the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0).

• Arg5
  Type: System.Object

  Type - the number 0 or 1 and indicates when payments are due.

Return Value

Type: System.Double

Remarks

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace