PV
Syntax:
PV ( rate , nper , pmt [ , [ fv ] [ , [ type ] ] ] )
Description: Computes the present value of an investment. (The present value is the total amount that a series of future payments is worth now.)
Mathematical Formula:
If rate is not 0, then:
If rate is 0, then:
(pmt * nper) + pv + fv = 0
Arguments:
Name |
Type |
Description |
||||||
---|---|---|---|---|---|---|---|---|
rate |
number |
The interest rate per period. |
||||||
nper |
number |
The total number of payment in an annuity. |
||||||
pmt |
number |
The payment made each period and cannot change over the life of the annuity. If is omitted, fv shall be provided.
Note: : Typically, pmt includes principal and interest but no other fees or taxes.
|
||||||
fv |
number |
The future value, or a cash balance to be attained after the last payment is made. If omitted, pmt shall be provided. |
||||||
type |
number |
The timing of the payment, truncated to integer, as follows:
|
Return Type and Value: number – The present value of an investment.
However, if type is any number other than 0 or 1, #NUM!
is returned.