The IPMT function in Excel calculates the interest portion of a loan between 2 dates. Is this a closed loop formula? Or are the payments projected and the interest summed up?

I need to implement such a function in Python and hoping there is a more elegant approach compared to projecting the payments and summing it up.

  • 1
    $\begingroup$ This post answers.microsoft.com/en-us/msoffice/forum/all/… has closed formulas, but I haven't checked them so I don't know if they are accurate $\endgroup$ – Alex C Mar 16 '19 at 16:06
  • $\begingroup$ I'm sure that's right, but will check, thanks $\endgroup$ – Kritz Mar 16 '19 at 18:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.