Returns the end-of-period present value for a series of future payments given, the interest rate, the number of periods, the payment amount, and the future value remaining after all payments are made
Syntax
|
|
Returns the end-of-period present value for a series of future payments given, the interest rate, the number of periods, the payment amount, and the future value remaining after all payments are made |
|
|
PV(rate, period, payment, futureValue) |
|
|
Arguments: |
|
|
|
rate |
Numeric - the interest rate |
|
|
|
period |
Numeric - the number of periods |
|
|
|
payment |
Numeric - the payment made each period |
|
|
|
futureValue |
Numeric - the future value remaining after all payments |
Remarks
- Example: PV(0.05, 36, -100, 0) returns 1654.685.
Comments
0 comments
Article is closed for comments.