Post Reply 
(17B/19B) GPM: initial payment
05-25-2024, 09:12 PM (This post was last modified: 05-25-2024 10:28 PM by Gil.)
Post: #9
RE: (17B/19B) GPM: initial payment
My program, with the solver, enables the person to choose the variable to be solved, and not only PMT (in which case a simple division solves the problem).
1) The person might, for instance, decide to accept a more expensive bank, starting paying back monthly 480 for 12 months, then 480×1.075 during the next 12 months, etc., and try to calculate the charged annual interest rate I%Y. With the solver, the answer is straightforward here:12.1345% (effective 12.8327%).
2) Or, at the same bank, the person can only pay back 400 the first 12 months, then an increasing amount every year during 5 years. How much should the client paid back monthly in the second year? Press then the Solver for IG%Y (G for Growth), to find 12.7759% —> monthly payments during the 2nd year = 400×1.127759 = 451.1037.
3) I could decide not to have any Growth payment (IG%=0 snd/or #of years of Growing payments, YG, = 0), and have C/YR = 3 (or 6, 2, 1...) and P/YR = 12 (or 6,2,1...), FV≠0, and calculate the monthly PMT to be paid.
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: 6 Guest(s)