HP Forum Archive 16

[ Return to Index | Top of Index ]

HP 17bii+: Financial Management Rate of Return (FMRR) Question Message #1 Posted by e on 23 Aug 2006, 8:53 p.m. 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

Re: HP 17bii+: Financial Management Rate of Return (FMRR) Question Message #2 Posted by Peter A. Gebhardt on 24 Aug 2006, 2:39 p.m., in response to message #1 by e Did you look here already? http://www.hpmuseum.org/cgi-sys/cgiwrap/hpmuseum/archv007.cgi?read=12909 Best regards

Re: HP 17bii+: Financial Management Rate of Return (FMRR) Question Message #3 Posted by e on 27 Aug 2006, 1:02 p.m., in response to message #2 by Peter A. Gebhardt 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.

Re: HP 17bii+: Financial Management Rate of Return (FMRR) Question Message #4 Posted by Peter A. Gebhardt on 27 Aug 2006, 6:09 p.m., in response to message #3 by e 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

Re: HP 17bii+: Financial Management Rate of Return (FMRR) Question Message #5 Posted by Peter A. Gebhardt on 28 Aug 2006, 3:58 a.m., in response to message #3 by e Something I forgot to ask: Did you use "guesses" for the expected FMRR - like: 0 FMRR 100 FMRR FMRR Best regards Peter A. Gebhardt

Re: HP 17bii+: Financial Management Rate of Return (FMRR) Question Message #6 Posted by e on 1 Sept 2006, 5:39 p.m., in response to message #5 by Peter A. Gebhardt 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) ) ) ) )

Re: HP 17bii+: Financial Management Rate of Return (FMRR) Question Message #7 Posted by Peter A. Gebhardt on 2 Sept 2006, 4:33 a.m., in response to message #6 by e 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.

Re: HP 17bii+: Financial Management Rate of Return (FMRR) Question Message #8 Posted by e on 1 Sept 2006, 5:47 p.m., in response to message #5 by Peter A. Gebhardt 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

[ Return to Index | Top of Index ]

Go back to the main exhibit hall