Loading…
Loading…
NPER returns the number of payment periods.
=NPER(rate, pmt, pv, [fv], [type])
| Argument | Required? | What it is |
|---|---|---|
| rate | Required | The interest rate per period. For monthly payments, divide the annual rate by 12. |
| pmt | Required | The payment made each period. Money you pay out is negative. |
| pv | Required | Present value: the amount now, such as the loan amount. |
| fv | Optional | Future value: the balance you want left after the last payment. Usually 0. |
| type | Optional | When payments are made: 0 (or left out) at the end of each period, 1 at the start. |
Type the formula yourself and get it graded instantly, no Excel needed.