6. Functions : Finance Library Functions : IRATE Function
 
Share this page                  
IRATE Function
The IRATE function calculates the periodic interest rate required for an investment of present value to yield a specified future value over a number of periods.
This function has the following syntax:
IRATE(pv = value, fv = value, nper = value)
Arguments
Data Type
Description
pv
Float
Present value
fv
Float
Future value
nper
Integer
Number of periods
This function returns:
• Float—The interest rate per period
• Null—On error