Related Topics: | ||
Description: Returns the present value of a single investment, expense or revenue for a specific period.
Syntax: pvi(Rate, Period, future_value)
For a more complete description of the arguments in pvi and for more information on annuity functions, see the PV function.
Rate is the interest rate per period.
Period is the number of periods in 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.
future_value is the future value of the investment, expense or revenue. For example, if you want your investment to be worth $1,000 in the future, your future value is $1,000.
Remarks:
This function is the same as the PV 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:
pvi(0.05, 5, 1276.28)
Returns:
1000
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.