Difference between revisions of "Documentation/How Tos/Calc: RRI function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
m
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE: RRI function}}
 +
{{Documentation/CalcFunc FinancialTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_RATE_function
 +
|NextPage=Documentation/How_Tos/Calc:_XIRR_function
 +
}}__NOTOC__
  
 
== RRI ==
 
== RRI ==
Line 22: Line 27:
 
* <tt>'''numperiods'''</tt> may be entered as a fractional number, but in this case the result may be slightly inaccurate, as the fractional period will calculate as if partially compounded.
 
* <tt>'''numperiods'''</tt> may be entered as a fractional number, but in this case the result may be slightly inaccurate, as the fractional period will calculate as if partially compounded.
  
−
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: RATE function|RATE]]
 
* [[Documentation/How_Tos/Calc: RATE function|RATE]]
 
* [[Documentation/How_Tos/Calc: IRR function|IRR]]
 
* [[Documentation/How_Tos/Calc: IRR function|IRR]]
Line 30: Line 35:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
−
[[Category: Documentation/Reference/Calc]]
+
[[Category: Documentation/Reference/Calc/Financial functions]]

Latest revision as of 16:03, 30 January 2024

RRI

Returns an equivalent interest rate when an investment increases in value.

Syntax:

RRI(numperiods; presentvalue; futurevalue)

numperiods: the number of periods in the term.
presentvalue: the value at the start of the term.
futurevalue: the value at the end of the term.
RRI calculates the fixed interest rate needed, so that presentvalue invested for numperiods (and compounded each period) is worth futurevalue at the end of the term. RRI returns a fixed interest rate which applies to each period.
The underlying equation is:
presentvalue * (1 + RRI)numperiods = futurevalue.

Example:

RRI(8; 1000; 1600)

returns approximately 6.05%. You invest $1,000, and receive $1,600 after 8 years. If you had instead invested that sum in a fixed rate interest account, with annually compounding interest, the account would have needed to pay 6.05% to gain the same value.

Issues:

  • numperiods may be entered as a fractional number, but in this case the result may be slightly inaccurate, as the fractional period will calculate as if partially compounded.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_RRI_function&oldid=259750"
Views
Personal tools
Navigation
Tools
In other languages