I've recently switched back to my 12C after using the 17BII for mortgage calculations. While I use the solver to program the Canadian mortgage factor in the 17BII, there is no solver in the 12C. Any idea how I can do this on my 12C?
Thanks in advance for any response.
Canadian Mortgages on 12C


« Next Oldest  Next Newest »

▼
05252002, 11:12 PM
▼
05262002, 03:04 PM
The 12C is programmable. You may not be able to accomplish the Solvertype user interface, but if you know the algorithm, you should be able to write a program to do it. Your question rang a bell in my memory  I looked in the various manuals I have for anything to do with Canadian finances. The HP10B manual, on page 105, tells exactly how to do it on a 10B, which has an interest rate conversion function which doesn't seem to be on the 12C. You convert the nominal rate to an effective rate based on the two compounding periods per year used in Canada. Then you convert that effective rate back to a nominal rate which the book calls a "Canadian mortgage factor", by specifying 12 payments per year. Then the calculated nominal rate makes the TVM function give the correct results. In the example, a 12% nominal rate at two compounding periods per year gives 12.36% effective rate, which at 12 payments per year gives 11.71% Canadian mortgage factor. The HP12C manual has a section on interest rate conversions on pages 179181. It shows how to do conversions from nominal rate to effective rate and viceversa, manually and with a program. This is not my area of expertise, but I hope these pointers help you. You might want to get a 10B, I got mine at WalMart for about $15 clearance price.
05272002, 03:50 AM
Hi,
I will develop this more practically on my web site page and as soon as it's updated I'll meil you the html code. As I'm not very familiar with this all I need to know is what kind of rate is given by the financial institutions : is it annual, semiannual or monthly ? Good luck ! Thibaut
05282002, 03:07 AM
Hello,
The Canadian mortgages are actualized on a semiannual basis on the "yield" rate given, while the American mortgages are calculated on a monthly basis on the given "yield". Just note that, as demonstrated, the American financial institutions are the most greedy, the Canadian far less. The law in France and Belgium oblige the banks and other lenders to show the APR, which makes all offers more comparable.
So what you actually need is to convert There are several way of doing this, including the financial solver of the 12C, what I don't recommend because you may by mistake forget one value of this conversion in the financial registers and use it your final calculation. One really has to be very careful with financial calculations. It's amazing to see how simple maths (+,,*,/ and ^) can become so complicated. So, let's calculate the APR (i'll call it 'i') for the canadin mortgage.
i = APR Since it's capitalized twice in the year, i = (1+ic/2)^21 and the reverse is ic = 2((1+i)^21) So, if the showed rate is 12%, the APR is 12.36%
im = showed percentage of american mortgages
i = (1+im/12)^121 So the 'only' thing we have to do is to replace in the last statement i with the calculated value of ic, so
if ic = 12% Don't forget in these formulas to key in percentages in real values, ie 12% = .12, or it won't work !

Possibly Related Threads...  
Thread  Author  Replies  Views  Last Post  
HP 12C, 12C Platinum & 15C iOS App  Walter Lam  2  935 
06022011, 01:25 PM Last Post: Andrés C. Rodríguez (Argentina) 

12C vs 12C Platinum Cash Flows  Katie Wasserman  10  1,920 
12282005, 10:12 PM Last Post: tony(nz) 

12c/12c Platinum programming differences  Don Shepherd  6  1,423 
08112003, 10:11 AM Last Post: Gene 

12C or 12C Platinum...that is the question  Joe  3  936 
06212003, 11:39 PM Last Post: Don Nguyen 

Hi !! Gene, HP 12C vs 12C Platinum  Luc Chanh Truong  0  562 
06092003, 10:28 PM Last Post: Luc Chanh Truong 

Re: Inconsistent results #1: 12c vs. 12c Platinum  hugh  1  673 
05142003, 03:22 PM Last Post: Gene 

Inconsistent Results #2 and #3: 12c vs. 12c Platinum  Gene  3  903 
05132003, 06:58 PM Last Post: Patrick 

Inconsistent results #1: 12c vs. 12c Platinum  Gene  3  865 
05132003, 11:58 AM Last Post: Vieira, Luiz C. (Brazil) 