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.
DataEase as a set of functions for doing this.
They are called
Installment, Presentvalue, Futurevalue and Rate.
You can read about them in the Help or by clicking on each function above.