UltraCalcFunctionNPer Class

Calculates an investment's number of payment periods when the payment frequency, amount, and interest rate are held steady.

Syntax

Visual Basic

'Declaration
 
Public Class UltraCalcFunctionNPer 
   Inherits BuiltInFunctionBase

C#

public class UltraCalcFunctionNPer : BuiltInFunctionBase 

Remarks

NPER(interestRate, amount, presentValue, futureValue, paymentDue)

InterestRate is the rate of interest per payment period. This numeric value must be held fixed for the duration of the investment. If you must calculate financing based on changes in interest rate then you will need to break up the calculation into several stages over which the interest rate is held constant.

Amount is the payment amount due each period. This numeric value must be constant over the duration of the investment.

PresentValue is a discounted value or lump sum payment that if taken today and invested at the interestRate would be worth the same as this series of fixed payments in the future.

FutureValue is the value after the last payment has been made. If this numeric value is omitted it is assumed to be zero (since this function is normally used in calculating loan repayment you will reach zero liability when the loan is finally paid off.)

PaymentDue indicates whether payments come due at the beginning of each payment period (1) or at the end of each payment period (0). If left unspecified, the default is to assume paymentDue occurs at the end of each payment period.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2