Manuals/calci/NPER

NPER(r,pm,pv,fv,ty)

• $r$ is the interest rate.
• $pm$ is the amount for a period.
• $pv$ is the at present value.
• $fv$ is the future value.
• $ty$ is the type.

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(r,pm,pv,fv,ty)$ , $r$ 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 $r$ value is 8%/12.
• So we have to enter the $r$ value as 8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
• $pm$ is the fixed payment payed in each period and there is no changes in the life of the annuity.
• Normally $pm$ value includes principal and interest amount but there is no other fees or taxes additionally.
• We have to enter $pm$ with negative(-) sign. $fv$ 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 $fv$ ,then it is assumed to be 0.
• $ty$ 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 $ty$, then it is assumed to be 0. .

ty 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