• esProc
Tutorial
Function Reference
Code Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

Firr()

Description

The function equals the Excel IRR function.

Syntax

Firr(values,guess)

Note

The external library function (See External Library Guide) calculates the internal rate of return for a series of cash flows represented by numeric values. The internal rate of return is the rate that makes the net present value from a particular investment equal to zero, that is, the current value of the returns received from the investment happens to be equal to the the investment cost.

Parameter

 values A sequence containing the values of a series of cash flows used to calculate the internal rate of return. It must contain at least one periodic payment (negative value) and at least one periodic income (positive value) guess An estimated value for IRR function’s calculation. If omitted, it will take on the default value of 0.1

Example

 Firr([-70000,12000,15000,18000,21000]) -0.0212448 Firr([-70000,12000,15000,18000,21000,26000]) 0.0866309 Firr([-70000,12000,15000,18000,21000,26000],-0.1) 0.0866309