RRI

Interetest rate needed to reach specific investment value

Description

Given a number of periods and target value, calculates the interest rate an investment needs to reach that value.

Function signature

RRI(periods: Number, presentvalue: Number, futurevalue: Number) => Number

Parameter

Description

Periods

The number of periods.

Present value

The present value of the investment

Future value

The future value of the investment.

Examples

Formula

Return value

RRI(0.1, 10, 20)

1023

RRI(1, 10, 20)

1

RRI(1, 10, 30)

2

RRI(1, 20, 20)

0

RRI(-1, 10, 20)

-0.5