IPER Function

Share this page

IPER Function

The IPER function calculates the interest rate per period based on the same formula for FV.

This function has the following syntax:

IPER(pmt = value, pv = value, nper = value[, fv = value, paybegin])

Note: Paybegin is either 1 or 0, indicating that the payment is made at the beginning or end of the period.

Arguments	Data Type	Description
pmt	Float	Periodic payment
pv	Float	Present value
nper	Float	Number of periods
fv	Float	Future value (default = 0)
paybegin	Integer	1 = beginning of period 0 = end of period Default: 0

This function returns:

• Float—The interest per period

• Null—On error