NPER function
the number of periods for an investment.
Financial
Where can you use it?
Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.
Scenario in the workbook
Calculate the number of payment periods. The payment and present value have opposite cash-flow signs.
A worked example from the workbook
| Row | A | B | C |
|---|---|---|---|
| 6 | Input | Criterion | Amount |
| 7 | 0 | 100 | 1200 |
| 8 | 0 | 50 | 300 |
| 9 | 0 | 25 | 75 |
Record 1
=NPER(A7,-B7,C7)Expected result12
See the inputs and instructions for all 3 examplesCopyable formulas
English Excel · en-US
=NPER(0,-100,1200)Turkish Excel · tr-TR
=TAKSİT_SAYISI(0;-100;1200)Expected result
12
Worked examples
Calculate the number of payment periods. The payment and present value have opposite cash-flow signs.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A | B | C |
|---|---|---|---|
| 6 | Input | Criterion | Amount |
| 7 | 0 | 100 | 1200 |
| 8 | 0 | 50 | 300 |
| 9 | 0 | 25 | 75 |
| Case | Formula | Expected result |
|---|---|---|
| Record 1 | =NPER(A7,-B7,C7) |
12 |
| Record 2 | =NPER(A8,-B8,C8) |
6 |
| Record 3 | =NPER(A9,-B9,C9) |
3 |