20b IRR "ON [right-arrow] Stop" Error



#2

Hello,

I am trying to identify an error which I received on my 20b. I entered a non-conventional cash flow, with a single change of sign, and when IRR was pressed, I received the message: "ON [right-arrow] Stop." Interestingly, I've entered non-conventional cash flows (with sign changes) before and the 20b usually returns the first IRR. Does anyone know what this error message is as could not find it in my 20b manual. Thanks for your kind help!


#3

hello,

Quote:
I am trying to identify an error which I received on my 20b. I entered a non-conventional cash flow, with a single change of sign, and when IRR was pressed, I received the message: "ON [right-arrow] Stop."

Does anyone know what this error message is as could not find it in my 20b manual. Thanks for your kind help!


Yes, I know what that means :-)

the ON->STOP message appears each time you perform a 'long' iterative calculation such as a TVM I, BOND YTM, ICONV P/YR or IRR calculation and the algorithm loops more than 20 times.

since in most cases the algorythm will find the solution faster than that, you will not see this message. However, in some 'strange' cases, the algorythm will take a LONG time to find a solution if ever. The ON key can then be used to 'stop'/'cancel' the calculation. This error message (ON->STOP) is here in order to: 1 tell you that the algorythm is still looking for an answer and 2: remind you that you can cancel the calculation if no solution seems to be found.

now, I am interested in knowing what values you used for the cash flow in order to see if it's normal for the algorythm not to find a solution, or if there is something wrong with it.

regards, cyrille


#4

Thank you for your advice Cyrille. The values for cash flow I entered were:

CF(0) = -2,000

#CF(0) = 1

CF(1) = 6,000

#CF(1) = 1

CF(2) = -5,000

#CF(2) = 1

Edited: 26 Sept 2008, 2:43 p.m.


#5

Cinealta,

being curious about solving this on other calculators, I used my trusted 200LX (an HP19bII should work as well) and plotted the NPV to IRR plot with the numbers you supplied.

As already guessed - it never crosses the X-axis - so no IRR% solution is possible, because of the definition of IRR, "being the rate, which discounts all cashflows to an NPV of zero".

You should stay away from such "investments", which require you to anticipate such huge "scrap" outflows, compared to earlier inflows ;-))

- or use MIRR or FMRR (with addditional LIQUID- or RISK-rates) instead.

Which gives me a chance to kindly ask our always helpful HP Product Manager - Cyrille - to contemplate implementing MIRR/FMRR algorithms into a new incarnation of HP17/19 firmware if budget and resources allow.

Best regards

Peter A. Gebhardt


#6

Thank you for your advice Peter. Yes, I am sorry. It was a problem which my Finance professor assigned. I did not graph it to realize it does not cross X-axis, so no solution possible. Thanks again!

#7

hello,

Quote:
- or use MIRR or FMRR (with addditional LIQUID- or RISK-rates) instead.

Well, MIRR would not help as it requires a correct value for IRR to be used for the outflow cashs...

Quote:
Which gives me a chance to kindly ask our always helpful HP Product Manager - Cyrille - to contemplate implementing MIRR/FMRR algorithms into a new incarnation of HP17/19 firmware if budget and resources allow.

FMRR would work, but my understanding was that FMRR was not really used anymore... can you tell me more about it (after all, I am a scientist, not a business guy).

regards, cyrille


#8

Cyrille,

see your inbox.

Best regards

Peter A. Gebhardt


Possibly Related Threads...
Thread Author Replies Views Last Post
  Difficulties with IRR Program Jose Gonzalez Divasson 4 1,581 12-02-2013, 02:34 AM
Last Post: cyrille de Brébisson
  MS advert shows spreadsheet with obvious error BruceH 3 1,465 11-14-2013, 09:50 AM
Last Post: Bill (Smithville, NJ)
  HP Prime: Rounding error in determinant Stephan Matthys 3 1,092 10-25-2013, 09:29 PM
Last Post: Walter B
  Prime Error or Mine? toml_12953 12 2,420 10-22-2013, 10:35 AM
Last Post: toml_12953
  Explaination on How to Reset Caculator in Users guie: error Harold A Climer 5 1,644 10-15-2013, 02:11 AM
Last Post: cyrille de Brébisson
  Repair of HP-34C - Error 0 and Error 9 Jeff Kearns 3 1,164 10-11-2013, 12:29 PM
Last Post: Randy
  HP's thinking behind the 20b/30b? John Ioannidis 3 1,153 09-07-2013, 10:21 AM
Last Post: Tim Wessman
  Do You Think a Listing Error Was Made? Jim Johnson 13 2,668 09-04-2013, 09:23 AM
Last Post: Eddie W. Shore
  HP Prime: Error reports : Here Patrice 111 14,148 07-24-2013, 05:52 PM
Last Post: Thomas Klemm
  PARTFRAC error. Romeu Medeiros 2 939 06-23-2013, 10:27 PM
Last Post: Romeu Medeiros

Forum Jump: