Summary

The Excel PV function returns present value, which is the value today of a future payment stream or future target amount under a stated interest or discount rate. Microsoft positions PV as one of the core time-value-of-money functions, and it is widely used when a worksheet needs to express future cash assumptions in current-value terms.

PV is useful in both valuation and funding questions. It can answer how much a future annuity is worth today, or how much must be invested now to reach a future target balance.

The function depends heavily on correct assumptions. Rate, number of periods, timing, and sign convention must all be internally consistent or the result will be interpreted incorrectly even if the formula itself is syntactically valid.

Syntax

=PV(rate, nper, pmt, [fv], [type])

rate is the interest or discount rate per period, nper is the total number of periods, and pmt is the recurring payment. Optional fv is the desired future balance, while type indicates whether payments occur at the end of each period (0) or at the beginning (1).

As with other annuity functions, the units must match. Monthly models require monthly rates and monthly period counts. That is why a 5-year monthly annuity at 8% is written with 0.08/12 and 60.

Arguments

• rate - Interest or discount rate per period.
• nper - Total number of periods.
• pmt - Payment made each period.
• fv - [Optional] Future value, or desired ending balance.
• type - [Optional] Payment timing. Use 0 for end-of-period payments and 1 for beginning-of-period payments.

PV is easiest to interpret when the workbook states clearly whether the result is being treated as a required funding amount, an asset value, or a liability-side present value. The mathematics is the same, but the sign and economic meaning differ by context.

PV vs Related Functions

PV solves today's value. Other time-value functions in the same family solve related questions from the same financial structure.

Use PV when the model is annuity-style and summarized by rate, term, payment, and optional future value. Use NPV when the worksheet stores separate cash flows by period.

Using the PV Function

PV is often used to decide whether a future payment stream is worth a stated price today. It can also be used in reverse, where the future target is known and the worksheet needs to solve the amount that must be funded at the present date.

Because PV is a discounted value, it reacts strongly to the chosen rate. A higher discount rate lowers present value, while a lower rate raises it. That sensitivity is one reason scenario analysis is useful when PV is supporting a decision.

• Use PV when the worksheet asks what a future stream or target is worth today.
• Document the discount-rate assumption clearly because it drives the result materially.
• Compare PV against a benchmark amount when the model needs a clear accept/reject or affordability conclusion.

Example 1 - Pension Plan Worth

This example values a 5-year monthly payment stream at an 8% annual rate. The payment is expressed as a monthly outflow from the payer's side, and PV returns the equivalent value today under those terms.

=PV(0.08/12,60,-500)

Example 2 - Target Savings Value

Here there is no recurring payment. Instead, PV solves the current lump sum required to reach $50,000 after 10 years at 8%. This is a clean example of present-value funding rather than annuity valuation.

=PV(0.08,10,0,50000)

Example 3 - Investment Limit Check

A direct comparison against a capital limit turns the PV output into a feasibility rule. This is useful when a worksheet needs to show not only the valuation but also whether it fits within a funding constraint.

=PV(0.08/12,60,-500)<-25000

Example 4 - Compare PV with a Benchmark

Subtracting a reference amount from the absolute PV shows the gap between the model's valuation and a benchmark capital figure. That makes the output easier to discuss in budget or pricing terms.

=ABS(PV(0.08/12,60,-500))-25000

Conclusion Recap

• Summary: PV returns the present value of a future payment structure or target amount.
• Syntax: =PV(rate,nper,pmt,[fv],[type]).
• Core setup: Align period units, keep sign convention clear, and document timing assumptions.
• Best use: Valuation, funding analysis, affordability checks, and benchmark comparisons.