loans / mortgage calculator

Hello,

I'm building a loan/mortgage broker site. I'm using formidable for and a couple of loan simulations (calculation) tools, where the visitor can play around with loanamount, period, .... when he has the right calculation, they can hit make a demand for this loan, and then they get an application/registration form (with more or less 500 fields). It's quite complex due to legislation, privacy rules,....

Now i have a calculation where the visitor fills in (for instance for a car loan, i can't use the car loan template formidable has in its offer, due to legislation and other needs in Belgium then what the template offers)

• price car
• downpayement
• calculated loan amount (price - downpayement)
• then dropdown with car age
  • new
  • between 3 and 5 years
  • older than 5 years
• the tool gives the APR (which are 6 fix APR that depends on the choices above, visitors cant fill out theire own APR)
• And 7 dropdown with loan payement period ( with a min and max period for different amount)
  • period 24,30months for 2500-3700€
  • 24,30,36 months for 3700-5600€
  • 24/30/36/42
  • 24/30/36/42/48
  • 24/30/36/42/48/60
  • 24/30/36/42/48/60/84
  • 24/30/36/42/48/60/84/12
• After making a choice of number of months, the calculator gives monthly payement (calculated) and total payement at the end of choosen number of months.
• Her starts my question, now i have 1 result. For instance for 4500€ the choice of period is between 24,30,36. the visitor chooses 36 months and the tool gives a calculated result a fix monthly payement for each of those 36months.

NOW WHAT I'M LOOKING FOR

i want to make the tool as such that the result is like described above, but besides i want to give a table with the

loan amount / car age / APR / PERIOD / calculated monthly payement

4500€ / new car / 3,24% / 24 months / calculation

4500€ / new car / 3,24% / 30 months / calculation monthly amount

4500€ / new car / 3,24% / 36 months / calculation monthly amount (this is the one result already calculated)

I hope i make myself clear, englisch is noth my best language neither is financial knowledge 😉

Now i gave the example for loan amount 4500 € but when the amount is for instance 12000€ the period is 24,30,36,42,48 months and the table will be larger.

I don't have a clue how to do this, can anybody help me please?