XIRR is used to calculate the return on investments where there are multiple transactions (inflows and outflows) happening at different points in time.
How is it calculated?
Solves for Rate (r) where: Σ [ Cashflow_i / (1+r)^(d_i/365) ] = 0 Uses numerical methods (Newton-Raphson) to approximate the rate.
