title: Excel PMT function in Java
body: <p>I want to implement PMT function (from Excel) in Java. The formula of the PMT function is:</p>
  
  <pre><code>(D7*D9/12)/(1-(1+D9/12)^(-(D11/12)*12))
  </code></pre>
  
  <p>where:</p>
  
  <ul>
  <li>D7 = Finance Amount</li>
  <li>D9 = Rate</li>
  <li>D11 = Term</li>
  </ul>
  
  <p>For example</p>
  
  <pre><code>D7 = $1,00,000,
  D9 = 10%,
  D11 = 36
  </code></pre>
  
  <p>Here the output of PMT function i.e. monthly payment will be <code>$3,226.72</code></p>
  
  <p>Please anyone help me to calculate this function value in Java.</p>