Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    PAYMT function for IBM Planning Analytics (TM1)

      PAYMT returns the payment amount of an annuity based on the principal amount, rate, and number of periods.

      In this video, PAYMT will be used to calculate the payment value of an annuity and apply it in the rule to populate the Product Scorecard cube. 

      Where can the PAYMT function be used?

      Rules and TurboIntegrator

        Which TM1 Server version is the PAYMT function available for?

        Version 11 and 12

          What is the syntax for PAYMT?

          PAYMT(principal, interest, periods)​

          • Payment = The principal amount.​
          • Interest = The interest rate.​
          • Periods = The number of periods in the annuity.

          Relevant Functions

          • FV = Returns the future value of an annuity at the time of the last payment
          • PAYMT = Returns the payment amount of an annuity based on the principal amount, rate, and number of periods
          • PV = Returns the initial or principal value of an annuity