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
-
Financial Functions
Format:
Article,
1 min read