Important Notice

The pages on this site contain documentation for very old MS-DOS software, purely for historical purposes. If you're looking for up-to-date documentation, particularly for programming, you should not rely on the information found here, as it will be woefully out of date.

  ◄Syntax►  ◄Details►  ◄Example►                 ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
NPer# (rate#, pmt#, pv#, fv#, type%, status%)
 
    ■ rate#      The interest rate per period (for example, .12).
    ■ pmt#       The payment to be made each period.
    ■ pv#        The present value.
    ■ fv#        The future value.
    ■ type%      An integer expression: 0 = end-of-period payment;
                                        1 = beginning-of-period payment.
    ■ status%    A variable that returns a value indicating calculation
                 failure or success: 0 = success; 1 = failure.
 
Returns
    The number of periods for an investment based on periodic, constant
    payments and a constant interest rate.
 
See Also    ◄FV#►    ◄IPmt#►    ◄PPmt#►    ◄Pmt#►    ◄PV#►    ◄Rate#►