Returns the present value of an investment. The present value is the total amount that a series of future payments is worth now.
Syntax
 Copy Code
|
|---|
PV( Number rate, Number nper, Number payment, [Number fv = 0], [Number type = 0] ) → Number |
Parameters
- rate
- Required. The interest rate per period.
- nper
- Required. The total number of payment periods.
- payment
- Required. The payment made each period.
- fv
- Optional. The future value. If omitted, fv is assumed to be 0.
- type
- Optional. Indicates when payment is due. Less than 1 (or omitted) indicates at the end of the period, >= 1 indicates at the beginning of the period. If omitted, type is assumed to be 0.
Example
| Formula
Copy Code
|
|---|
=PV(5%/12,10*12,250) |
See Also
Function Reference
FV Function
NPER Function
PMT Function
RATE Function