Humbly, I return to the Gods: HP12c Help! « Next Oldest | Next Newest »

 ▼ CaribbeanHP12c Unregistered Posts: 23 Threads: 4 Joined: Mar 2008 04-22-2008, 02:27 PM 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 ▼ Thomas Radtke Unregistered Posts: 1,089 Threads: 32 Joined: Dec 2005 04-22-2008, 03:17 PM 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 ▼ CaribbeanHP12c Unregistered Posts: 23 Threads: 4 Joined: Mar 2008 04-22-2008, 03:29 PM 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 Chuck Unregistered Posts: 320 Threads: 59 Joined: Dec 2006 04-22-2008, 03:58 PM 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. ▼ Thomas Radtke Unregistered Posts: 1,089 Threads: 32 Joined: Dec 2005 04-22-2008, 05:12 PM 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! Chuck Unregistered Posts: 320 Threads: 59 Joined: Dec 2006 04-22-2008, 03:54 PM 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 ▼ Gene Wright Unregistered Posts: 1,545 Threads: 168 Joined: Jul 2005 04-22-2008, 04:52 PM HP has provided quite a few learning modules on their webpages just to help with problems like this. One in particular: 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. Enjoy. Gene ▼ CaribbeanHP12c Unregistered Posts: 23 Threads: 4 Joined: Mar 2008 04-22-2008, 05:25 PM 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 ▼ Dave Shaffer (Arizona) Unregistered Posts: 776 Threads: 25 Joined: Jun 2007 04-22-2008, 07:50 PM 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! ▼ CaribbeanHP12c Unregistered Posts: 23 Threads: 4 Joined: Mar 2008 04-29-2008, 12:53 AM 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. tony (nz) Unregistered Posts: 93 Threads: 2 Joined: Jul 2005 04-22-2008, 10:52 PM 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 ▼ Antonio Maschio (Italy) Unregistered Posts: 416 Threads: 78 Joined: Mar 2006 04-23-2008, 06:09 AM ... great! -- Antonio CaribbeanHP12c Unregistered Posts: 23 Threads: 4 Joined: Mar 2008 04-23-2008, 09:46 AM 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

 Possibly Related Threads… Thread Author Replies Views Last Post HP Prime - GETPIX_P Return? Thomas Chrapkiewicz 7 2,448 11-25-2013, 08:54 AM Last Post: Thomas Chrapkiewicz HP12c Present Value of \$1.. Inaccurate??? Edward Dixon 12 3,698 11-12-2013, 11:32 AM Last Post: Edward Dixon HP PRIME: Hide return value from program and swap Edit with Run vrrr 2 1,551 11-09-2013, 04:04 PM Last Post: vrrr HP Prime Programming Tutorial #1: LOCAL, RETURN Eddie W. Shore 6 3,046 10-26-2013, 08:42 PM Last Post: Miguel Toro HP12C Platinum PC software activation fails Russell Clinton 0 1,096 07-02-2013, 02:32 PM Last Post: Russell Clinton HP12C Limited Edition 30 anniversary keyboard Revan Ng 0 927 01-11-2013, 12:49 AM Last Post: Revan Ng WP-34S return to HP-30B Mike Wilson 14 3,616 09-13-2012, 10:19 PM Last Post: Tim Wessman HP12C 'complete' collection Keith Midson 9 3,774 08-07-2012, 07:51 PM Last Post: Keith Midson Return of the HP 50g RS-232 serial cables Eric Rechlin 3 1,569 03-09-2012, 06:16 PM Last Post: Andres Capdevila After Cuts, HP Labs Vows Return to Glory Days Kerem Kapkin (Silicon Valley, CA) 1 1,098 02-15-2012, 09:47 PM Last Post: Howard Owen

Forum Jump: