Post Reply 
(17B/19B) GPM: initial payment
05-30-2024, 12:24 AM
Post: #21
RE: (17B/19B) GPM: initial payment
Hi, Gil

We need bank APY because payment growth is on yearly basis, but compounding is monthly.
If payment growth is also on a monthly basis, we don't need effective rate.

lua> s, i, pv = 1.075, 0.01, 6e4
lua> USPV = fn'i,n: -expm1(log1p(i)*-n) / i' -- = 1 / cn
lua> s1 = tvm(12, nil, -1, 0, s) -- APY to monthly rate

q = (1+s1)/(1+i) --> q-1 = (s1-i)/(1+i)

pv/pmt = (1 + q + q^2 + ... + q^59) / -c1 + q^60 / -c300

lua> tvm(60, (s1-i)/(1+i), USPV(i,300), USPV(i,1), nil) -- = pv/pmt
-128.065884851857
lua> pv / _ -- = pmt
-468.50884659412856
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 - Albert Chan - 05-30-2024 12:24 AM
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: 3 Guest(s)