#Financial mathematics - annuities and loans please help

4 messages · Page 1 of 1 (latest)

haughty moth
mellow juniperBOT
#
  1. Wait patiently for a helper to come along.
  2. Once someone helps you, say thank you and close the thread with:
+close
  1. Feel free to nominate the person for helper of the week in #helper-nominations
  2. Do not ping the mods, unless someone is breaking the rules.
  3. If you're happy with the help you got here, and the server overall, you can contribute financially as well:
buoyant veldt
# haughty moth

Let's try solving this generally.
Suppose the initial amount is N0, the rate each month is p and the payment each month is n.
I assume the interest happens before the payment. Then we have:
N(t + 1) = (1 + p)N(t) - n, N(0) = N0
Solving this recurrence relation gives:
N(t) = (n - (n - pN(0))(1 + p)^t)/p
Suppose the total payment period is T. Then:
N(T) = (n - (n - pN(0))(1 + p)^T)/p = 0
From here we get:
n = pN(0)/(1 - (1 + p)^(-T))
In our case, the given interest p' is annual. For it we have:
p = (1 + p')^(1/12) - 1
So:
n = ((1 + p')^(1/12) - 1)N(0)/(1 - (1 + p')^(-T/12))