HP Forum Archive 18

[ Return to Index | Top of Index ]

Humbly, I return to the Gods: HP12c Help! Message #1 Posted by CaribbeanHP12c on 22 Apr 2008, 2:27 p.m. Hey everyone, i hope your week is off to a good start. Quick question, been reading up on the HP12c manual from the last series of posts but again i've arrived at a bump in the road. Different interest periods and conversion periods. ex. You are saving for a sail boat, and you deposit 1000 every three months into a bank account which pays 8%, compounded annually. Find the amount you will have saved at the end of five years. This is the formula way but how is this done with the HP12c? PMT=1000 i=.08 (Compounded Annually) n= 4x5=20 c=1/4 1000[(1+.08)^20^(1/4)-1] Anc= ---------------------------- (1+.08)^(1/4)-1 Anc = 1000(24.15910964599272) Anc= $24,159.10964599272 I can't find the little step to either change the Interest to an effective rate ( i think that is what it is, so it's quarterly like the payments) or just input the above info and let it do its magic. Again, you scholars are again adding to my education, thank you. warmly, Blake

Re: Humbly, I return to the Gods: HP12c Help! Message #2 Posted by Thomas Radtke on 22 Apr 2008, 3:17 p.m., in response to message #1 by CaribbeanHP12c The trick is to calculate the "effective payment" per compunding interval. This is [ PMT x ( N + I% x ( N + 1 )/2 ] / ( 1 + I% ) when the first payment is made at the beginning of a month and [ PMT x ( N + I% x ( N - 1 )/2 ] / ( 1 + I% ) when the first payment is made at the end of the month where N ist the number of payments per interval. This is not part of any financial calculator. The reason is that you won't get any interest at all for payments made inside an compounding interval in the US. Hope I got you right ^^ Of course, you can easily enter a program into your 12C

Re: Humbly, I return to the Gods: HP12c Help! Message #3 Posted by CaribbeanHP12c on 22 Apr 2008, 3:29 p.m., in response to message #2 by Thomas Radtke Thomas: Yes, thank you for the knowledgeable explanation... (calculating the "effective") after learning this long hand, i wanted to just tap a few buttons on the HP12c and arrive at the same answer. I have to take the time to learn how to program it... but for now i have to push forward and get this part of the MBA finished. A million thanks... i'll be back i am sure. Blake

Re: Humbly, I return to the Gods: HP12c Help! Message #4 Posted by Chuck on 22 Apr 2008, 3:58 p.m., in response to message #2 by Thomas Radtke Quote: This is not part of any financial calculator. But the TI calculator's TVM solver can have non-equal payment periods and compounding periods (along with my TVM solver I posted a few weeks ago). While they may not be the best "Financial Calculator" around, they certainly have a nice TVM solver.

Re: Humbly, I return to the Gods: HP12c Help! Message #5 Posted by Thomas Radtke on 22 Apr 2008, 5:12 p.m., in response to message #4 by Chuck Years ago I tried a BA simulator on my PDA and it failed to calculate it correctly. I have to check this again. Thanks for pointing this out!

Re: Humbly, I return to the Gods: HP12c Help! Message #6 Posted by Chuck on 22 Apr 2008, 3:54 p.m., in response to message #1 by CaribbeanHP12c Use the nominal rate. You want to use the nominal rate P quarterly which gives an annual effective rate of 8%. I would imagine the 12c has an effective <--> nominal conversion ability. If not, here's the conversion by hand: (1+P/4)^4 = 1.08 Solve for P (4th root; subtract 1; multiply by 4). This gives P=.0777061876 Use that in the 12c finance solver along with 4 compoundings, and you should get the correct answer. CHUCK

Check the materials HP already provides online - a direct answer Message #7 Posted by Gene Wright on 22 Apr 2008, 4:52 p.m., in response to message #6 by Chuck HP has provided quite a few learning modules on their webpages just to help with problems like this. One in particular: Interest Rate Conversions is exactly what you need to do for this problem. The basic answer is: The 12c and 12cp are "per period" calculators, where the interest rate is always given per period. A period in this case is the payment period. Monthly payments require a monthly interest rate. If the interest rate is annual, you must convert it to the equivalent monthly interest rate and use that. Formula: Effective rate = ( ( 1 + nominal rate / periods per yr ) ^ (periods per year) ) - 1 In your example, you woudl be going backward from an effective rate to the nominal rate compounded more than once a year. The learning module shows how to do that. Some calculators (17b2, 10b2 and some TI models) allow for different compounding periods for interest rates compared to payment periods. The HP 12c does not. It is/was a design decision. Much of the financial world would be very upset :-) if someone changed how the 12c works. Here is the link to all the learning modules for the 25th anniversary HP 12c in one zip file. 2.7MB Zip file of all HP learning modules for the 12cp Enjoy. Gene

Re: Check the materials HP already provides online - a direct answer Message #8 Posted by CaribbeanHP12c on 22 Apr 2008, 5:25 p.m., in response to message #7 by Gene Wright Wow... I'm flying through this current course with the added insight from everyone here and all the extra modules. Everyone... thank you for the quick replies. As i've mentioned before is there anything i can do for this forum? Perhaps keep my eye out for rare calculators i see in stores around the area? Lots of banks from the 70'and 80's down here... i bet there are boxes full of antique HP's etc. Warmly, Blake

Re: Check the materials HP already provides online - a direct answer Message #9 Posted by Dave Shaffer (Arizona) on 22 Apr 2008, 7:50 p.m., in response to message #8 by CaribbeanHP12c Quote: down here] Where is "here"? Maybe you can host the next calculator conference and we will all come visit - like next January or February!

Re: Check the materials HP already provides online - a direct answer Message #10 Posted by CaribbeanHP12c on 29 Apr 2008, 12:53 a.m., in response to message #9 by Dave Shaffer (Arizona) Quote: Where is "here"? Maybe you can host the next calculator conference and we will all come visit - like next January or February! I am in the French West Indies.. Martinique! Beautiful island... beaches, a family i am friends with own the old hilton, the hotel bateliere here and the club med. Is that good enough to host a conference? Sorry, took a bit to reply to that one!!! Doors are open down here... you all will get me through my MBA with all your help... i'll host it every year in a new country.

Re: Humbly, I return to the Gods: HP12c Help! Message #11 Posted by tony (nz) on 22 Apr 2008, 10:52 p.m., in response to message #1 by CaribbeanHP12c 4 [n] 1 [CHS] [PV] 0 [PMT] 1.08 [FV] [i] ->1.94%, the effective rate per quarter then [g] [END], 20[n] 0 [PV] 1000 [CHS] [PMT] [FV] -> $24,159.11 Cheers, Tony

Re: Humbly, I return to the Gods: HP12c Help! Message #12 Posted by Antonio Maschio (Italy) on 23 Apr 2008, 6:09 a.m., in response to message #11 by tony (nz) ... great! -- Antonio

Re: Humbly, I return to the Gods: HP12c Help! Message #13 Posted by CaribbeanHP12c on 23 Apr 2008, 9:46 a.m., in response to message #11 by tony (nz) Lol.. that slick little method of getting the effective rate just cut my project time in half. As i stated in the Title of this post... "... Gods" 4 [n] 1 [CHS] [PV] 0 [PMT] 1.08 [FV] [i] ->1.94%, the effective rate per quarter It's just that easy, isn't. Great work. Thanks. Blake

[ Return to Index | Top of Index ]

Go back to the main exhibit hall