HP 12C bond calculation

12292016, 09:09 PM
Post: #1




HP 12C bond calculation
The yield to maturity value from my 12c's do not agree with the brokerage firm, my 17bii+, or financial software running on my 50g.
Any thoughts would be appreciated. I bought a municipal bond through my brokerage firm: Settlement date 12/23/2016 Maturity date 2/15/2017 Price 100.628 Coupon 5% Call 100 30/360 semiannual Brokerage firm Yield to maturity .637% I have 2 HP 12c platinum calculators with a single battery. One of them is a 25th anniversary. Both calculators are set to rpn and show a ytm of .7035%. I also have a 17Bii+. Using the bond menu it returns a ytm of .63698%. I also have a 50g using Financial Applications software written by Don Phillips. It returns a ytm of .637%. Since the 17bii+ and the 50g closely agree with the brokerage firm value I believe them to be correct. The 12c manual mentions solutions to iterative problems may not exist or there may be multiple roots. I did not see a way to input a starting value. Or, I may be using the 12c's incorrectly. Any thoughts as to why the 12c answer does not agree with the others would be much appreciated. Thanks Randy 

12292016, 11:40 PM
Post: #2




RE: HP 12C bond calculation
I'm not fluent with bonds but this might help:
The HP12C Bonds formulae used are listed on p188 of the User's Guide (2005). The guide also lists program code for alternate bond calculations throughout. Yip, Nick 

12302016, 01:31 AM
Post: #3




RE: HP 12C bond calculation  
12302016, 01:53 AM
Post: #4




RE: HP 12C bond calculation  
12302016, 02:10 AM
Post: #5




RE: HP 12C bond calculation
I ran this on the 12C classic (no idea if I entered the parameters correctly) and returned:
Code: 0.6377047932 I reread your post that you were referring to the 12C Platinum. The 12C Platinum User's Guide (2005) p 217  221 has the listing for "30/360 Day Basis Bonds". 

12302016, 02:41 AM
Post: #6




RE: HP 12C bond calculation
I am by no means a bond expert but learning.
Thanks for the references to the manual. I used the example key strokes on the back of the calculator. The manual says the builtin functions calculate using actual/actual basis and is typically used for treasury bonds and notes. Looks like I used the wrong model. The manual lists a program for municipal bonds using a 30/360 basis. That appears to be the model I need to use. I will need to review program basics but will give it a try. Thanks Randy 

12302016, 02:21 PM
Post: #7




RE: HP 12C bond calculation
Here's a very sweet program written by Tony Hutchins for the Datafile publication from the user's group centered in the UK.
It handles all sorts of bonds for the 12c. Might be the best option to have in the 12c. PDF is here: 12c_BondsGalore.pdf (Size: 144.45 KB / Downloads: 102) 

12302016, 04:14 PM
Post: #8




RE: HP 12C bond calculation
Thanks for the bonds galore program.
I entered the 30/360 program from the 12c manual. The yield to maturity calculation matched the example but the bond price and accrued value did not match the example. Other yield to maturity examples also worked ok. I even found an alg version of the program which gave the same results as the rpn version. Even though I don't have a complete bond solution, I am fairly sure my initial yield to maturity problem was due to not using the 30/360 method. The bonds galore program seems to have a lot of features. I will give it a try. Thanks Randy 

01052017, 06:55 PM
Post: #9




RE: HP 12C bond calculation
I confirmed my bond model I was trying to use (as mentioned by Gene) was incorrect.
I entered the Bonds Galore program by Tony Hutchins. It packs a LOT of functions into only 80 steps. And, once a bond model and bond data is inputted, a wealth of data is available. I've worked through several examples with known answers and they all match. The downside is that the 12C programming language doesn't allow the luxury of labels or menus. In fact, one 12c related author recommended to not use the 12c for complex programming due to this difficulty. But I'm going to keep my shorthand user notes handy and give it a try. Thanks Randy 

01052017, 06:55 PM
Post: #10




RE: HP 12C bond calculation
I confirmed my bond model I was trying to use (as mentioned by Gene) was incorrect.
I entered the Bonds Galore program by Tony Hutchins. It packs a LOT of functions into only 80 steps. And, once a bond model and bond data is inputted, a wealth of data is available. I've worked through several examples with known answers and they all match. The downside is that the 12C programming language doesn't allow the luxury of labels or menus. In fact, one 12c related author recommended to not use the 12c for complex programming due to this difficulty. But I'm going to keep my shorthand user notes handy and give it a try. Thanks Randy 

01052017, 07:34 PM
Post: #11




RE: HP 12C bond calculation
Great!
Tony Hutchins is a marvel on the 12c. Probably a marvel period, but on the 12c, certainly. :) 

« Next Oldest  Next Newest »

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