Thursday, February 28, 2019

HP 12C: ARM Term if Renewed

HP 12C:  ARM Term if Renewed

Introduction

Situation:  An ARM Mortgage has one rate adjustment.  The mortgage calls for the payment to remain the same for the entire mortgage, even after the rate adjustment.  How long will it take to pay off the mortgage?  Specifically, how long will it take after the rate is adjusted (ARM term)? 

Example 1:

Original term: 30 years ( n = 360 )
Interest rate: 6%  ( i = 6/12 )
The interest rate scheduled to increase 0.25% in 4 years.

HP 12C Procedure

Any loan amount will do for this problem.  We'll use $1 for the loan amount in this example since we're only concerned with the ARM term.

Keystrokes:

(FIX 4 is set)

1.  Find the payment of the original mortgage.

Clear Finance Registers:   [ f ] [ x<>y ] (CLEAR FIN)
1 [ PV ]
30 [ g ] (12x) [ n ]
6 [ g ] (12÷) [ i ]
[PMT]   (Result:  -0.0060)

2.  Determine the balance of the mortgage at the date when the mortgage is adjusted (4 years).

4 [ g ] (12x) [ n ]
[ FV ]  (Result:  -0.9461)

3.  Transfer the balance to the new mortgage amount and enter the adjusted mortgage rate.

[CHS] [ PV ]
0 [ FV ]
[RCL] [ i ] 0.25 [ENTER] 12 [ ÷ ] [ + ] [ i ]
[ n ] (Result:  333.0000)

If the payment is kept the same, it would take another 333 payments to pay off the mortgage.  The ARM Term is 333.

The total time it takes to pay the mortgage is:

Pre-Adjustment Term + ARM Term

In this case, 381 payments (48 + 333).

The program presented here will calculate the ARM term.  This makes the assumption that the mortgage is only adjusted one time during its entire life.  This is similar to looking up the financial table ARM Term If Renewed Table (refer to source).

HP 12C Program:  ARM Term if Renewed

Keys:

01  1      
02  PV
03  0
04  FV
05  PMT
06  RCL 1 
07  n
08  FV
09  CHS
10  PV
11  0
12  FV
13  RCL i
14  RCL 2
15  +
16  i 
17  n
18 GTO 00   (HP 12C Platinum: GTO 000)

Key Codes:

01  1
02  13
03  0
04  15
05  14
06  45, 1
07  11
08  15
09  16
10  13
11  0
12  15
13  45, 12
14  45, 2
15  40
16  12
17  11
18  43, 33, 00  (HP 12C Platinum:  43, 33, 000)

Instructions:

Store the original number of periods in [ n ]
Store the original periodic interest rate in [ i ]
Store the number of months before the rate adjusts in R1.
Store the periodic adjustment (±r%) in R2.
Press [ R/S ]

Example:

Original term: 35 years
Original rate: 4.5%
The rate is adjusts +0.3% in 5 years.

35 [ g ] [ n ] (12x)
4.5 [ g ] [ i ] (12÷)
5 [ENTER] 12 [ x ] [STO] 1
0.3 [ENTER] 12 [ ÷ ] [STO] 2
[ R/S ]

Result:  391

The ARM term is 391 months.

Source:

Lincoln Title Company "Financial Conventional and ARM Payment Tables" Publication No. 493. Special Edition.  Financial Publishing Company: Boston, MA. May 1985 ISBN 0-87600-493-1

Eddie


All original content copyright, © 2011-2019.  Edward Shore.   Unauthorized use and/or unauthorized distribution for commercial purposes without express and written permission from the author is strictly prohibited.  This blog entry may be distributed for noncommercial purposes, provided that full credit is given to the author.