Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
NPER
NPER calculates how many payment periods are needed for a loan balance to reach zero (or a future value) given a fixed periodic interest rate and payment amount. Use it to determine loan term length or savings horizon.
Excel
=NPER(0.005,-300,9000)Google Sheets
=NPER(0.005,-300,9000)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Parameter | Value |
| Rate | 0.005 |
| Pmt | -300 |
| PV | 9000 |
| FV | 0 |
=NPER(0.005,-300,9000)→32.5849778168
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Gather the periodic interest rate (annual rate ÷ periods per year), the fixed payment (negative for outflows), and the current balance (positive for borrowing).
- 2Enter =NPER(rate, pmt, pv) to get the number of periods.
- 3Divide the result by 12 if the rate is monthly and you want years.
Need a version for your data?
Try: “How many months will it take to pay off a $9,000 loan at 0.5% monthly interest with $300 payments?”