Financial
PV Function in Excel
Returns the present value of an investment - the total amount that future payments are worth now.
Syntax
- =PV(rate, nper, pmt, [fv], [type])
Arguments
- rate (required): Interest rate per period
- nper (required): Total number of payment periods
- pmt (required): Payment made each period
- fv (optional): Future value (default 0)
- type (optional): 0=end of period, 1=beginning (default 0)
Examples
- =PV(5%/12, 60, -500) - Present value of $500/month for 5 years at 5% - Result: $26,498
- =PV(8%, 10, 0, -100000) - Amount to invest now for $100K in 10 years - Result: $46,319
Excel PV function documentation
- PV returns the present value of an investment — current worth of future cash flows at a discount rate.
- Syntax: =PV(rate, nper, pmt, [fv], [type]). Used in loans, annuities, and lease NPV shortcuts.
- Sign convention: cash outflows negative, inflows positive — stay consistent with [FV](/functions/fv/) and [PMT](/functions/pmt/).
- Related: [FV](/functions/fv/), [PMT](/functions/pmt/), [NPV](/functions/npv/), [RATE](/functions/rate/).
PV syntax and arguments
- rate: interest rate per period — annual rate divided by 12 for monthly nper.
- nper: total number of payment periods.
- pmt: payment each period — often negative for loan payments as outflow.
- fv optional: future value lump sum at end; type 0 = end of period, 1 = beginning.
Step-by-step: present value of annuity
- Step 1 — Annual discount 8% in E1, 10 years, $5000/year payment.
- Step 2 — =PV(E1, 10, -5000) — payment negative as outflow from investor view.
- Step 3 — Result is amount you'd pay today for that stream.
- Step 4 — Compare projects by PV at same rate — higher PV preferred for inflows.
- Step 5 — Cross-check with [NPV](/functions/npv/) on explicit yearly row list.
PV vs NPV vs FV
- PV — constant periodic payment annuity formula.
- NPV — arbitrary uneven cash flow list.
- FV — future worth of present + payments.
- Category: [Financial functions](/categories/financial/).
Worked examples to copy
- Loan PV: =PV(5%/12, 360, -1000) monthly mortgage style.
- Lump sum FV: =PV(0.06, 5, 0, -10000) present worth of future 10k.
- Beginning period: =PV(rate, nper, pmt, fv, 1).
- Display: format as currency after formula.
People also ask
- PV negative result? — Sign convention — flip pmt/fv signs consistently.
- PV vs loan amount? — PV computes present value; PMT computes payment.
- PV monthly rate? — Divide annual rate by 12 when nper is months.
- PV #NUM!? — Invalid rate or nper combination.
Common errors
- Use negative for payments you make, positive for payments you receive
Use cases
- Loan valuation
- Investment analysis
- Retirement planning
- Annuity valuation
Frequently asked questions
- What is PV (Present Value) in Excel? PV calculates what future money is worth today. $1,000 received in 5 years is worth less than $1,000 today due to time value of money. PV discounts future cash flows to their current equivalent value.
- How do I calculate how much to invest now for a future goal? Use PV with fv parameter: =PV(rate, years, 0, -goal). For $100,000 in 10 years at 7%: =PV(7%, 10, 0, -100000) = $50,835. You need to invest $50,835 today to have $100,000 in 10 years.
- Why does PV return a negative number? PV uses cash flow sign convention: negative = money out, positive = money in. If you're calculating what to pay for an investment (money out), result is negative. Use ABS() or negate if you want positive: =-PV(...).
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.
When to use PV
- Loan valuation — common Financial scenario for PV.
- Investment analysis — common Financial scenario for PV.
- Retirement planning — common Financial scenario for PV.
- Annuity valuation — common Financial scenario for PV.
PV in the Financial category
- Browse all Financial functions at /categories/financial/ for related formulas.
- PV syntax: =PV(rate, nper, pmt, [fv], [type])
- rate (required): Interest rate per period
- nper (required): Total number of payment periods
- pmt (required): Payment made each period
- fv (optional): Future value (default 0)
- Confirm PV arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
Formula checklist before you copy down
- Confirm PV arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
- If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
- Spot-check three known input rows manually against expected output.
Related Excel functions
- FV (/functions/fv/): Returns the future value of an investment based on periodic, constant payments and a constant interest rate.
- NPV (/functions/npv/): Calculates the net present value of an investment based on a discount rate and future cash flows.
- PMT (/functions/pmt/): Calculates the payment for a loan based on constant payments and a constant interest rate.
- RATE (/functions/rate/): Returns the interest rate per period of an annuity.
Errors to watch for
- Use negative for payments you make, positive for payments you receive — review causes on linked error pages in the directory.
Copy-paste audit workflow
- Enter PV on three test rows with known expected output documented on a QA tab.
- Fill down only after absolute references are locked on lookup tables and rate tables.
- Compare against manual calculation or a calculator for financial and statistical functions.
- Search this directory for comparison guides when choosing between similar functions in the same category.
PV worked examples to copy
- =PV(5%/12, 60, -500) — Present value of $500/month for 5 years at 5%. Expected result: $26,498.
- =PV(8%, 10, 0, -100000) — Amount to invest now for $100K in 10 years. Expected result: $46,319.
PV reference summary for crawlers and offline review
- PV belongs to the Financial category in Excel. Returns the present value of an investment - the total amount that future payments are worth now.
- Full syntax: =PV(rate, nper, pmt, [fv], [type]). Open /functions/pv/ for parameters, FAQs, and related pages.
- Common mistakes: Use negative for payments you make, positive for payments you receive
- Pair this function with comparison guides when another Excel formula might fit the same task better.
- Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.