IRR & #DIV0!
HI,
I've got a series of numbers in a row from which I need to know the IRR. Because the first number is positive the function is returning the #DIV0 error. Can anyone tell me how to get round this? Thanks David |
IRR & #DIV0!
Correct me if i'm wrong but it is suppsed to always be negative right? If
that is the case and you are just wanting positives to turn to negatives throw this in =IF(A10,A1*-1,A1) -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "David" wrote: HI, I've got a series of numbers in a row from which I need to know the IRR. Because the first number is positive the function is returning the #DIV0 error. Can anyone tell me how to get round this? Thanks David |
IRR & #DIV0!
John,
Normally I'd agree but I work for a University and it's never that simple! The plan is expected to produce more students, therefore more cash, before the new building is complete. Hence the positive figure in year 0. Any way around this? "John Bundy" wrote: Correct me if i'm wrong but it is suppsed to always be negative right? If that is the case and you are just wanting positives to turn to negatives throw this in =IF(A10,A1*-1,A1) -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "David" wrote: HI, I've got a series of numbers in a row from which I need to know the IRR. Because the first number is positive the function is returning the #DIV0 error. Can anyone tell me how to get round this? Thanks David |
IRR & #DIV0!
hmm, not sure, reading tells me for IRR you have to have a negative but try
here for possible solutions http://www.exceluser.com/solutions/irr.htm http://exceltips.vitalnews.com/Pages..._Function.html -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "David" wrote: John, Normally I'd agree but I work for a University and it's never that simple! The plan is expected to produce more students, therefore more cash, before the new building is complete. Hence the positive figure in year 0. Any way around this? "John Bundy" wrote: Correct me if i'm wrong but it is suppsed to always be negative right? If that is the case and you are just wanting positives to turn to negatives throw this in =IF(A10,A1*-1,A1) -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "David" wrote: HI, I've got a series of numbers in a row from which I need to know the IRR. Because the first number is positive the function is returning the #DIV0 error. Can anyone tell me how to get round this? Thanks David |
IRR & #DIV0!
David wrote:
I've got a series of numbers in a row from which I need to know the IRR. Because the first number is positive the function is returning the #DIV0 error. IRR() requires that __some__ cash flows be negative and positive, but it does __not__ require that the first cash flow be negative. For example, IRR({2000,-10000,4000,5000}) works just fine (in Office Excel 2003). In my experience, the #DIV/0! error usually has the same meaning as the #NUM! error, namely: the IRR() algorithm hit a divide-by-zero condition before it (would have) exhausted the iteration limit of 20(!). The remedy might be to pick a good "guess", the 2nd IRR() parameter. However, that does not always work, either. For example, IRR({-2000,10000,4000,5000}) produces 445.10%, but IRR({10000,-2000,4000,5000},guess) refuses to provide a solution, even when I provide it (-158.34%!) in the "guess" parameter. (I determined the solution manually by using the sum of the PV's and trial rates.) |
All times are GMT +1. The time now is 08:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com