XIRR Formula
[Tex]XIRR=\frac{NPV(Cash Flows,r)}{Initial~Investment}\times{100}[/Tex]
In the formula,
NPV = Net Present Value of the Cash Flows
R = Applicable Interest Rate
Initial Investment = Invested Amount
Cash Flows = Amounts Invested and Withdrawn Over the Tenure of the Investment