nper

Number of payment periods for a loan or investment.

Syntax

v = nper(rate, pmt, pv, fv, type)

Description

Returns the number of periods needed to reach fv (default 0) starting from pv with periodic payment pmt at rate rate.

Example

nper(0.05/12, -1500, 200000)    % months to pay off

See also

• pmt — Periodic payment for a loan or annuity.
• pv — Present value of an investment.
• fv — Future value of an investment.
• rate — Periodic interest rate for an annuity.