Excel Function : IRR
Category
Financial
Description
Returns the internal rate of return for a series of cash flows
Microsoft Excel Reference Page
https://support.office.com/en-us/article/IRR-function-64925eaa-9988-495b-b290-3ad0c163c1bc
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).
