The XIRR function calculates the internal rate of return for series of cash flows that occur at irregular intervals. To calculate the internal rate of return for a series of regular, periodic cash flows, use the IRR function.
Payments are expressed as negative values and income as positive values. If the first value is a cost or payment, it must be a negative value. Subsequent payments are discounted based on a 365-day year.
Excel uses iteration to arrive at a result, starting with the guess (if provided) or with .1 (10%) if not. If an accurate rate can't be calculated after a fixed number of iterations, the #NUM error is returned.
The values array must contain at least one positive value and one negative value.
Dates must be valid Excel dates that correspond to values
The Excel PV function is a financial function that returns the present value of an investment. You can use the PV function to get the value in today's dollars of a series of future payments, assuming periodic, constant payments and a constant...
The Excel MIRR function is a financial function that returns the modified internal rate of return (MIRR) for a series of cash flows, taking into account both discount rate and reinvestment rate for future cash flows.