Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. Range of cells containing the series of cash flows. Syntax for XIRR Function XIRRvalues dates guess Arguments.
Notice how the formula inputs appear.
Supply the dynamic defined names that youve created to the XIRR formula. Next in order to calculate XIRR you need to use below formula. Firstly type the formula of A1385 in Cell C1 and then drag the AutoFill Handle down to the bottom in Column C then the formula of A1385 is applied in the whole Column C. The internal rate of interest on these cash flows the investment amount is showing a minus sign.