Post Reply 
(17B/19B) GPM: initial payment
06-19-2024, 10:09 AM
Post: #36
RE: (17B/19B) GPM: initial payment
Made the 12C procedure a lot simpler, using an alternate version of the equation (without BEG or FV):

0 = PV/USFV(K%,NG) + PMT*(USPV(I%,NP) + USPV(I%,N-NP*NG)/USPV(K%,NG))

P := USPV(I%,NP);
K% := G%*SPPV(I%:NP)-I%*P;
PMT := -PV/(USFV(K%,NG)*(P + USPV(I%:N-NP×NG)/USPV(G(K%):NG));

17B equation:
Code:
GPM:PV/USFV(L(K%:G%×SPPV(I%:NP)-I%×L(P:USPV(I%:NP))):NG)+PMT×(G(P)+USPV(I%:N-NP×NG)/USPV(G(K%):NG))

12C procedure (reuses values on the stack, so make sure to follow it to the letter):

 variable value key            result        description
               [f] [CLEAR FIN]
               [g] [END]
 NP        12  [N]
 I%        1   [i]
               [STO] [PMT]
 G%       7.5  [CHS] [FV]
               [PV]           -4.599208284   K%
               [STO] [i]
 NG        5   [N]
           0   [PV]
           1   [PMT]
               [FV]           -4.560749934  -USFV(K%:NG)
           0   [FV]
               [PV]           -5.771336094  -USPV(K%:NG)
 N-NP*NG  300  [N]
 I%        1   [i]
               [PV]          -94.94655125   -USPV(I%:N-NP*NG)
               [X<>] [/]      16.45139872
 NP        12  [N]
               [PV]          -11.25507747   -USPV(I%:NP)
               [-] [x]      -126.3623095
 PV     60000  [X<>Y] [/]   -474.8251297    PMT


Cheers, Werner

41CV†,42S,48GX,49G,DM42,DM41X,17BII,15CE,DM15L,12C,16CE
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 - Werner - 06-19-2024 10:09 AM
RE: (17B/19B) GPM: initial payment - Gil - 06-20-2024, 01:28 PM



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