One use of the NPER function is to calculate the number of periodic payments for loan.
The NPER function is configured as follows:
rate- The interest rate per period.
This is the known amount $93.22, which comes from cell C7.
pv- The present value, or total value of all payments now.
We do not provide a value since the default is zero and makes sense for a loan.
jot down- When payments are due, where 0 = end of period and 1 = beginning of period.
Default is 0 so we do not provide a value.
