Documentation/Calc Functions/RRI

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


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:

Arguments:

P is the number of periods needed for calculating the interest rate.

PV 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 determines what is desired as the cash value of the deposit.

Additional details:

Examples:

For four periods (years) and a cash value of 7,500 currency units, the interest rate of the return is to be calculated if the future value is 10,000 currency units.

=RRI(4;7500;10000) = 7.46 %

The interest rate must be 7.46 % so that 7,500 currency units will become 10,000 currency units.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: