Excel Function : XIRR
Category
Financial
Description
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
Microsoft Excel Reference Page
https://support.office.com/en-us/article/XIRR-function-de1242ec-6477-445b-b11b-a303ad9adc9d
Syntax and Description of the XIRR Excel Function
The syntax for the XIRR function in Microsoft Excel is: XIRR(values, dates, [guess]) Values is a required array or reference to the cells that contain the numbers for which you want to calculate the internal rate of return. Dates is a required array or reference to the cells that contain the date or time values for which the corresponding values are paid. Guess is an optional number that you guess is close to the result of XIRR.
About XIRR Excel Function
XIRR is an Excel function that returns the internal rate of return for a given investment. The internal rate of return is the interest rate that makes the present value of the investment's cash flows equal to the investment's initial cost.
