Manuals/calci/NPER

NPER (Rate,Payment,PresentValue,FutureValue,Type)

• $Rate$ is the interest rate.
• $Payment$ is the amount for a period.
• $PresentValue$ is the at present value.
• $FutureValue$ is the future value.
• $Type$ is the type.
  • NPER(),returns the number of periods for an investment.

Description

• This function gives the number of periods for an investment.
• It is based on the period, fixed payments and a fixed interest rate.
• This function calculates number of periods for an investment or a loan with the assumption of constant payments at regular intervals and a fixed interest rate.
• In $NPER(Rate,Payment,PresentValue,FutureValue,Type)$ , $Rate$ is the rate of interest for the period.
• Suppose we are taking a loan for 8 percent annual interest rate and paying the amount in monthly, then the $Rate$ value is 8%/12.
• So we have to enter the $Rate$ value as 8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
• $Payment$ is the fixed payment payed in each period and there is no changes in the life of the annuity.
• Normally $Payment$ value includes principal and interest amount but there is no other fees or taxes additionally.
• We have to enter $Payment$ with negative(-) sign. $FutureValue$ is the future value of an investment or loan (the value you want to achieve at the end of all periods) when we are omitting the value of $FutureValue$ ,then it is assumed to be 0.
• $Type$ is the number 0 or 1 which is specifies the time to make a payment during the period.
• when we are not giving the value of $Type$, then it is assumed to be 0. .

Type value	Explanation
0	Payments are due at the end of the period
1	Payments are due at the beginning of the period

Examples

1. =NPER(14%/12,-1500,-4000,100000,1) = 46.55666767
2. =NPER(10%/12,-750,-2900,800000,1) = 271.42461700707
3. =NPER(10%/12,-750,-2900,800000,0) = 272.292024206798
4. =NPER(15%/12,-300,20000) = 144.2347824
5. =NPER(15%/12,-300,20000,500000) = 392.4483377

Related Videos

NPER Function

See Also

• FV
• IPMT
• PMT
• PPMT

References

• Number of payment periods

• List of Main Z Functions

• Z3 home