Workflow Finance Functions
Note
For a list of supported functions for Standard mode tools, go to the Standard mode Formula Tool documentation.
A finance function applies financial algorithms or mathematical calculations.
IRR
IRR(Value1, Value2): Calculates Internal Rate of Return, which is the interest rate at which the costs of the investment lead to the benefits of the investment. This means that all gains from the investment are inherent to the time value of money and that the investment has a zero net present value at this interest rate.
XIRR
XIRR(Value1, Date1, Value2, Date2): Calculates the Internal Rate of Return of an investment with dates.