CAS 6


irrcf
- Financial

Summary

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

Examples

STATE in 'NY,CT,NJ'
LOANID in '1000032'
ORIGTERM in 180 460
not PROPTYPE in 'C,CLR,CHR,PUD,DPUD'

Syntax

(Freq|Guess) irrcf Flows

Left Arguments

Name Data Type Input Type Description Optional Default
Freq Numeric Field, Constant Frequency Yes 12
Guess Numeric Field, Constant Guess (in percent) Yes 10

Right Arguments

Name Data Type Input Type Description Optional Default
Flows Numeric Field Cash Flow No

Result

Type: Numeric

Rate of return; -999999999 if no solution



Build 6.0.624