NPER
FinancialExcel 2007How many periods to pay off a loan or reach a savings goal.
Syntax
NPER(rate, pmt, pv, [fv], [type])
Examples
=NPER(8%/12, -30000, 3000000)/12
→ years to close the loan at ₹30k/mo
Related functions
More Financial functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.