• esProc
Tutorial
Function Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL Command Executor 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 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