Difference between revisions of "Documentation/How Tos/Calc: MIRR function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 19: | Line 19: | ||
: 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>. | ||
− | + | {{Documentation/SeeAlso| | |
− | [[Documentation/How_Tos/Calc: IRR function| | + | * [[Documentation/How_Tos/Calc: IRR function|IRR]], |
− | [[Documentation/How_Tos/Calc: NPV function| | + | * [[Documentation/How_Tos/Calc: NPV function|NPV]], |
− | [[Documentation/How_Tos/Calc: XIRR function| | + | * [[Documentation/How_Tos/Calc: XIRR function|XIRR]], |
− | [[Documentation/How_Tos/Calc: XNPV function| | + | * [[Documentation/How_Tos/Calc: XNPV function|XNPV]] |
− | [[Documentation/How_Tos/Calc: Financial functions| | + | * [[Documentation/How_Tos/Calc: Financial functions|Financial functions]] |
− | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
− | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
=== Issues: === | === Issues: === | ||
* This function does not currently accept arrays. | * This function does not currently accept arrays. |
Revision as of 14:05, 25 February 2009
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%.
Template:Documentation/SeeAlso
Issues:
- This function does not currently accept arrays.