Calculating XIRR value using XIRR Formula XIRR H3. Values a series of cash flows with corresponding dates for schedule of payments. The formula to use will be.
The XIRR formula in Excel takes one more argument when compared to the basic IRR formula above and thats of the range of dates.
Notice how the formula inputs appear. Negative values indicate payments while positive values indicate income. The first value of the cash flow or payment must be a negative value. The Excel PV function is a financial function that returns the present value of an investment.