PMT() versus CALCULATEPAYMENT()

  • Resolved gerikg

    (@gerikg)


    9 months, 1 week ago

    If I use

    from CFF prec(CALCULATEPAYMENT(252000,360,.07),2) I get $707.40
    from Google Sheet PMT(7%/12,360,-252000,0) I get $1,676.56

    why the difference?

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @gerikg

    Our CALCULATEPAYMENT operation interprets the rate in percentage. So, the correct would be:

    PREC(CALCULATEPAYMENT(252000,360,7),2)

    Or you can use the PMT operation in our plugin:

    PMT(7/12,360,-252000,0)

    Please note we are not allowed to support any customers in these forums and the “Financial Operations” module is distributed with the Developer and Platinum versions of the plugin.

    For pro or commercial product support please contact us directly on our site. This includes any pre-sales topics as well.

    Commercial products are not supported in these forums. We will happily answer this and any other questions you can have on our own site.

    Thank you.

Viewing 1 replies (of 1 total)
  • The topic ‘PMT() versus CALCULATEPAYMENT()’ is closed to new replies.