Levered IRR Formula The internal rate of return (IRR) measures the percent yield received on an investment on an annualized basis. The formula to calculate the levered IRR in Excel is as follows. =XIRR(Levered Cash Flow, Corresponding Dates) The internal rate of return (IRR) is determined us...