Introduction TVM on HP 12c
Many financial problems are based on the concept of charging a fee (interest) for the use of someone else’s money for a fixed period of time. The phrase time value of money describes the calculations based on such problems.
There are two main types of financial problems that HP 12c can help to solve:
- Compound interest
- Simple interest
With simple interest, only the principal (the original amount of money) earns interest for the entire life of the transaction. The principal, plus interest earned is repaid in one lump sum.
When simple interest is added to the principal at specified compounding intervals, and thereafter, also earns interest, the interest is compounded. Savings accounts, mortgages and leases are compound-interest calculations.
There are five standard variables used to describe most compound interest (TVM) problems:
Number of payments
Periodic interest rate
Payment amount each period (periodic payment amount)
The TVM capability in the HP 12C calculator does many compound-interest problems. Specifically, the TVM functionality can be used for a series of cash flows (money paid, or money received) when:
- The dollar amount is the same each payment
- The payments occur at regular intervals
- The payment period coincides with the compounding periods
Given any four of the above key elements, it is possible to solve for the fifth variable.
Cash Flow Diagrams and Signs of Numbers
It is often helpful to illustrate or visualize TVM calculations with cash-flow diagrams. Cash-flow diagrams are time lines divided into equal segments called compounding (payment) periods. Arrows show the occurrence of cash flows (payment in or out). Money received is a positive number shown as an arrow pointing up, and money paid out is a negative number shown as an arrow pointing down (Figure 1).
It is essential to use the correct sign (positive or negative) for TVM numbers. The calculations will only make sense if payments out are consistently shown as negative, and payments in (receipts) as positive. A calculation must be performed from the point of view of either the lender (investor) or the borrower, but not both. This is called the TVM sign convention.
HP 12c TVM Example
Example: A home mortgage
The maximum monthly mortgage repayment you can make is $850. You can make a $14,000 down payment. The current interest rate is 8.75%. For a mortgage of 25 years, what is the maximum purchase price that you can afford?
Figure 1: Cash Flow Diagram
Following are the hp12c keystrokes used to solve the problem in this example problem:
(the display is not changed)
Clear hp12c financial registers
(the display is not changed)
Set hp12c END mode
Number of payments use by the hp 12c
Monthly interest rate on the hp 12c
Monthly payment on the hp12c
Future value = 0
(ie mortgage paid out)
Calculate amount to borrow
Add down payment to get maximum purchase price.
Here is how to solve the same problem using the HP 10bii.
HP 12c TVM Tips
Following are some HP 12c tips to use when solving TVM problems, to help arrive at the correct answer:
- Clear the HP 12c TVM variables before beginning a new calculation. This removes unwanted values from the calculator memory.
- Set HP 12c the appropriate payment mode. (Mortgages and loans are typically END mode calculations, and leases are typically BEGIN mode calculations.
- Be sure the correct interest rate is entered into the HP 12c.
- The compounding period on the hp 12c must be the same as the payment period. (If not, interest rate conversion functions will need to be used to calculate the correct rate).
- Remember the sign convention on the hp12c:
money received = positive number, money paid out = negative number