Posts: 6
Threads: 1
Joined: Nov 2013
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
Posts: 6
Threads: 1
Joined: Nov 2013
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
Posts: 1,216
Threads: 75
Joined: Jun 2011
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 noninteger 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 TVMCalc v16.0 from my website: ;)
http://fhub.jimdo.com/
Franz
Posts: 6
Threads: 1
Joined: Nov 2013
Franz,
Many thanks for your reply.
When you say that I have my hp12c 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 'inarrears' at the moment. I think that my head would explode if I had to do them 'inadvance'.
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
Posts: 1,216
Threads: 75
Joined: Jun 2011
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 HP12c 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
Posts: 1,216
Threads: 75
Joined: Jun 2011
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 noninteger, then the fractional part is called 'oddperiod' 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.
Posts: 97
Threads: 1
Joined: Jun 2013
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 OddPeriod 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 OddPeriod mode. This is done by entering a noninteger 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
Posts: 6
Threads: 1
Joined: Nov 2013
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 'oddperiod' mode when I've got a noninteger period calculation. For all other integer calculations I should leave it in in 'normal' mode.
Many thanks once again.
Edward
Posts: 1,216
Threads: 75
Joined: Jun 2011
Quote:
From your excerpt of the User Guide I will place the HP12c into 'oddperiod' mode when I've got a noninteger period calculation. For all other integer calculations I should leave it in in 'normal' mode.
Yes, for a noninteger '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.
Posts: 1,089
Threads: 32
Joined: Dec 2005
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 noninteger periods ;).
Posts: 1,216
Threads: 75
Joined: Jun 2011
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
Posts: 6
Threads: 1
Joined: Nov 2013
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 noninteger 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
Posts: 6
Threads: 1
Joined: Nov 2013
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 :)
