FVLUMPSUM( ) function

Returns the future value of a lump sum after a number of periods.

Syntax

FVLUMPSUM(rate, periods, amount)

Parameters

rate

Numeric. The interest rate per period.

periods

Numeric. The total number of periods.

amount

Numeric. The payment made at the start of the first period.

Output

Numeric.

Remarks

Use this function to determine the future value of an investment. The future value is the total value of an amount in the future with compound interest. For example, when you put a lump sum in the bank and leave it to collect interest for a period of time, the ending bank balance is the future value.

The result is returned to two decimal places.

Example

To calculate the future value after 12 months of a $1000 deposit that earns 1% per month:

FVLUMPSUM(0.01, 12, 1000)

returns 1126.83.



(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback