I would like to visually discover how the monthly repayments of a given loan (for a given amount ; taking about a fixed rate loan) evolve in function of the total duration of the loan. I assume it is not a linear diminution, is it ? Same question regarding the cost of the credit. Any idea where I could find this data visualization ? thanks

  • 1
    Is this a question about data or about a financial formula? – whuber Dec 28 '11 at 20:00

Have a look this free website: http://www.loanfor.us/ (disclaimer: I am one of the developer behind this site).

Here you'll get interactive graphs concerning fixed rate loan. For example if you borrow 200.000 dollars with a 20 years term, with a fixed rate of 6%, the monthly repayment is constant and equals to 1.483 dollars / month.

But this constant sum is equals to principal repayment (in green) + interest repayment (in orange) + insurance repayment (constant in light blue). And indeed the curve principal vs. repayment is non-linear.

enter image description here

Btw, the site will shows other interesting graphs, such as:

  • the total credit cost function of the loan term (in red)
  • and the mensual repayment function of the loan term (in yellow)

enter image description here

| improve this answer | |
  • the mensual repayment function gets flat quite quickly !! – user1052753 Dec 30 '11 at 18:24
  • indeed, from 15 to 30 years the mensual repayment decreases slowly while the total credit cost increases more than linearly (it would be linear if the fixed rate was constant when the loan term increases, but actually the rate increases with the loan term). – Patrick from NDepend team Dec 30 '11 at 19:16

Nice website, although there are a few issues, that could be added.

  1. Factor in closing costs
  2. Comparison between two different options including closing costs
  3. Factor in tax savings by interest deduction and inflation

Here are some other choices (quick google search, no warranties) http://www.dinkytown.net/java/MortgageRefinance.html http://www.bestmortgage.com/Calc.html

Inflation is actually quite important and frequently overlooked. In the above graph, you can see that the total cost for 30 year looks pretty bad. However, assuming a 3% inflation rate, a $1000 are only $411 dollar in 30 years. So the question is is the "total credit cost" expressed in "today's" dollars in "dollars at the end of the term" or some undefined mixture thereof.

Here is a simple example calculator with inflation: http://ostermiller.org/calc/mortgage.html A 100k/4%/30year mortgage cost $171k total but only $129k in "today's" dollar assuming 2% inflation. If the inflation rate gets higher than the interest rate, you will actually be MAKING money.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy