Syntax
=NPER(rate, pmt, pv, [fv], [type])Arguments
| Argument | Required | Description |
|---|---|---|
rate | Required | The interest rate per period |
pmt | Required | The payment made each period |
pv | Required | The present value |
fv | Optional | The value wanted after the last payment (0 when left out) |
type | Optional | 0 for payments at the end of each period, 1 at the start |
How to use NPER
NPER takes 3 required arguments and 2 optional arguments. Type =NPER( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=NPER(0.12/12, -100, -1000, 10000, 1)Result =NPER(0.12/12, -100, -1000, 10000)Result =NPER(0.12/12, -100, -1000)Result Related financial functions
- ISPMTReturns the interest paid in one period of a loan with equal principal repayments.
- MDURATIONReturns the modified duration in years of a security that pays periodic interest, for 100 face value.
- MIRRReturns the modified internal rate of return, with separate rates for financing and reinvestment.
- NOMINALReturns the nominal annual interest rate from an effective rate and the compounding periods per year.
- NPVReturns the net present value of future cash flows (at the end of each period) at a discount rate.
- ODDFPRICEReturns the price per 100 face value of a security with an odd (short or long) first period.
- ODDFYIELDReturns the yield of a security with an odd (short or long) first period.
- ODDLPRICEReturns the price per 100 face value of a security with an odd (short or long) last period.
- ODDLYIELDReturns the yield of a security with an odd (short or long) last period.