Manuals/calci/NPER
Jump to navigation
Jump to search
NPER(Rate, PaymentPeriod, PresentValue, FutureValue, Type)
where,
Rate - represents the interest rate.
PaymentPeriod - the payment of each period.
PresentValue - represents the present value.
FutureValue - represents the future value.
Type - represents payments due.
Type Payment Due
0 or omitted end of the period
1 beginning of the period
It returns the number of periods for an investment based on periodic, constant interest rate and constant payments.
If Type other than 0 or 1, NPER returns the #ERROR.
NPER
Lets see an example in (Column1, Row6)
=NPER(0.2/12, R2C1, R3C1, R4C1, R5C1)
NPER returns -32.01946.
Consider another example
=NPER(0.1/12,50,-500,52000,4)
It returns #ERROR.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 20% | |||
| Row2 | 800 | |||
| Row3 | -5000 | |||
| Row4 | 23000 | |||
| Row5 | 1 | |||
| Row6 | -32.01946 |
