RRI function
RRI(NumberOfPeriods, PresentValue, FutureValue)
RRI(NumberOfPeriods; PresentValue; FutureValue)
NumberOfPeriods
Number or { Number }
The number of periods in the term.
PresentValue
Number or { Number }
The value at the start of the term.
FutureValue
Number or { Number }
The value at the end of the term.
Returns
Number or { Number }
An interest rate.
Returns an equivalent interest rate when an investment increases in value.
Example
RRI(8, 1000,
1600)RRI(8; 1000;
1600)
Returns roughly 6.05%. Let's assume that you invest $1,000, and receive $1,600 after eight years. If you instead invested that sum in a fixed-rate interest account, with annually compounding interest, the account would have needed to pay roughly 6.05% to gain the same value.
Partly derived from the OpenOffice.org documentation, licensed
under the Apache License 2.0.