For a new project (Real Estate Website), the client would like to have a mortgage calculator, similar to one he have seen on this site (click the link Mortgage Calculator half way the page).

I try to figure out what would be the best way of making something similar? To be honest, I don’t see how the figures, as given in the example, are build up?

On this particular property, I used a down payment of 10% (13.500) and left the mortgage period to the default 20 years.

I understand the calculation for the down payment ( price x (down payment / 100) )

Edit: this is solved. I made a stupid mistake with the amount for the down payment!

But, and maybe this is very stupid, I really don’t see how they come to the Amount Financed, in this case 18.090.000?

I have some problems figuring out how the monthly payments are calculated in the example of post #1 (Principal & Interest ONLY)

The figures are as follow:

Total Amount 135.000 €
Down Payment 10%: 13.500 €
Interest Rate: 4%
Amount Financed: 121.500 €

The monthly rate according to the example is 736 € but math is not my strongest point plus I never bought a house, so I don’t see how they come to this amount?

I tried to translate this into CF but without success. And since I’m using CF to build the calculator I thought I might as well ask the question here. If you can point me to the right forum, that’s okay for me as well

I did a type of mortgage calculator for my office, and I use cfscript for the calculations. Seems I’m a bit late though, since you already found a solution.