OFFICE 97 XLS FUNXTION GIVES ERROR IF IRR IS ASKED FOR MORE THAN 10 VASH FLOW VALUES. How to over come this?

Question

i need to calculate IRR for over 1000 cash flow values over a period of 3 years with a value for each day

Answer 1

IRR is an iterative calculation. Try setting it up to do the calculations manually. If your intervals are not equal or your cash flows are not equal, which sounds likely, your problem will be more difficult, but not impossible. since Excel will not allow circular references you will have to keep entering your estimates manually, but you can set up cells to give the new estimate using functions YOU decide you need for error correction, and not the generalized one the IRR function uses which creates the fatal error.

Answer 2

Well, I tried a calc with over 1000 values in Excel 97 and it did not have a problem. This is using a range as input, not individual values. I assume you are doing the same.

Perhaps no IRR is calculable from your data. Do you have both positive and negative values included? If not, the IRR would be undefined. If you do have both positive and negative values, try changing your initial "guess" argument (the second argument) as Excel might have trouble resolving the answer in some cases.

Answer 3

You sound smart. Mathematics ain't my thing. If it is possible I would buy a new calculator and charge it to the company you're doing the cash flow values for. Unless you're self-employed!LoL! All the best wif getting a good answer.

Answer 4

try to dump the memory