Cash Flow Analysis for the HP 35s « Next Oldest | Next Newest »

 ▼ Miguel Toro Member Posts: 239 Threads: 55 Joined: Sep 2006 08-26-2007, 03:26 PM This has been a great learning experience. With this program you can make Net Present Value and internal rate of return analysis and it is very simple to use. I made a lot of learning of how the HP 35s solver works and I'll talk about that in an article I am preparing for Datafile. Of course I was able to develop it thanks to these two great features of the calculator: vectors and indirect addressing. The program is based on the NPV formula found in the "HP 15c advance functions handbook". IRR analysis takes a little time but I think is quite acceptable. With this one and the TVM already published, we have already a little financial pack for our HP 35s. :-) Please test it and give me your comments. Regards, Miguel ```Comments: XEQ C -> enter CASH FLOWS XEQ C024 -> Calculate NPV XEQ C030 -> Calculate IRR XEQ R052 -> Change values of a cash flow already entered XEQ R068 -> Review the cash flows already entered. The routine is circular. R001 -> IRR routine R042 -> convert content of x,y stack registers into a vector [y,x] R049 -> extract content of a vector [y,x] into registers x,y - To finish entering cash flows enter 0 and them R/S. - Interest is always by period, so if for exemple, you have monthly cash flows and a annual interest rate, divide this by 12 to enter the monthly rate. - You can enter any number of cash flow: the limit is the memory available. - You can change or correct any of the cash flows entered with routine R052. - To enter a cash flow: write the amount, press ENTER, write the number of occurences and press R/S. Program: C001 LBL C C002 SF 10 C003 (EQN) AMOUNT,OCCUR C004 PSE C005 CF 10 C006 STO J C007 R/S C008 x=0? C009 GTO C015 C010 XEQ R042 C011 STO(J) C012 1 C013 RCL+ J C014 GTO C006 C015 RCL J C016 x>0? C017 GTO C020 C018 CLSTK C019 RTN C020 1 C021 - C022 STO T C023 RTN C024 INPUT I C025 100 C026 / C027 STO B C028 XEQ R001 C029 RTN C030 0 C031 STO N C032 1E-3 C033 STO B C034 FN= R C035 SOLVE B C036 GTO C038 C037 GTO C043 C038 100 C039 * C040 STO I C041 VIEW I C042 RTN C043 SF 10 C044 (EQN) NO SOLUTION C045 CF 10 C046 RTN LN= 174 R001 LBL R R002 RCL B R003 1 R004 STO D R005 + R006 STO C R007 0 R008 STO E R009 STO J R010 RCL T R011 xy R021 +/- R022 y^x R023 STO D R024 1 R025 x<>y R026 - R027 RCL/ B R028 RCL* C R029 GTO R031 R030 RDN R031 * R032 STO+ E R033 RCL D R034 STO* C R035 1 RO36 STO+ J R037 RCL J R038 GTO R010 RO39 RCL E R040 RCL-N RO41 RTN R042 [0,1] R043 * R044 x<>Y RO45 [1,0] R046 * R047 + RO48 RTN R049 [1,0] R050 x<>y R051 * R052 [0,1] R053 LASTx R054 * R055 RTN R056 SF 10 R057 (EQN) FLOW R058 PSE R059 R/S R060 STO J R061 (EQN) AMOUNT,OCCUR R062 PSE R063 R/S R064 XEQ R042 R065 STO(J) R066 CF 10 R067 RTN R068 1E-3 R069 RCL* T R070 STO J R071 CLSTK R072 RCL J R073 IP RO74 PSE R075 RCL (J) R076 XEQ R049 R077 R/S R078 ISG J R079 GTO R071 R080 GTO R068 LN= 285 ``` Edited: 27 Aug 2007, 12:27 p.m.

 Possibly Related Threads... Thread Author Replies Views Last Post Entering,Saving,and Analysis /Fitting X Y Data on the Prime Harold A Climer 6 1,133 10-26-2013, 01:54 PM Last Post: Tim Wessman HP85 Waveform Analysis inaki 1 507 04-23-2013, 01:20 PM Last Post: Paul Berger (Canada) Hp-41 structural analysis pac porting to hp49g+ giancarlo 7 1,109 05-14-2012, 04:14 PM Last Post: Luiz C. Vieira (Brazil) Statistical analysis galore Geir Isene 9 1,131 11-19-2010, 09:51 PM Last Post: Palmer O. Hanson, Jr. Direct current circuit analysis program ferroburak 3 627 11-10-2009, 10:46 AM Last Post: Vieira, Luiz C. (Brazil) HP35s 2-D frame analysis John Wasilewski 7 887 11-03-2007, 10:08 AM Last Post: Rodger Rosenbaum My analysis of Joel's HP35s' bug Valentin Albillo 5 767 10-16-2007, 06:16 PM Last Post: Valentin Albillo Cash Flow Analysis for the HP 35s *UPDATED* Miguel Toro 0 367 08-27-2007, 12:21 PM Last Post: Miguel Toro Cash for your trash? Palmer O. Hanson, Jr. 39 3,668 03-21-2007, 03:36 PM Last Post: Trent Moseley Graphing Calculator Help: Two-variable Analysis Amy J 7 892 01-25-2007, 10:11 AM Last Post: gene wright

Forum Jump: