CAS 6


xirr
- Financial

Summary

Calculate the internal rate of return of a series of cash flows with dates

Examples

 20080101 20080301 20081030 20090215 20090401
(-10000) 2750 4250 3250 2750 
xirr CF DATES 

Syntax

(Guess) xirr CashFlows Dates

Left Arguments

Name Data Type Input Type Description Optional Default
Guess Numeric Field, Constant Guess Yes

Right Arguments

Name Data Type Input Type Description Optional Default
Dates Numeric Field Frequency No
CashFlows Numeric Field Cash Flows No

Result

Type: Numeric

Rate of return



Build 6.0.624