Skip to definition

Markets & returns Advanced

XIRR

In brief An annualized return using dated cash flows, with some cash-flow patterns having no usable or unique answer.

Also referred to as: money-weighted return · money weighted return · money-weighted rate of return · annualized internal rate of return · irregular cash-flow return

Full explanation

An annualized, money-weighted internal rate of return calculated from dated cash flows. It reflects both when money moves and how much moves. Some cash-flow patterns have no usable answer or more than one mathematical solution; the tool's stated acceptance rules matter.

For exampleA $100 outflow followed by a $110 inflow exactly 365 days later has a 10% XIRR when there are no other flows.

Common mistakeComparing an annualized short-period result directly with cumulative TWR or interpreting an unavailable or ambiguous solution as a zero return.

Put it into practice: Inspect dated portfolio cash flows →

Primary sources: Microsoft Excel: XIRR function, dated cash flows and 365-day discounting Litecoin.watch: Portfolio XIRR acceptance and data requirements

Definition checked:

Quick answers about XIRR

What does XIRR mean in Litecoin?
An annualized return using dated cash flows, with some cash-flow patterns having no usable or unique answer. An annualized, money-weighted internal rate of return calculated from dated cash flows. It reflects both when money moves and how much moves. Some cash-flow patterns have no usable answer or more than one mathematical solution; the tool's stated acceptance rules matter.
What is a common mistake with XIRR?
Comparing an annualized short-period result directly with cumulative TWR or interpreting an unavailable or ambiguous solution as a zero return.
How is XIRR applied in practice?
A $100 outflow followed by a $110 inflow exactly 365 days later has a 10% XIRR when there are no other flows. You can explore this hands-on with our Inspect dated portfolio cash flows.
Jarosław Wasiński
Editor-in-chief · Financial markets and Litecoin education

Editor-in-chief of Litecoin.watch and founder of MyBank.pl. His published work covers foreign exchange, financial education and Litecoin. On Litecoin.watch, his remit includes editorial direction, source transparency and the practical guides and research published by the site.

Background, selected work and editorial responsibility →

Founder of MyBank.pl Financial education and market analysis Named editorial responsibility