View Single Post
Old 04-20-2004, 10:04 AM   #7 (permalink)
Yakk
Wehret Den Anfängen!
 
Location: Ontario, Canada
Me, Maple and a friend of mine got it.

Time = ln((payment_rate+goal*interest_rate)/(payment_rate+start*interest_rate))/interest_rate

where
"goal" is your desired goal (saving goal or pay-off-debt goal).
"interest_rate" is your interest rate per period of time (compounded instantly, which is wierd[1]).
"payment_rate" is your payment rate per period of time.[2]
"start" is the start state (how much money you have saved up, or how deep your debt is. Debt is negative.)
"Time" is the number of periods of time it will take.

By plugging numbers into this, you will get ballpark values for real-life loan repayment times and the like. It won't be accurate, because in the real world you only make payments every month, and interest doesn't work quite the same.

Footnotes:
[1] if you take 12% yearly interest, and you compound it every month, you get 1% per month. This works out to 12.68% interest over a year. If you compound every instant, you end up with something like 13% interest.

[2] Ie, if your period of time is years, your interest rate and the units the answer is in will also be in years.

A prettier version:
Define X to be:
X =
payment_rate+goal*interest_rate
-------------------------------------------
payment_rate+start*interest_rate

Then the amount of time it takes to pay off your loan is:
ln(X)/interest_rate

Example:
you have 10,000 in debt at 9% interest/year. You are paying 4800/year to pay off the debt.

Your goal is 0$ of debt. You start at -10000.

X = (4800 + 0*0.09)/(4800 + -10000*0.09)
X = 1.23

So, it will take about:
ln(1.23)/0.09
or 2.3 years to pay off your debt.

Testing against the morgage equation from a few posts ago. . .
28 monthly payments, about .8% monthly interest, initial debt of 10000.

Payment per month =
0.008*10,000*(1.008)^28)/((1.008)^28-1)
= $400.06

sweetness, it worked!

Edit:
If you care, the rate of change of the repayment time, with respect to the payment rate, is:
(start*interest_rate - goal*interest_rate)/interest_rate
*
1
--------------------------------------------------------
(payment_rate+goal*interest_rate)(payment_rate+start*interest_rate)

but I doubt you care much, and it may be wrong.
Edit2:

Best version of the formula yet!

First concept: surplus. This is
payment_rate - debt*interest_rate
basically, how much you are reducing the debt by.

So, if your interest payments are 100$, and you are putting 400$ down on the debt, your surplus is 300$.

If your interest payments are 0$ and you are putting 400$ down on the debt, your surplus is 400$.

then, the amount of time it takes to pay off the debt is:
ln(desired_surplus)-ln(current_surplus)
--------------------------------------------------
interest_rate


Note you have to calculate the interest rate per payment period, not the annual interest rate.

To pay off the debt, you want the desired surplus to be the entire payment.

Example:
Your interest payments are 100$. You are paying 200$ a month to pay off the debt. Interest rates are 1%/month.

Time to pay off it:
ln(200)-ln(100)
------------------
0.01

which is 69.3 months, or about 5 years 10 months.
__________________
Last edited by JHVH : 10-29-4004 BC at 09:00 PM. Reason: Time for a rest.

Last edited by Yakk; 04-21-2004 at 07:51 AM..
Yakk is offline  
 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360