Calculate Present Value
Determine the current worth of a future sum of money.
Inputs
rateInterest rate per period.nperTotal number of payment periods.pmtPayment made each period.
Practical Example
=PV(0.08, 10, 0, 10000)
One-Click Copy
PV(rate, nper, pmt, [fv], [type])
Copy
Quick context
- • Works in both Excel and Google Sheets.
- • Use when you need consistent, auditable results.
- • Copy the snippet above and adjust only the ranges.
When to use
Calculates the present value of a loan or an investment, based on a constant interest rate.
Determine the current worth of a future sum of money.
Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.