6.1.2.6.1.6 NPer

Function Declaration

 Function NPer(Rate As Double, Pmt As Double, PV As Double, 
               Optional FV As Variant, 
               Optional Due As Variant) As Double 

Parameter	Description
Rate	Double data value specifying interest rate per period. For example, given a loan at an annual percentage rate (APR) of 10 percent and making monthly payments, the rate per period is 0.1/12, or 0.0083.
Pmt	Double data value specifying payment to be made each period.
Pv	Double specifying present value, or value today, of a series of future payments or receipts.
Fv	Double data value specifying future value or cash balance desired after final payment has been made. If omitted, the Double data value 0.0 is assumed.
Due	Integer data value specifying when payments are due. Use the data value 0 if payments are due at the end of the payment period, or use the data value 1 if payments are due at the beginning of the period. If omitted, the data value 0 is assumed.

 

Runtime Semantics.

§ Returns a Double data value specifying the number of periods for an annuity based on periodic, fixed payments and a fixed interest rate.

§ For all arguments, cash paid out (such as deposits to savings) is represented by negative numbers; cash received (such as dividend checks) is represented by positive numbers.