- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Financial - NPER Function
Description
The NPER function returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
Syntax
NPER (rate,pmt,pv,[fv],[type])
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Rate | The interest rate per period. | Required |
Pmt | The payment made each period. It cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes. |
Required |
Pv | The present value, or the lump-sum amount that a series of future payments is worth right now. | Optional |
Fv | The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0). |
Optional |
Type | The number 0 or 1 and indicates when payments are due. See Table given below. If type is omitted, it is assumed to be 0. |
Optional |
Set type equal to | If payments are due |
---|---|
0 | At the end of the period |
1 | At the beginning of the period |
For complete description of the arguments in NPER and for more information about annuity functions, see PV.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_financial_functions.htm
Advertisements