Excel Function : RRI

Download now!

Excel Function : RRI




Returns an equivalent interest rate for the growth of an investment

Microsoft Excel Reference Page


Syntax and Description of the RRI Excel Function

RRI function in Excel returns the equivalent rate for a given period when the interest is compounded at a given frequency. The syntax for the RRI function is: RRI(nper, pv, fv, type) where: - nper: the number of periods - pv: the present value - fv: the future value - type: the type of payment (0 for end of period, 1 for beginning of period)

About RRI Excel Function

The RRI function calculates the rate of return for an investment based on the number of periods, periodic payment, and present value.