Question: how to calculate nper in excel?
Answer: Summary. ...  Get number of periods for loan or investment. The number of periods. =NPER (rate, pmt, pv, [fv], [type]) rate - The interest rate per period. ...  You can use the NPER function to get the number of payment periods for a loan (or an investment), given the amount, the interest rate, and a periodic payment amount.