HP12c Present Value of \$1.. Inaccurate??? « Next Oldest | Next Newest »

 ▼ Edward Dixon Unregistered Posts: 6 Threads: 1 Joined: Nov 2013 11-12-2013, 03:04 AM Hello there forum users. I'm a real estate student in the uk and i'm having trouble with my 30th Anniversary HP12c. In particular I'm trying to calculate the present value of \$1 for 1.5 years, using 10% interest. On my calculator I use: n=1.5,fv=-1,i=10,pv=0.8658 Yet when I use the formula:((1/1+i)^n)or (1/1+0.10)^1.5 = 0.8668 The later figure is correct in my study materials, so I have to go with that figure. this difference is enough to send my final value out by several thousand \$\$ and I'm worried that I might get marked down in an upcoming exam. Can anyone offer any advice??? Many thanks Edward ▼ Edward Dixon Unregistered Posts: 6 Threads: 1 Joined: Nov 2013 11-12-2013, 03:53 AM I would also like to add that my HP 17bii correctly says 0.8668 So I guess it must be a setting on the 12c ▼ fhub Unregistered Posts: 1,216 Threads: 75 Joined: Jun 2011 11-12-2013, 11:01 AM Quote: I would also like to add that my HP 17bii correctly says 0.8668 So I guess it must be a setting on the 12c You 'guess'?? Well, it IS in fact a setting! Haven't you tried to switch to 'C' mode on the 12c with [STO][EEX]? In this mode you get exactly what you expect (0.8668) ... BTW, most financial calcs don't even have such a 'mixed compounding' mode, they always use (1+i)^n regardless of whether n is integer or fractional. Franz ▼ Edward Dixon Unregistered Posts: 6 Threads: 1 Joined: Nov 2013 11-12-2013, 11:32 AM Hi Franz, For some reason this post has only just appeared but was sent along with my original post. Everything fine now, thanks to your help :) fhub Unregistered Posts: 1,216 Threads: 75 Joined: Jun 2011 11-12-2013, 04:37 AM Well, both you and your 12c are right! ;-) 0.8668 is the correct result if you use the formula fv=pv*(1+i)^n which is the theoretical (mathematical) compounding. But usually for non-integer periods (like 1.5 years) banks are using mixed compounding: this method uses the above (exponential) formula only for the integer part of the period, and a linear compounding for fractional parts of the period, i.e. fv=pv*(1+i)^n1 * (1+n2*i) with n1=IP(n) and n2=FP(n). For your example this means fv=1/((1+0.10)^1*(1+0.5*0.10))=0.8658 which is the result of the 12c. So it seems you have set your 12c to 'mixed compounding'. BTW, in reality it's even more complicated if PV is not at the beginning of the year (or the interest period). In fact the full formula is fv=pv*(1+n1*i)*(1+i)^n2*(1+n3*i) where n1 and n3 are the fractional parts of the first and last year and n2 is the number of full years. Example: if you pay PV=1000 at 1st April 2000 and want it back exactly 10 years later (at 5% p.a.), then you get: FV=1000*(1+9/12*0.05)*(1+0.05)^9*(1+3/12*0.05) = 1629.62 If you want a really good TVM calculator which handles all these cases (and much more), then download TVM-Calc v16.0 from my website: ;-) http://fhub.jimdo.com/ Franz ▼ Edward Dixon Unregistered Posts: 6 Threads: 1 Joined: Nov 2013 11-12-2013, 05:29 AM Franz, Many thanks for your reply. When you say that I have my hp-12c set to mixed compounding, does this mean that I can set the 12c to mathematical compounding instead of mixed compounding? I've tried to play around with the compounding periods but I always send the PV figure way out. I'd love to purchase your calc. but I would need to take it into an exam, which is an impossibility with an app. Thankfully all my calculations are 'in-arrears' at the moment. I think that my head would explode if I had to do them 'in-advance'. Going back to the HP12c, I didn't remember seeing a compounding setting in the User Guide. Can anyone help?? I'm also a bit confused as to why the HP17bii uses a default theoretical compounding but the 12c doesn't. Many Thanks in advance Edward ▼ fhub Unregistered Posts: 1,216 Threads: 75 Joined: Jun 2011 11-12-2013, 05:37 AM Quote: does this mean that I can set the 12c to mathematical compounding instead of mixed compounding? Yes, I remember that I've read here anytime in the past that the HP-12c can be switched between those 2 different compounding method, but don't ask me how - I don't have a real 12c and I'm using the 12c emulator very seldom. Quote: I'd love to purchase your calc. Well, no need to purchase anything - all my programs are freeware! ;-) But you're right, it's a PC software, so if you aren't allowed to use a notebook then it won't help you in your exams. I hope any 12c user can tell you how to switch this setting for the compounding method ... Franz fhub Unregistered Posts: 1,216 Threads: 75 Joined: Jun 2011 11-12-2013, 06:00 AM Quote: Going back to the HP12c, I didn't remember seeing a compounding setting in the User Guide. Ok, I've now looked into the 12c user guide and found the following information (page 50ff): If the number of periods (n) is non-integer, then the fractional part is called 'odd-period' by HP, and usually the HP uses simple interest (what I called linear compounding) for such odd periods. But you can switch to compound interest (=exponential or mathematical compounding) by turning on a 'C' indicator, and this is done by [STO][EEX] (pressing it again toggles this 'C' mode). Try it ... Franz Edited: 12 Nov 2013, 6:02 a.m. ▼ Edward Dixon Unregistered Posts: 6 Threads: 1 Joined: Nov 2013 11-12-2013, 08:24 AM Franz, Thank you so much for your assistance over this problem. As you have probably guessed I'm not very mathematically minded so your help on my simple problem is much appreciated. From your excerpt of the User Guide I will place the HP12c into 'odd-period' mode when I've got a non-integer period calculation. For all other integer calculations I should leave it in in 'normal' mode. Many thanks once again. Edward ▼ fhub Unregistered Posts: 1,216 Threads: 75 Joined: Jun 2011 11-12-2013, 08:32 AM Quote: From your excerpt of the User Guide I will place the HP12c into 'odd-period' mode when I've got a non-integer period calculation. For all other integer calculations I should leave it in in 'normal' mode. Yes, for a non-integer 'n' you can choose the method with the 'C' indicator ({STO][EEX]), i.e. either calculating the odd period with linear interest (no 'C') or with compound interest ('C'). For integer 'n' this setting (i.e. 'C' ON or OFF) should have no influence, so you could just always use this 'C' mode (if you prefer the mathematical compounding as in your first example). Franz Edited: 12 Nov 2013, 8:33 a.m. Kimberly Thompson Unregistered Posts: 97 Threads: 1 Joined: Jun 2013 11-12-2013, 06:42 AM Edward from the HP web page... Link to Removing the "C" from the Display ... HP consumer support... Quote:Additional Explanation The C status indicator is used in Odd-Period calculations. When interest on a cash flow begins to accrue before the beginning of the first regular payment period, it is necessary to place the HP 12C calculator in Odd-Period mode. This is done by entering a non-integer value for n. The integer portion represents the number of full periods. The fractional part specifies the length of the odd period as a fraction of the full period. The calculations during the odd period can be done with either simple or compound interest. If the C status indicator in the display is not lit, simple interest is used. Compound interest, indicated by the C in the display, is set by pressing [STO][EEX]. Pressing [STO][EEX] again returns the calculations to simple interest for the odd period. Enjoy that 12c 30ae. BEST! SllideRule Thomas Radtke Unregistered Posts: 1,089 Threads: 32 Joined: Dec 2005 11-12-2013, 10:18 AM You question has been answered, but I'd like to add something or put it in a different light: Quote: On my calculator I use: n=1.5,fv=-1,i=10,pv=0.8658 Yet when I use the formula:((1/1+i)^n)or (1/1+0.10)^1.5 = 0.8668 The later figure is correct in my study materials, so I have to go with that figure. It's often useful to calculate a problem like the above step by step to see what's going on: Take 0.8658 and add 10% interest for one year and you'll have 0.9524. Now take 0.9524 and add 5% interest for six month and you'll have 1. The other solution is mathmatically correct but the formula doesn't apply to the accumulation function for non-integer periods ;). ▼ Edward Dixon Unregistered Posts: 6 Threads: 1 Joined: Nov 2013 11-12-2013, 11:05 AM Hi Thomas, Thanks for your input. I never thought of it this way. By following your instructions I found myself back at 1. I guess its good to understand the reciprocal effect of your TVM calculations. My understanding is that the 5% interest is simply the .5 non-integer period, when comparing to the whole period of 10%... Many thanks for all your support. It's great to be a part of a really helpful forum. regards Edward

 Possibly Related Threads… Thread Author Replies Views Last Post RPN bugs both present in Prime Calc and emulator Eelco Rouw 9 2,749 10-16-2013, 12:22 PM Last Post: Eelco Rouw HP12C Platinum PC software activation fails Russell Clinton 0 1,079 07-02-2013, 02:32 PM Last Post: Russell Clinton HP12C Limited Edition 30 anniversary keyboard Revan Ng 0 913 01-11-2013, 12:49 AM Last Post: Revan Ng HP12C 'complete' collection Keith Midson 9 3,727 08-07-2012, 07:51 PM Last Post: Keith Midson HP12c Anniversary Seft Test Nick Mihiylov 2 1,323 01-04-2012, 07:23 AM Last Post: Koralatov The HP12c Anniversary edition has finally arrived to Europe Jose Gonzalez Divasson 1 1,137 11-12-2011, 08:16 AM Last Post: hpnut HP keyboards, past and present Cristian Arezzini 4 1,609 10-14-2011, 01:34 PM Last Post: Lincoln R. hp12C capability Todd Israels 8 2,347 10-14-2011, 12:20 AM Last Post: Todd Israels HP12c 30th AE keyboard Paulo MO 4 1,598 10-01-2011, 03:26 AM Last Post: Paulo MO HP12C Article in the Financial Times Charles 4 1,734 09-24-2011, 06:54 PM Last Post: Mark Harman

Forum Jump: