Returns the internal rate of return for a series of periodic cash flows, considering both cost of investment and interest on reinvestment of cash.
Name | Type | Description |
arg1 | ApiRange | Is an array or a reference to cells that contain numbers that represent a series of payments (negative) and income (positive) at regular periods. |
arg2 | number | Is the interest rate you pay on the money used in the cash flows. |
arg3 | number | Is the interest rate you receive on the cash flows as you reinvest them. |