NPER
Returns the number of periods for an investment.
FinancialFinance & Accounting
What it does
Calculates the number of periods for an investment based on periodic payments and constant interest.
Syntax
NPER(rate, pmt, pv, [fv], [type])
Arguments
rate(number) — Interest rate per period.pmt(number) — Payment per period.pv(number) — Present value.
Examples
Loan Periods
Months to pay off $1000 at $100/mo.
FORMULA
=NPER(0.01, -100, 1000)
RESULT
10.5
SAMPLE DATA
| A | |
|---|---|
| 1 | Loan |
| 2 | 1000 |