All functions / Financial
NPER
How many payment periods are needed to pay off a loan.
Syntax
=NPER(rate, pmt, pv, [fv], [type])
Arguments
rate: Interest rate per period, e.g. 5%/12 for monthly payments at 5% a year.pmt: The payment each period.pv: The loan amount.fv(optional): Final balance (default 0).type(optional): 0 (default) = payments at the end of each period, 1 = at the start.