Simplicty and flexibility!


Mortgage Calculator


Started by Bolt-on-Trailers
Search
You will need to Sign In to be able to add or comment on the forum!

Mortgage Calculator

Does anyone know the (Payment) field derivation formula to calculate a mortgage payment? Common fields would be a follows.

Loan Amount:
Term:
Interest Rate:
Payment:


There are numerous mortgage calculators online but I was hoping to make my own with DataEase.
Thanks for your help.


Written by Bolt-on-Trailers 29/06/18 at 07:27:00 Dataease [{8}]FIVE

Re:Mortgage Calculator

DataEase as a set of functions for doing this.

They are called

InstallmentPresentvalue, Futurevalue and Rate.

You can read about them in the Help or by clicking on each function above.


Written by DataEase 29/06/18 at 12:06:04 Dataease [{8}]FIVE