php 计算xirr

 

//计算xirr方法

function getXirr($cashflows){
    if(empty($cashflows)) return 0;
    $years=[];
    $first_time=strtotime($cashflows[0]['stringTime']);

    foreach ($cashflows as $v){
        $years[]=(strtotime($v['stringTime'])-$first_time)/86400/365;
    }
    $residual = 1.0;
    $step = 0.05;
    $guess = 0.05;
    $epsilon = 0.0001;
    $limit = 10000;
    $count=0;
    while (abs($residual)>$epsilon&&$limit > 0){
        $limit--;
        $residual=0.0;
        foreach ($cashflows as $i=>$trans){
            ((float)pow($guess, $years[$i])==0)?:$residual += $trans['payment'] / pow($guess, $years[$i]);
        }
        if(abs($residual)>$epsilon){
            if($residual>0){
                $guess+=$step;
            }else{
                $guess-=$step;
                $step/=2.0;
            }