## What is the NPER Function?

The NPER function calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

## What is the Nper equation?

That is the number of periodic payments that are needed given the interest rate, opening and closing balances and the payment values required. Formula: NPER= IF Rate =0 THEN (-Pv – Fv)/PMT ELSE LOG((-Rate*Fv+PMT*(1+Rate*Type))/(Rate*Pv+PMT*(1+Rate*Type)))/LOG(1+Rate)