Debarati Debarati - 1 year ago 398
Java Question

Excel PMT function in Java

I want to implement PMT function (from Excel) in Java. The formula of the PMT function is:



  • D7 = Finance Amount

  • D9 = Rate

  • D11 = Term

For example

D7 = $1,00,000,
D9 = 10%,
D11 = 36

Here the output of PMT function i.e. monthly payment will be

Please anyone help me to calculate this function value in Java.

Answer Source

assuming all variable of double type:

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download