<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>
Cubewise EDU
ConsultingEducationSoftwareKnowledge HubSupportCompany
global-search

PV function for IBM Planning Analytics (TM1)

    PV returns the initial or principal value of an annuity. 

    In this video, PV 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 PV function be used?

    Rules and TurboIntegrator

      Which TM1 Server version is the PV function available for?

      Version 11 and 12

        What is the syntax for PV?

        PV(payment, interest, periods)​

        • Payment = The amount of the payment made.​
        • 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