▼
Posts: 23
Threads: 4
Joined: Mar 2008
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
▼
Posts: 93
Threads: 2
Joined: Jul 2005
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
▼
Posts: 93
Threads: 2
Joined: Jul 2005
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.
▼
Posts: 23
Threads: 4
Joined: Mar 2008
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
▼
Posts: 335
Threads: 12
Joined: Dec 2007
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...;)
▼
Posts: 23
Threads: 4
Joined: Mar 2008
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...;)
▼
Posts: 335
Threads: 12
Joined: Dec 2007
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.
Posts: 93
Threads: 2
Joined: Jul 2005
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 nonzero 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 rekey 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
▼
Posts: 23
Threads: 4
Joined: Mar 2008
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
▼
Posts: 93
Threads: 2
Joined: Jul 2005
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!
202=18 years to go so try 18[g][n][PV] ;)
Cheers,
Tony
Posts: 23
Threads: 4
Joined: Mar 2008
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
SemiAnnually = 6
Annually = 1
Would this work if i altered the variables?
▼
Posts: 93
Threads: 2
Joined: Jul 2005
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
SemiAnnually = 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
SemiAnnually = 6, FV=1+.1/2, as in your example
Annually = 12, FV=1.1
Cheers,
Tony
Posts: 1,545
Threads: 168
Joined: Jul 2005
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
▼
Posts: 23
Threads: 4
Joined: Mar 2008
Hey everyone... thanks again.
Yes.. i see where i made my mistake in the effective rate. The interest is compounded semiannually.
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.
