PV
Description
Returns the present value of an investment based on future payments and a constant interest rate.
Syntax
PV(
rate
,
nper
,
pmt
, [
fv
], [
type
])
- rate: The interest rate for each period.
- nper: The number of periods over the life of the investment.
- pmt: The payment made for each period.
- fv: The future value of the investment after nper payments.
- type: The payment timing. 0 or Empty = the payment occurs at the end of the period; 1 = the payment occurs at the beginning of the period.