FUTURE_VALUE

Future value

Description
Calculates an annuity investment's future value. This is done based on a constant interest rate and periodic payments of constant amounts.
Function signature
FUTURE_VALUE(rate: Number, periods: Number, paymentamount: Number, presentvalue: Number, paymentsatthebeginningofperiod: Boolean) => Number
Parameter
Description
Rate
The interest rate
Periods
The number of payments to be made
Payment amount
The amount per period to be paid
Present value
The current value of the annuity. Default is 0.
Payments at the beginning of period
Whether payments are due at the end (false) or beginning (true) of each period
Examples
Formula
Return value
FUTURE_VALUE(0.1, 4, 100)
-464.1
FUTURE_VALUE(0.5, 4, 100)
-812.5
FUTURE_VALUE(0.5, 6, 100)
-2078.13
FUTURE_VALUE(0.5, 6, 100, 200)
-4356.25
FUTURE_VALUE(0.5, 6, 100, 200, true)
-5395.31

EFFECT

FUTURE_VALUE_SCHEDULE

Last updated 11 months ago

Formula	Return value
`FUTURE_VALUE(0.1, 4, 100)`	`-464.1`
`FUTURE_VALUE(0.5, 4, 100)`	`-812.5`
`FUTURE_VALUE(0.5, 6, 100)`	`-2078.13`
`FUTURE_VALUE(0.5, 6, 100, 200)`	`-4356.25`
`FUTURE_VALUE(0.5, 6, 100, 200, true)`	`-5395.31`

Parameter	Description
Rate	The interest rate
Periods	The number of payments to be made
Payment amount	The amount per period to be paid
Present value	The current value of the annuity. Default is 0.
Payments at the beginning of period	Whether payments are due at the end (false) or beginning (true) of each period