Based on the image above, the dynamic formula that finds the XIRR of the 6th period would be: (must use cell B1 to make formula dynamic) =XIRR(B4:OFFSET(B4,0,_____),B3:OFFSET(B3,0,_____)) and the output would be _____ %