FValue

Use this function in an equation to calculate the future value of a payment, or series of payments, at a given future date when compounded by a given interest rate.

Syntax

where:

• OpeningSymName is a symbol in the dimension specified in a CalculationBlock statement, representing the original value of the investment at the beginning of the first time period.
• AddSymName is a symbol in the current dimension representing the additional amount invested on a regular basis through the investment period at the beginning of each time period (including the first period). It can be 0 or greater.
• Rate is a symbol in the current dimension representing the interest rate per time period. Type one of the following:

  Value	Description
  a value less than 1	Your system treats it as a decimal form of the percentage. For example, if you enter 0.05, it assumes 5 percent.
  a value greater than or equal to 1	Your system treats it as the intended percentage value. For example, if you enter 5, it assumes 5 percent.

• IncreaseSymName is a symbol in the current dimension representing a regular percentage increase in contribution each subsequent time period. For example, if AddSymName equals $100, with IncreaseSymName at 2 percent, the additional payment equals $100 in the first period, $102 in the second period, $104.04 in the third, and so on.
• NumPeriods is a symbol in the current dimension representing the number of time periods over which the investments will grow.

Note: Make sure you use consistent time periods for IntSymName and NumPeriods. For example, for annual payments on a five year loan bearing a 12 percent interest rate, NumPeriods would be 5 and IntSymName would be 12. For the same loan, if you make monthly payments, NumPeriods would be 60 (5 times 12) and IntSymName would be 1 (12 percent divided by 12).

Syntax example: