Thanks Juan, for providing me routine for calculating IRR, but when I run these function , it gives me domain error. What wrong I am doing ? For your convinience I am providing U parameter i.e. initial Amt is - 100000 , Case start Date is 04/05/98, Monthly Amt is 5000 and case period is 24 months . Please go thru it and tell me about my mistake . Please excuse my english.

Thanks