The Museum of HP Calculators

HP Forum Archive 18

 HP12c Financial Questions... yet again!Message #1 Posted by CaribbeanHP12c on 1 May 2008, 5:58 p.m. Dear members: What is the CASH VALUE function with the HP12c? I've been in the manual and can't quite find the exact function. For example: A mortgage payment of 750 per/month for 20 years( NEW EDIT), effective rate of interest 4.88088482 and 5000 down payment. What is the purchase price. < 2 [n] 1 [CHS] [PV] 0 [PMT] 1.10 [FV] [i] ->4.88088482%, the effective rate monthly. That was courtesy of you guys here. > It's not the present value, as that incorporates the interest. How do i strip out the interest on the HP12c. Giving me \$83,809.29 as my correct answer? Warmly, Blake Edited: 2 May 2008, 2:48 a.m. after one or more responses were posted

 Re: HP12c Financial Questions... yet again!Message #2 Posted by tony (nz) on 1 May 2008, 8:41 p.m.,in response to message #1 by CaribbeanHP12c Hi Blake, that 4.88% seems a very high monthly rate - is it for 6 months? How long does the mortgage run for? I think you'll find "cash value" is basically the same as PV - this is discounted for interest. Cheers, Tony

 Re: HP12c Financial Questions... yet again!Message #3 Posted by tony (nz) on 1 May 2008, 9:24 p.m.,in response to message #2 by tony (nz) I can get the \$83,809.29 assuming the interest rate is 10% pa convertible 6 monthly, i.e. 5% true per 6 month period, and the mortgage runs for 20 years: 6 [n] 1 [CHS][PV] 0 [PMT] 1.05 [FV] [i] -> 0.816484605 % per month [g] [END] 240 [n] 750 [CHS][PMT] 0 [FV] [PV] ->\$78,809.29 5000 [+] -> \$83,809.29 The PV of \$78,809.29 here does effectively strip the interest out of the payment stream (of \$180,000). Cheers, Tony Edited: 1 May 2008, 11:31 p.m.

 Re: HP12c Financial Questions... yet again!Message #4 Posted by CaribbeanHP12c on 2 May 2008, 2:53 a.m.,in response to message #3 by tony (nz) Tony... genius at the HP12c! That works perfect... but i can never find these type of sequences on in the Manual. Tell me, is necessary to type in [g] [END] at that exact place. what if i put it in the beginning? or if the sequence was slightly rearranged. does this always effect outcomes? For simple interest calculations, i can put in [n] or [PMT] before or after? Is there rules for this with the HP12c? 6 [n] 1 [CHS][PV] 0 [PMT] 1.05 [FV] [i] -> 0.816484605 % per month [g] [END] 240 [n] 750 [CHS][PMT] 0 [FV] [PV] ->\$78,809.29 5000 [+] -> \$83,809.29 I am ecstatic with this new info... thank you all. blake

 Re: HP12c Financial Questions... yet again!Message #5 Posted by George Bailey (Bedford Falls) on 2 May 2008, 3:11 a.m.,in response to message #4 by CaribbeanHP12c Quote: Tell me, is necessary to type in [g] [END] at that exact place. what if i put it in the beginning? or if the sequence was slightly rearranged. does this always effect outcomes? A little experimenting on you part won't hurt - and you become more proficient with your machine...;-)

 Re: HP12c Financial Questions... yet again!Message #6 Posted by CaribbeanHP12c on 2 May 2008, 3:36 a.m.,in response to message #5 by George Bailey (Bedford Falls) George: lol.. yes, this being the reason i end up coming over here. A little to much experimenting and not enough knowledge on it... but you guys here are a godsent. ;) Quote: A little experimenting on you part won't hurt - and you become more proficient with your machine...;-)

 Re: HP12c Financial Questions... yet again!Message #7 Posted by George Bailey (Bedford Falls) on 2 May 2008, 5:13 a.m.,in response to message #6 by CaribbeanHP12c Quote: Tell me, is necessary to type in [g] [END] at that exact place. what if i put it in the beginning? or if the sequence was slightly rearranged. does this always effect outcomes? For simple interest calculations, i can put in [n] or [PMT] before or after? Is there rules for this with the HP12c? Quote: George: lol.. yes, this being the reason i end up coming over here. A little to much experimenting and not enough knowledge on it... but you guys here are a godsent. ;) Seriously, the questions in your post #4 are such that you can easily answer them yourself by - well - experimenting! Put the [g][END] sequence in different places of the calculation and compare the results: they should all be the same, no expert knowledge required here ;-) Then rearrange and compare results and so on... Edited: 2 May 2008, 5:15 a.m.

 Re: HP12c Financial Questions... yet again!Message #8 Posted by tony(nz) on 2 May 2008, 3:26 a.m.,in response to message #4 by CaribbeanHP12c Quote: Tony... genius at the HP12c! That works perfect... but i can never find these type of sequences on in the Manual. The "Solutions Manual" has a chapter on Canadian Mortgages but they do the interest rate calc slightly differently: 0 [PMT] 6 [n] 200 [ENTER][PV] 10 [+] [CHS] [FV] [i] -> 0.816484605 % per month The book also shows [g][END] being set before this calculation but as PMT=0 the payment mode is irrelevant. I only do the calc the way I do because I think "OK over 6 periods \$1 grows to \$1.05". Hence n=6 PV=1 FV=-1.05. That's easier for me than thinking "200 will grow to 210". Quote: Tell me, is necessary to type in [g] [END] at that exact place. what if i put it in the beginning? or if the sequence was slightly rearranged. does this always effect outcomes? If PMT=0 (and you are not solving for a non-zero PMT) then the PMT mode doesn't matter. I only tend to mention it at the point where it is necessary. Quote: For simple interest calculations, i can put in [n] or [PMT] before or after? Is there rules for this with the HP12c? Any input order is fine - you just need everything set before you solve. I normally work left to right when writing down a solution. The best thing is that if the answer is wrong you don't need to re-key everything - just correct the input error, and try again. Quote: 6 [n] 1 [CHS][PV] 0 [PMT] 1.05 [FV] [i] -> 0.816484605 % per month [g] [END] 240 [n] 750 [CHS][PMT] 0 [FV] [PV] ->\$78,809.29 5000 [+] -> \$83,809.29 You can also use NPV to get the purchase price directly but need 3 entries for the 240 PMTs as you can only have Nj up to 99: Solve for [i] as above then do 5000 [g][Cfo] 750 [g][Cfj] 80 [g][Nj] then repeat twice more or do: [x<>y][g][Cfj] [x<>y}[g][Nj] [x<>y][g][Cfj] [x<>y}[g][Nj] [f][NPV]->83,809.29 Quote: I am ecstatic with this new info... thank you all. blake Thanks for your enthusiasm Blake. It's a great little machine! Cheers, Tony

 Re: HP12c Financial Questions... yet again!Message #9 Posted by CaribbeanHP12c on 2 May 2008, 3:40 a.m.,in response to message #8 by tony(nz) Tony, That certainly straightened me out! I was able to just move a few things around and get the PMT for a few other questions. Now onto figuring out the outstanding balance after two years of payments. Wish me luck. It's 3:30 am... far too late for Finance! Nite all, appreciate all your help. Blake

 Re: HP12c Financial Questions... yet again!Message #10 Posted by tony(nz) on 2 May 2008, 4:10 a.m.,in response to message #9 by CaribbeanHP12c Quote: Tony, That certainly straightened me out! I was able to just move a few things around and get the PMT for a few other questions. Now onto figuring out the outstanding balance after two years of payments. Wish me luck. Good Luck Blake! 20-2=18 years to go so try 18[g][n][PV] ;-) Cheers, Tony

 Re: HP12c Financial Questions... yet again!Message #11 Posted by CaribbeanHP12c on 2 May 2008, 3:09 a.m.,in response to message #3 by tony (nz) 6 [n] 1 [CHS][PV] 0 [PMT] 1.05 [FV] [i] -> 0.816484605 % per month if the interest is compounded ANNUALLY do i only change the 6 [n] to 1 [n] with the example above? Monthly = 12 Quarterly = 4 Semi-Annually = 6 Annually = 1 Would this work if i altered the variables?

 Re: HP12c Financial Questions... yet again!Message #12 Posted by tony(nz) on 2 May 2008, 3:45 a.m.,in response to message #11 by CaribbeanHP12c Quote: 6 [n] 1 [CHS][PV] 0 [PMT] 1.05 [FV] [i] -> 0.816484605 % per month if the interest is compounded ANNUALLY do i only change the 6 [n] to 1 [n] with the example above? Monthly = 12 Quarterly = 4 Semi-Annually = 6 Annually = 1 Would this work if i altered the variables? The example has monthly payments so you need a monthly interest rate. That is the bottom line :-) Also, you need the appropriate FV. My guess is you probably need n to represent the number of months in the interest rate compounding period Monthly = 1, (no need to do this as the i =10%/12) Quarterly = 3, FV=1+.1/4 Semi-Annually = 6, FV=1+.1/2, as in your example Annually = 12, FV=1.1 Cheers, Tony

 Re: HP12c Financial Questions... yet again!Message #13 Posted by Gene Wright on 1 May 2008, 8:48 p.m.,in response to message #1 by CaribbeanHP12c I don't believe there is anything other than the PV. I am also familiar with the TI BAII+ and the Casio and Sharp financial calculators and am unaware of any "cash value" function. When you say "It isn't the PV, as it includes interest", I don't believe that is correct. The PV doesn't include interest, per se, but the time value of money. The PV is, of course, the amount today that is equal to the payments occuring in the future... and the time value of money must be taken into account. The 4.88% you show is the rate per period that is equivalent to 10%, per year nominal. With n of 2, this is a semiannual rate, not an effective monthly rate (there is no such thing with that language). Effective rates are almost entirely annual rates equal to nominal rates compounded more frequently than once a year. Also, you don't specify the number of payments. 180? 360? So, I can't answer your question as I don't understand what you're asking well enough. :-) Gene

 Re: HP12c Financial Questions... yet again!Message #14 Posted by CaribbeanHP12c on 2 May 2008, 2:46 a.m.,in response to message #13 by Gene Wright Hey everyone... thanks again. Yes.. i see where i made my mistake in the effective rate. The interest is compounded semi-annually. Gene: I concur, now, the language does not exist. ;) And the time is 20 years so... n = 240 (opps) My frustration caused the slight attention to detail in this post. Excuse me. Thank you for the clear explanation as well. I'm trying the above formula with the HP12c, now! Best, blake Edited: 2 May 2008, 2:46 a.m.

Go back to the main exhibit hall