NPER Function

Originally published at: How to use the NPER Function in Excel - Excelbuddy.com

The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods of a loan are based on fixed data such as loan amount, interest rate, monthly payments, and compounding periods per year. Syntax: =NPER(rate,pmt,pv,[fv],[type]) Arguments: rate – The interest rate per period.pmt – The…