pv

Format: pv( pmt, rate, term )

Arguments: (real) pmt Periodic payment

(real) rate Periodic interest rate (1=100%)

(real) term Number of periods

Returns: (real) The present value of term periodic payments of pmt each discounted at a periodic interest rate of rate

Description: The present value is calculated using the following equation:

Examples: pv(2000,8%,20) = 19636.29 (present value of a 20 year $2,000 annuity at 8%)

See Also: fv, pmt, term, rate, npv, irr, cf