Post Reply 
(17B/19B) GPM: initial payment
05-22-2024, 11:39 AM
Post: #1
(17B/19B) GPM: initial payment
An excerpt from The Graduated Payment Mortgage: Solving the Initial Payment Enigma, , Journal of Real Estate Practice and Education, vol. 1, no. 1, 1998, pp. 67-79 73

APPLICATION OF THE GPM GENERALIZED EQUATION
The generalized GPM equation given in equation (9) is best implemented using a programmable calculator such as the Hewlett Packard (HP) 17B (or HP19B) or a spreadsheet such as Lotus 1-2-3 or Microsoft Excel. For the HP 17B, the user needs to enter into the equation solver in the main menu (SOLVE) and create the following new equation (NEW) as one line (spaces are ignored by SOLVE):
GPM = PV ÷ ((∑(T:1:N-1:1:SPFV(G:T) ÷ SPFV(I:12XT))+1)X
                     USPV((I:12) + SPFV(G:N) ÷ SPFV(I:12XN)X
                     USPV(I:(12XM) - (12XN)))

Once entered correctly, the user should press CALC in the SOLVE menu to verify the equation. The user then enters PV, N, G, i, and M. It should be noted that N and M are in years, G is annual interest rate, and i is a monthly interest rate. As an alternative to the one-step approach, the user can define the term in parentheses as the graduated annuity interest factor (GAIF) and then do a second equation that defines the GPM as PV/GAIF; the HP 17B and HP 19B automatically store the GAIF value from the first step. The advantage of the two-step approach is that the GAIF can be used separately, for example, to find the present value of a loan.

BEST!
SlideRule
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
(17B/19B) GPM: initial payment - SlideRule - 05-22-2024 11:39 AM
RE: (17B/19B) GPM: initial payment - Gil - 05-25-2024, 04:05 PM
RE: (17B/19B) GPM: initial payment - Gil - 05-25-2024, 08:22 PM
RE: (17B/19B) GPM: initial payment - Gil - 05-25-2024, 09:12 PM
RE: (17B/19B) GPM: initial payment - Gil - 05-25-2024, 11:52 PM
RE: (17B/19B) GPM: initial payment - Gil - 05-29-2024, 07:08 PM
RE: (17B/19B) GPM: initial payment - Gil - 05-30-2024, 01:08 AM
RE: (17B/19B) GPM: initial payment - Gil - 05-30-2024, 03:14 AM
RE: (17B/19B) GPM: initial payment - Gil - 06-01-2024, 10:43 AM
RE: (17B/19B) GPM: initial payment - Gil - 06-01-2024, 11:57 AM
RE: (17B/19B) GPM: initial payment - Gil - 06-17-2024, 08:32 PM
RE: (17B/19B) GPM: initial payment - Gil - 06-18-2024, 08:03 AM
RE: (17B/19B) GPM: initial payment - Gil - 06-20-2024, 01:28 PM



User(s) browsing this thread: 1 Guest(s)