Hi,
Need an assistance in using UltraCalcFunctionIRR class to calculates an internal rate of return for a given series of cash flow . Can some one share sample code for the same?
Regards,
RK
Hi RK,
Which part of this is giving you trouble? If you are asking about how to calculate an IRR, then I will be no help, as I am totally clueless about financial calcuations.
But if you just need to know how to plug values into a formula, then which function you are using really doesn't matter all that much. It's just a question of passing in the appropriate references to the function. And there are lots of samples of this included with NetAdvantage under the UltraCalcManager samples.
Hi Mike,
In excel say if we put below values and calculate IRR it gives the value of 7%.
-25
-10
0
10
35
=IRR(A1:A5) returns 7% as result
By using UltraCalcFunctionIRR how can I achieve the same?
I looked at the sample and I did see the samples of using Infragistics.Win.CalcEngine.UltraCalcFunction but none of the samples talk about using Infragistics.Win.CalcEngine.UltraCalcFunctionIRR.
Can you send me a sample of code which will use the IRR method which will take the above values and return me 7% value as shown above.