pv

Present value of an investment.

Syntax

v = pv(rate, nper, pmt, fv, type)

Description

Returns the present value (today’s lump-sum equivalent) of an investment that has periodic payment pmt and future value fv over nper periods at periodic rate rate.

Example

pv(0.05/12, 30*12, -1500)    % loan amount that supports $1500/mo

See also

• fv — Future value of an investment.
• pmt — Periodic payment for a loan or annuity.
• npv — Net present value of a stream of cash flows.