Documentation/Calc Functions/RRI

Function name:
RRI

Category:
Financial Analysis

Summary:
Calculates the interest rate resulting from the profit (return) of an investment.

Syntax:
RRI(P; PV; FV)

Returns:
Returns a positive real number (expressed as a percentage) which is an equivalent interest rate when an investment,PV, increases in value to FV in P number of periods.

Arguments:
P is a positive real number or a reference to the cell containing that number which is the number of periods needed for calculating the interest rate.

PV is a real number or a reference to the cell containing that number which is the present (current) value. The cash value is the deposit of cash or the current cash value of an allowance in kind. As a deposit value, a positive value must be entered; the deposit must not be 0 or <0.

FV is a real number or a reference to the cell containing that number which determines what is desired as the cash value of the deposit.


 * If P is less than or equal to 0 then the function returns an error value.
 * If only one of PV or FV is a negative real number and then the function may return a numeric (#NUM!) error depending on the value of P being passed.

Additional details:

 * The formula for RRI is:

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/FV FV]

[[Special:MyLanguage/Documentation/Calc_Functions/NPER NPER]

[[Special:MyLanguage/Documentation/Calc_Functions/PMT PMT]

[[Special:MyLanguage/Documentation/Calc_Functions/PV PV]

[[Special:MyLanguage/Documentation/Calc_Functions/RATE RATE]

ODF standard:
Section 6.12.44, part 2

Equivalent Excel functions:
RRI