NPER

See also A-Z Spreadsheet Function List

Description Returns the number of periods of an investment based on regular periodic payments and a fixed interest rate.

Syntax NPER(interest, pmt, pf [, fv] [, type])

interest is the fixed interest rate.

pmt is the fixed payment made each period. Generally, pmt includes the principle and interest, not taxes or other fees.

pf is the present value, the lump-sum amount that a series of future payments is currently worth.

fv is the future value, the balance to attain after the final payment. Omitting this argument assumes a future balance of 0.

type indicates when payments are due. Use 0 if payments are due at the end of the period or 1 if payments are due at the beginning of the period. When you omit this argument, 0 is assumed.

See Also FV , IPMT , PMT , PPMT , PV , and RATE functions

Examples NPER(12%/12, -350, -300, 16000, 1) returns 36.67

         NPER(1%, -350, -300, 16000) returns 36.98