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

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎See also:)
m
 
(8 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE: MIRR function}}
 +
{{Documentation/CalcFunc FinancialTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_ISPMT_function
 +
|NextPage=Documentation/How_Tos/Calc:_NPER_function
 +
}}__NOTOC__
  
 
== MIRR ==
 
== MIRR ==
Line 19: Line 24:
 
: where A1:A4 contain -5000, 1000, 2000, 3000, returns approximately <tt>'''8.16%'''</tt>.
 
: where A1:A4 contain -5000, 1000, 2000, 3000, returns approximately <tt>'''8.16%'''</tt>.
  
−
=== See also: ===
+
=== Issues: ===
−
[[Documentation/How_Tos/Calc: IRR function|'''IRR''']],
+
* This function does not currently accept arrays.
−
[[Documentation/How_Tos/Calc: NPV function|'''NPV''']],
+
−
[[Documentation/How_Tos/Calc: XIRR function|'''XIRR''']],
+
−
[[Documentation/How_Tos/Calc: XNPV function|'''XNPV''']]
+
  
−
[[Documentation/How_Tos/Calc: Financial functions|'''Financial functions''']]
+
{{SeeAlso|EN|
 +
* [[Documentation/How_Tos/Calc: IRR function|IRR]]
 +
* [[Documentation/How_Tos/Calc: NPV function|NPV]]
 +
* [[Documentation/How_Tos/Calc: XIRR function|XIRR]]
 +
* [[Documentation/How_Tos/Calc: XNPV function|XNPV]]
  
−
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
+
* [[Documentation/How_Tos/Calc: Financial functions|Financial functions]]
−
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
+
  
−
=== Issues: ===
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
−
* This function does not currently accept arrays.
+
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Financial functions]]

Latest revision as of 15:56, 30 January 2024

MIRR

Returns the modified internal rate of return of a series of cash flows.

Syntax:

MIRR(payments; financerate; reinvestrate)

payment is a range containing the payments made or received, at regular intervals.
financerate is the rate of interest you pay per period on outstanding balances.
reinvestrate is the rate of interest you receive per period on invested balances.
At least one of the payments must be negative and at least one positive. The payments are assumed to arise at the start of each period; the order in which the payments are given is important.
MIRR finds the modified internal rate of return from the formula:
(1 + MIRR)n-1 = final_value_of_positive_payments/initial_value_of_negative_payments.

Example:

MIRR(A1:A4; 5%; 8%)

where A1:A4 contain -5000, 1000, 2000, 3000, returns approximately 8.16%.

Issues:

  • This function does not currently accept arrays.


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