XMIrr

Revision as of 22:40, 1 February 2016 by Bbecane (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


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.

See Also

Comments


You are not allowed to post comments.