Excel Function : IRR
Returns the internal rate of return for a series of cash flows
Microsoft Excel Reference Page
Syntax and Description of the IRR Excel Function
. The IRR function syntax in Excel is as follows: =IRR(values,guess) where: values - an array or a reference to cells that contain numbers for which you want to calculate the internal rate of return. guess - a number that you guess is close to the internal rate of return.
About IRR Excel Function
The IRR function in Excel calculates the internal rate of return for a series of cash flows. The cash flows can be either positive (a series of payments) or negative (a series of refunds).