HP 17bii+: Financial Management Rate of Return (FMRR) Question



#9

Has anyone successfully entered equation, validated equation and validated answer for the FMMR using an hp 17bii+?

I have all but validated an answer, the solver seems to diverge with its guesses.

Any information is greatly appreciated and thank you all in advance.

-e


#10

Did you look here already?

http://www.hpmuseum.org/cgi-sys/cgiwrap/hpmuseum/archv007.cgi?read=12909

Best regards


#11

Sure did. The equation is entered and is validated but it diverges hopelessly. I take it that nobody else uses the equation. Thank you for your time.


#12

Ok.

So here is another equation:

http://www.palmtoppaper.com/ptphtml/18/pt18002b.htm

It also may be, that you ran into the famous L(), G() bugs ...

Try to initialize like described here:

http://www.hpmuseum.org/cgi-sys/cgiwrap/hpmuseum/archv015.cgi?read=73090#73090

Best regards

PS: Give Ed Keefe's other articles a look too, e.g.:

http://www.palmtoppaper.com/ptphtml/7/ptp7005c.htm

#13

Something I forgot to ask:

Did you use "guesses" for the expected FMRR - like:

0 FMRR 100 FMRR FMRR

Best regards
Peter A. Gebhardt


#14

Peter-

Hey, thanks for your help!!! I got it!!! I needed to set all registers to zero, i.e., including S, R, T, and I. I should have remembered to check for that - your last suggestion reminded me to do that (I so far away from programming since I was younger). Again, thank you for taking the time, I greatly appreciate it!

See code below for tweak that works for me:

FMRR%:

L(N:L(F:L(M:L(W:L(MP:L(MF:L(S:L(R:L(T:L(I:0))))))))))_mult_

( IF(P/YR=0: L(P/YR: 1 ) : 0 )+

L(I: G(IRR%)_div_P/YR )+

L(S: SAF%_div_P/YR )+

L(R: RSK%_div_P/YR )+

_sum_( G: SIZEC($): 1: -1: L(C: FLOW($:G) )+ L(T: #T($:G) )+ L(X: G(M)_mult_SPPV(G(S):G(T))+ G(C)_mult_USPV(G(S):G(T)) )+ L(MP: G(MP)_mult_SPPV(G(S):G(T)) )+

IF(G(C)<=0: L(MP: G(MP)+ G(C)_mult_(G(S):G(T)) )+ L(M: G(X) ) : L(MF: G(MF)+ SPFV(G(R):G(N))_mult_ G(C)_mult_USFV(G(R):G(T)) )+ IF(G(M)+G(C)>0: L(W: G(W)+ SPFV(G(R):G(N))_mult_ ( G(M)+ G(C)_mult_USFV(G(R):G(T)) ) )+ L(M: G(X) ) : IF(G(X)<=0: L(M: G(X) ) : L(P: IP( LN( -G(M)_mult_G(S)_div_100_div_G(C)+1 )_div_ LN( 1+G(S)_div_100 ) ) )+ L(W: G(W)+ SPFV(G(R):G(N)+G(P))_mult_ ( G(C)_mult_USFV(G(R):G(T)-G(P))+ G(M)_mult_SPPV(G(S):G(P))+ G(C)_mult_USPV(G(S):G(P)) ) )+ L(M: 0 ) ) ) )+ L(F: G(F)+ G(C)_mult_ USFV(G(I):G(T))_mult_ SPFV(G(I):G(N)) )+ L(N: G(N)+G(T) ) ) )+

IF(S($IN): $IN-G(M)-FLOW($:0) : IF(S($OUT) OR S(P/YR): $OUT-G(W) : IF(S(FMR%) OR S(SAF%) OR S(RSK%): (G(M)+FLOW($:0))_mult_ SPFV(FMR%_div_P/YR:G(N))+ G(W)+ 0_mult_(SAF%+RSK%) : IF(S(MIR%): FLOW($:0)+ G(MP)+ G(MF)_mult_SPPV(MIR%_div_P/YR:G(N)) : FLOW($:0)_mult_ SPFV(IRR%_div_P/YR:G(N))+ G(F) ) ) ) )


#15

Thanks in return, for posting your finally working solution!

I second your emotions conc. programming - 30 years ago I also would have been happy to concentrate much of my spare time to find solutions for critical problems. Nowadays I have to provide solutions to my customers FAST and I'm very happy not only to contribute (albeit rarely) but also to rely on the help of this fine community.

Have a nice weekend!

Peter A. Gebhardt


Edited: 5 Sept 2006, 2:07 p.m.

#16

In response to your question about the guesses, I used the same source as you, i.e., [link:http://www.palmtoppaper.com/ptphtml/18/pt18002a.htm]
It seems to be the second page to the one you quoted.

-e


Possibly Related Threads...
Thread Author Replies Views Last Post
  Solver issue with HP 17BII - different from 19BII Jeff Kearns 13 3,309 11-28-2013, 02:36 AM
Last Post: Don Shepherd
  17BII & 17BII+ Discounted Payback Period Revisited Tom Neudorfl 8 2,032 11-25-2013, 10:28 AM
Last Post: Don Shepherd
  HP Prime - GETPIX_P Return? Thomas Chrapkiewicz 7 1,745 11-25-2013, 08:54 AM
Last Post: Thomas Chrapkiewicz
  10bii Financial Calculator is on launch sale - 0.99$ only John 4 1,528 11-10-2013, 08:02 PM
Last Post: BShoring
  HP PRIME: Hide return value from program and swap Edit with Run vrrr 2 1,073 11-09-2013, 04:04 PM
Last Post: vrrr
  HP Prime Programming Tutorial #1: LOCAL, RETURN Eddie W. Shore 6 2,190 10-26-2013, 08:42 PM
Last Post: Miguel Toro
  Is the Prime a superset of the HP 17bII+ ? vrrr 3 1,244 10-16-2013, 12:03 PM
Last Post: Michael de Estrada
  hp 17bii+ dates calculation... JoePaul 6 1,783 07-14-2013, 11:32 AM
Last Post: Katie Wasserman
  HP-17bII+ emulator problem (TW?) fhub 7 1,773 06-23-2013, 09:57 AM
Last Post: Olivier De Smet
  HP-17bII+ Solve Compatibility Issues Robert Prosperi 7 2,097 04-22-2013, 10:11 PM
Last Post: Gerson W. Barbosa

Forum Jump: