Excel Function : RRI
Category
Financial
Description
Returns an equivalent interest rate for the growth of an investment
Microsoft Excel Reference Page
https://support.office.com/en-us/article/RRI-function-6f5822d8-7ef1-4233-944c-79e8172930f4
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.
