Difference between revisions of "XMIrr"

Latest revision as of 22:40, 1 February 2016

XMIrr(values, dates, I, financeRate, reinvestRate)

Compute the modified internal rate of return for a series of cash flows, «values», occurring at relative points in time. The rate of return is relative to the first date in the series. Both «values» and «dates» must be indexed by «I», and contain each cash flow amount and the date at which the corresponding case flow occurs respectively.

The «financeRate» is the interest rate at which money is borrowed to finance the negative cash flow values, and «refinanceRate» is the interest rate obtained through the largest date in «dates» after positive cash flows are realized. All dates are expressed as the number of days since Analytica's date origin. Both interest rates are based on a 365-day year.

History

Introduced in Analytica 4.2.

@@ Line 1: / Line 1: @@
 [[Category:Financial Functions]]
-= XMIrr(values,dates,I,financeRate,reinvestRate) =
+== XMIrr(values, dates, I, financeRate, reinvestRate) ==
-''requires Analytica 4.2 or later''
+Compute the ''modified internal rate of return'' for a series of cash flows, «values», occurring at relative points in time.  The rate of return is relative to the first date in the series.  Both «values» and «dates» must be indexed by «I», and contain each cash flow amount and the date at which the corresponding case flow occurs respectively.
-Compute the ''modified internal rate of return'' for a series of cash flows, ''«values»'', occurring at relative points in time.  The rate of return is relative to the first date in the series.  Both «values» and «dates» must be indexed by I, and contain each cash flow amount and the date at which the corresponding case flow occurs respectively.  The «financeRate» is the interest rate at which money is borrowed to finance the negative cash flow values, and «refinanceRate» is the interest rate obtained through the largest date in «dates» after positive cash flows are realized.  All dates are expressed as the number of days since Analytica's date origin.  Both interest rates are based on a 365-day year.
+The «financeRate» is the interest rate at which money is borrowed to finance the negative cash flow values, and «refinanceRate» is the interest rate obtained through the largest date in «dates» after positive cash flows are realized.  All dates are expressed as the number of days since Analytica's date origin.  Both interest rates are based on a 365-day year.
-= Examples =
+==History==
+Introduced in [[Analytica 4.2]].
-= See Also =
+== See Also ==
+* [[MIrr]]
-* [[MIrr]], [[Irr]]
+* [[Irr]]
-* [[XIrr]], [[XNpv]], [[Npv]]
+* [[XIrr]]
+* [[XNpv]]
+* [[Npv]]
 * [[Analytica_User_Group/Past_Topics#Internal_Rate_of_Return_.28IRR.29_and_Modified_Internal_Rate_of_Return_.28MIRR.29|Internal Rate of Return (IRR) and Modified Internal Rate of Return (MIRR)]] Webinar recording
+* [[Financial functions]]