FV

Returns the future value of consistent payment amounts made at regular intervals at a constant interest rate.

Note: Interest rate calculation methods differ from country to country. This function calculates an interest rate based on U.S. interest rate standards.

Syntax

FV(n1, n2, n3)

Parameters

Parameter

Description

n1

A numeric value or expression representing the payment amount.

n2

A numeric value or expression representing the interest per period of the investment.

n3

A numeric value or expression representing the total number of payment periods.

The function returns an error if either of the following conditions are true:

  • Either of n1 or n3 are negative or 0.

  • n2 is negative.

    If any of the parameters are null, the function returns null.

    Note: FormCalc follows the IEEE-754 international standard when handling floating point numeric values. For more information, see Number literals.

Examples

The following expressions are examples of the FV function:

Expression

Returns

FV(400, 0.10 / 12, 30 * 12)

904195.16991842445. This is the value, after 30 years, of a $400 a month investment growing at 10% annually.

FV(1000, 0.075 / 4, 10 * 4)

58791.96145535981. This is the value, after 10 years, of a $1000 a month investment growing at 7.5% a quarter.

FV(Payment[0], Int_Rate / 4, Time)

This example uses variables in place of actual numeric values or expressions.

// Ethnio survey code removed