Related Topics: | ||
Description: Returns the future value of a single investment, expense or revenue for a specific future period.
Syntax: fvi(Rate, Period, present_value)
For a more complete description of the arguments in fvi and for more information on annuity functions, see the PV function.
Rate is the interest rate per period.
Period is the number of period for which you are making the investment or are receiving revenue. For example, if you will make a lump sum payment of $1,000 in three years for a settlement of an obligation, the period will be 3.
present_value is the current value of the investment, expense or revenue. For example, if you will make a lump sum payment of $1,000 today the present value will be $1,000.
Remarks:
This function is the same as the FV function with pmt = 0.
All parameter values can include:
Numerical values
Standard operands (+, -, *, /)
Predefined mathematical functions (exp, log, sin, etc.)
References to any analysis workbooks
Example:
fvi(0.05, 5, 1000)
Returns:
1276.281563
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.