Excel Function : NPER
Category
Financial
Description
Returns the number of periods for an investment
Microsoft Excel Reference Page
https://support.office.com/en-us/article/NPER-function-240535b5-6653-4d2d-bfcf-b6a38151d815
Syntax and Description of the NPER Excel Function
=NPER(rate,pmt,pv,[fv],[type])
About NPER Excel Function
The NPER function calculates the number of periods for an investment based on periodic, constant payments and a constant interest rate. The syntax for the NPER function is as follows: =NPER(rate, pmt, pv, [fv], [type]) rate - The interest rate per period. pmt - The payment made each period; it cannot change over the life of the investment. pv - The present value, or the lump-sum amount that a series of future payments is worth now. fv - [Optional] The future value, or a cash balance you want to attain after the last payment is made. If omitted, N
