RRI

Description

Minimum Origin Version Required: 2019 SR0

This function is used to calculate an equivalent interest rate for the growth of an investment, given the number of periods for the investment nper, the present value Pv and the future value of the investment Fv.

$RRI = \frac{{f{v^{\left( {1/nper} \right)}}}}{{pv}} - 1\$

Syntax

double RRI( double nper, double pv, double fv)

Parameters

nper

the number of periods for the investment.

pv

the present value of the investment

fv

the desired future value of the investment

Example

RRI(16.42,1000,1500)= // returns the rate 0.025