3.5.13.4 RRI

1 Description
2 Syntax
3 Parameters
4 Example
5 See Also

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.

the present value of the investment

the desired future value of the investment

Example

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

3.5.13.4 RRI

Contents

Description

Syntax

Parameters

Example

See Also