how is irr calculated?
 IRR is calculated through an iterative search procedure that starts with an estimate for IRR, specified as a guess and then repeatedly varies that value until a correct IRR is reached. Specifying a guess argument is optional; Excel uses 10% as the default value. 