◄Summary►  ◄Details►  ◄Example►                ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
          Financial Functions available in Professional Edition only
──────────────────────────────────────────────────────────────────────────────
 Returns number of periods for an investment based on periodic, constant
 payments and a constant interest rate. Requires FINANCE.QLB (FINANCE.LIB
 when compiling); include FINANCE.BI.
 
    NPer# (rate#, pmt#, pv#, fv#, type%, status%)
 
    ■ rate#      Interest rate per period (for example, .12)
 
    ■ pmt#       Payment to be made each period
 
    ■ pv#        Present value
 
    ■ fv#        Future value
 
    ■ type%      Integer expression:
                 0 = end-of-period payment
                 1 = beginning-of-period payment
 
    ■ status%    Variable that returns a value indicating calculation
                 failure or success:
                 0 = success
                 1 = failure
 
 See Also
    ◄Financial Function Summary►   ◄$INCLUDE Metacommand►   ◄Quick Libraries►