FV function for IBM Planning Analytics (TM1)

FV returns the future value of an annuity at the time of the last payment.

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

Where can the FV function be used?

Rules and TurboIntegrator

Which TM1 Server version is the FV function available for?

Version 11 and 12

What is the syntax for FV?

FV(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