fv Function

Description:
The future value of a periodic investment at a fixed interest rate.
Returns the solution for
fv
in the equation:
r=0: pv + c.n + fv = 0
r>0: pv.( 1 + r )**n + c.( 1 + r.b ).( ( 1 + r )**n - 1 )/r + fv = 0
where pv
present value
, fv
future value
, r
interest rate
, n
number of investment periods
, c
payment per period
, b=true
interest payable at the beginning of each period
, b=false
interest payable at the end of each period
.
Returns:
Number
Parameters:
Parameter
Data Type
Description
1
Number
The interest rate.
2
Whole Number
The number of investment periods.
3
Number
The amount invested in each period.
4
Number
The present value of the investment.
5
Boolean
Interest payable at the beginning of each period?
Examples:
When using functions inside a field, remember the field brackets:
{fv(BaseRate, InvestmentsPeriods, InvstmentAmount, CurrentValue, InterestPayable)}
Expression
Result
fv( 0.12, 12, -1000, 0, false )
24133.13
fv( 0.11, 35, -2000, 0, true )
758328.81
fv( 0.06, 12, -100, -1000, true )
3800.41

Related content