XMIrr

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. 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.

See Also

• MIrr, Irr
• XIrr, XNpv, Npv
• Internal Rate of Return (IRR) and Modified Internal Rate of Return (MIRR) Webinar recording