I get repeatedly asked how to discount paper. Many people think this is some magical system used to discount a observe or mortgage to a specific provide, but really it is quite simple if you have the right tools. I will show you below step by step how to discount a observe using both the HP-12C and the Texas Instruments Business Analyst II Plus or BA II Plus.
Generally speaking you need to start by putting the terms of the existing loan into your calculator. For this example we will use a loan or observe with a starting balance of $100,000, payable monthly at 6% interest and fully amortized for 30 years. Once this is in our calculator, we solve for payment. Now let’s assume we want to discount this loan to provide 10%. Since the loan is already in existence we can’t change the terms of the loan but we can change what we would pay for this loan to unprotected to our 10% provide. With the above information already in our financial calculator we change the interest rate to 10% and solve for PV or present value.
Using the BA II Plus the meaningful strokes would be as follows:
1. Clear the financial registers by the beige 2nd meaningful and then pressing the beige CLR TVM. I generally repeat this course of action by pressing the 2nd meaningful and hitting CLR WORK also and some already add the 2nd meaningful followed by the RESET meaningful.
2. Next, you put in the terms of the above existing loan: 6 I/Y, 100,000 PV, 360 N and solve for the payment by hitting the CPT meaningful followed by the PMT meaningful. The calculator should read -599.55. The number is negative because the calculator is telling us that this is an OUTGOING payment vs an incoming payment which would be positive.
3. Next we put our new provide of 10% into the calculator by putting 10 into the calculator and then pressing I/Y to set the new interest per year at 10%.
4. Next, we press CPT and PV to compute the new present value and we get 68,319.27. This method that if you needed a 10% provide on your invested funds on the observe described above, you would pay $68,319.27 for it. The difference between the $100,000 and the $68,319.27 is $31,680.73 which is the amount of the discount. This is a discount of about 32% ($31,680.73 divided by $100,000.00 =.3168 or rounded to.32 or 32%)
Now if the above observe had been seasoned for 3 years or 36 months, when we were changing the interest or I/Y from 6 to 10, we would also change the N from 360 to 324 which is 360 – 36. Then we would solve for PV like we did above and get $67,056.46 as our discounted price.
If you are working with interest only payments go into the N as 99999. Working with balloon payments is a little trickier so contact us and we will discount that for you as a free service.
The entering of data on the 12C is a little different than the BA II Plus. To multiply 3 time 6 on the BA II you would go into the numbers just as you would say them; 3, X, 6, = and you would get 18. On the 12C you would go into 3, go into meaningful, 6, and then X for times and you would get your answer of 18.
To run the same discounting on the 12C we would again go into the terms of the observe or loan as it exists currently. We would clear it by pressing the beige f meaningful and then the CLX to clear the financial registers.
Then go as follows:
1. 100000, PV, 360 N, 6 blue g meaningful I, PMT and we would get the same payment as above of -599.55. Again negative numbers are sums going out and positive numbers are sums coming in.
2. Next go into the new interest rate 10, blue g, I, PV to get the discounted present value.
3. Interest only calculations can be achieved by entering 99999 into the N
4. As with the BA II Plus balloon payments are a little trickier but if you contact us we will be glad to discount your balloon payment deal free.
While I have an HP 12C and have used it over the years I prefer the BA II Plus. Back in the ’80’s I used one of the first Business Analyst calculators that Texas Instruments ever made and loved it. When I finally wore it out I checked around to buy a new one and ended up contacting Texas Instruments directly to order one. I told them how I love the machine and finally wore it out and needed a new one and was ready to buy it and they took my shipping information and sent me a new one totally free. I told them that they didn’t need to do that as the old calculator owed me nothing but they insisted and sent me the new BA II Plus totally FREE. Now that’s customer service.
I hope you find this helpful in discounting paper or notes or loans etc. If we can help you discount them or buy them from you, please contact me at your convenience.
Thanks for your time,
T J Stewart, Founder & CEO