My HP 10bII+ is much faster than HP 12c!

01062020, 08:18 PM
(This post was last modified: 01092020 04:06 AM by AndiGer.)
Post: #21




RE: My HP 10bII+ is much faster than HP 12c!
To see it is true I did it the other way round with HP67 standard pac card SD05 on Legendary 67 on iFon 4s. PV has to be set to 1,000 to get 50,000 with interest rate 3.652.
When I then calculate i it returns 3.6520 after a few seconds less than 2 minutes at DSP 4. 

01062020, 11:07 PM
Post: #22




RE: My HP 10bII+ is much faster than HP 12c!
On the Prime G2, if I uncheck “End” and make N=29, FV=49,000, P/Yr=1: I get I=3.64 Is this coincidental?
What is happening here? (If, in the above, I make N=30, FV=50,000, I get I=3.43 

01072020, 12:41 AM
Post: #23




RE: My HP 10bII+ is much faster than HP 12c!
(01062020 11:07 PM)lrdheat Wrote: On the Prime G2, if I uncheck “End” and make N=29, FV=49,000, P/Yr=1: I get I=3.64 Is this coincidental? With End Off, it is identical to End On, but with payments shifted up: PV ← PV + PMT FV ← FV − PMT Above is plain savings plan (with "End" On): N=29, PV=0, PMT=1000, FV=50000 → I=3.639% You can visualize it as original N=30 example, PV=1000 getting no interest, and got cancelled by first PMT. The error is tiny, but to correct for this, we can iterate again. PV gives up 1000 * 3.639% = 36.39 FV correction = 36.39 * 1.03639^{29} = 102.60 Rerun solver, with N=29, PV=0, PMT=1000, FV=50102.60 → I=3.652% 

01072020, 02:48 AM
Post: #24




RE: My HP 10bII+ is much faster than HP 12c!
(Prime G2) Makes sense. At the expense of showing what remains my misunderstanding, when I input an i=3.652 and solve for N, I get 30.00 (result rounded by FIX 2). Indeed, if I choose an arbitrary i, and solve for N, a result will come up that makes sense if one is fine with a non integer N. If, however, I enter a N that is identical to an N that appears in the command line when I choose “edit”, and solve for i, it throws the many or no solutions error. This is true for all values that I experimented with. What am I not seeing here?


01072020, 05:38 PM
Post: #25




RE: My HP 10bII+ is much faster than HP 12c!
From my Texas Instruments Financial Investment Anayst:
PMT = 1,000 FV = 50,000 PV = 1,000 N = 30 I/Y = 43.82 * BEST! SlideRule 

01072020, 06:13 PM
Post: #26




RE: My HP 10bII+ is much faster than HP 12c!
(01072020 02:48 AM)lrdheat Wrote: If, however, I enter a N that is identical to an N that appears in the command line when I choose “edit”, and solve for i, it throws the many or no solutions error. This is true for all values that I experimented with. What am I not seeing here? We have N+1 cash flows: PV , PMT × (N1) , FV+PMT If the cash flows has more than one sign changes, you may have multiple roots for rate, see post #19 Unlike my example, sometimes solved rates are close to each other. Example, for N=30, PV=6500, PMT=1000, FV=50000, we have I = 8.96% or 11.10% Does anyone knows what returns should be reported for above investments ? 

01072020, 08:25 PM
Post: #27




RE: My HP 10bII+ is much faster than HP 12c!
(01062020 01:04 AM)Albert Chan Wrote: My guess so many calculators failed this is because we have multiple solutions. Same thing for HP 17BII+: [FIN] [CFLO] [SHIFT] [CLR DATA] [YES] "FLOW(0)=?" 1000 "FLOW(1)=?" 1000 "#TIMES(1)=1" 29 "FLOW(2)=?" 49000 "#TIMES(2)=1" [EXIT] [CALC] 0 [STO] [IRR%] → 3.65197435259 100 [STO] [IRR%] → 99.9999952503 — Ian Abbott 

01072020, 09:04 PM
(This post was last modified: 01082020 06:21 PM by Gene.)
Post: #28




RE: My HP 10bII+ is much faster than HP 12c!
Good question, Albert. For your example:
Example, for N=30, PV=6500, PMT=1000, FV=50000, we have I = 8.96% or 11.10% Does anyone knows what returns should be reported for above investments ? Consider these results... the change of Net Present Value (NPV) as the interest rate being used to value the cash flows changes illustrates the problem. The NPV has two roots. Two interest rates make the Present value of the cash flows equal to the initial investment. To say it another way... there are two Internal Rates of Return (IRR). That happens... so what is a calculator to do? Which is correct? Both are. Many times, one IRR is more "meaningful" but that's a hard thing to put on a calculator algorithm to decide. Take a look at the two attachments: The npv.png picture is the table of NPV values for the above example with interest rates that go up by 0.5 points for each row... except I plugged in the two values for IRR that get the NPV essentially equal to zero. The npvgraph.png picture is a graph of that table of values and shows where the graph crosses the Xaxis two times, where the Yvalue (which is the NPV) is equal to zero. The equation has two roots, yet IRR seeks to return one. Choose wisely. :) Classical problem in cash flow analysis and a good reason to AVOID IRR and evaluate a series of cashflows at the firm's cost of capital using NPV. EDIT: My table of numbers may be off  I did that quickly in Excel so apologies. The ** principle ** and graph isn't that far off. So don't rely on the specific numbers in the attached image of values. Sorry! 

01082020, 11:59 AM
Post: #29




RE: My HP 10bII+ is much faster than HP 12c!
One other comment. This multiple root IRR problem happens ** whenever ** there is a series of cash flows with multiple sign changes.
+  + as in this case.  +  +  etc, etc. That is the initial sign something will be wrong with an IRR approach. NPV does not suffer this problem. It ** always ** gives the best answer when your cost of funds is known. 

01102020, 07:19 PM
Post: #30




RE: My HP 10bII+ is much faster than HP 12c!
(01062020 02:11 AM)SlideRule Wrote:(01062020 01:04 AM)Albert Chan Wrote: My guess so many calculators failed this is because we have multiple solutions. The same for my HP 17Bii, which by the way solves the TVM equation of the thread starter almost immediately as well. 

« Next Oldest  Next Newest »

User(s) browsing this thread: 1 Guest(s)