Post Reply 
(17B/19B) GPM: initial payment
05-25-2024, 11:52 PM
Post: #11
RE: (17B/19B) GPM: initial payment
To solve PMT with growing payments we have:

PV+
{PMT×(v^12-1)/i ×[Sum, (1.075/1.01)^j, j=0..(5-1)] +
PMT×[v^(360-12×5)-1)/i]×(1.075/1.01^12)^5
}=0,
with v=1/1.01, i=0.01

Then
PV+PMT×
{(v^12-1)/i ×[Sum, (1.075/1.01)^j, j=0..(5-1)] +
[v^(360-12×5)-1)/i]×(1.075/1.01^12)^5
}=0,
with v=1/1.01, i=0.01

Then
PMT=-PV /{(v^12-1)/i ×[Sum, (1.075/1.01)^j, j=0..(5-1)] +
[v^(360-12×5)-1)/i]×(1.075/1.01^12)^5}

That's plain and easy. Trickier is to find i.
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)