PV
Returns the present value of an investment.
FinancialFinance & Accounting
What it does
Calculates the present value of a loan or investment.
Syntax
PV(rate, nper, pmt, [fv], [type])
Arguments
rate(number) — Interest rate.nper(number) — Periods.pmt(number) — Payment.
Examples
Present Value
PV of $500/mo for 5 years at 6%.
FORMULA
=PV(0.06/12, 60, -500)
RESULT
25862.78
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 25862.78 |