How to Calculate PVIF in Excel

April 9, 2026

Almost every financial calculation you'll ever do — valuing a bond, discounting a future cash flow, deciding whether a lump-sum payout beats an installment plan — rests on the same small number: the Present Value Interest Factor (PVIF). It tells you what one dollar received at some future date is worth today, given an interest (or discount) rate. Multiply it by any future amount and you get that amount's present value.

This guide covers what PVIF actually represents, the closed-form formula, how to type it into Excel, how to cross-check the result against Excel's built-in PV function, and how PVIF relates to the discount factor used in DCF analysis.

What PVIF Actually Measures

PVIF is the present value, today, of $1 received at the end of $n$ periods, assuming a constant per-period discount rate $r$ .

Because it is defined on a $1 future payment, it is a pure multiplier. If you know the PVIF for a given rate and horizon, the present value of any single future amount at that rate and horizon is simply:

\text{Present Value} = \text{PVIF}(r, n) \times \text{Future Amount}

Two things to pin down before using it:

The rate and the period must match. If you are discounting a cash flow received in 24 months and you have an annual rate, either convert the rate to monthly (annual / 12) or leave the rate annual and use n = 2 years. Mixing them is the most common mistake.
PVIF applies to a single future cash flow. If you need the present value of a stream of equal future payments, you want PVIFA (the annuity version), not PVIF. For an irregular stream, discount each cash flow with its own PVIF and add them up.

The PVIF Formula

The closed-form expression is:

\text{PVIF}(r, n) = \frac{1}{(1 + r)^{n}}

Where:

$r$ is the discount rate per period (e.g., 5% per year as 0.05).
$n$ is the number of periods until the cash flow arrives.

The intuition: $1 today, invested at rate $r$ , compounds to $(1 + r)^{n}$ in $n$ periods. So $1 in $n$ periods must be worth exactly the reciprocal — $1 / (1 + r)^{n}$ — today. PVIF and the future value factor $(1 + r)^{n}$ are mirror images of each other.

One consequence worth noting: PVIF is always between 0 and 1 (for positive rates), shrinks toward 0 as $n$ grows, and shrinks faster when $r$ is larger. A 6% rate cuts a 30-year cash flow to about 17 cents on the dollar; a 10% rate cuts it to about 6 cents. Small differences in the discount rate compound into large differences in present value over long horizons — the single most important fact in DCF valuation.

Calculating PVIF in Excel

The Data You Need

All you need is two numbers: the per-period rate and the number of periods. Lay them out like this:

Cell	Contents
`A1`	`Rate`
`A2`	`0.05`
`B1`	`Periods`
`B2`	`2`
`C1`	`PVIF`
`C2`	(formula here)

Step-by-Step

Type the rate in A2. For an annual discount rate of 5%, enter 0.05. If you are discounting a monthly cash flow and have an annual rate, enter =0.05/12 instead — the rate must match the period.
Type the number of periods in B2. For a cash flow received in 2 years (with an annual rate), enter 2. For a cash flow received in 24 months (with a monthly rate), enter 24.
In C2, type the PVIF formula:
```
=1/(1+A2)^B2
```
Press Enter. For r = 0.05 and n = 2, Excel returns 0.9070 (to four decimal places). That is the PVIF.
Optional: compute the present value of an actual future amount. In D1 type Future Amount, in D2 enter the amount (say 1000). In E1 type Present Value, and in E2 enter:
```
=C2*D2
```
Excel returns 907.03, meaning $1,000 received two years from now is worth about $907.03 today at a 5% discount rate.

Excel worksheet with the PVIF formula in C2, a cross-check against the PV function, and the resulting present value for a $1,000 future amount — Excel worksheet computing PVIF from a per-period rate and number of periods, cross-checked against the built-in PV function

Cross-Checking With Excel's `PV` Function

Excel has a built-in function, PV, that computes the present value of a future cash flow directly, without going through PVIF. You can use it to verify your PVIF calculation.

In C4 type a label like PV check, and in C5 type:

=-PV(A2, B2, 0, 1, 0)

The arguments are:

rate — the per-period rate, same as A2.
nper — the number of periods, same as B2.
pmt — the periodic payment, 0 because we're valuing a single lump sum, not an annuity.
fv — the future value, 1 (the $1 that defines PVIF).
type — 0 for end-of-period (the default for discounting a single cash flow).

The leading minus sign flips Excel's cash-flow sign convention (inflows vs. outflows) so the result comes back as a positive factor. This should return 0.9070 — the same PVIF you computed from the closed-form formula. If the two differ, you almost certainly have a rate/period mismatch to track down.

A Worked Example: Discounting a Bond's Face Value

Suppose a zero-coupon bond pays $10,000 at maturity in 8 years, and the appropriate discount rate is 4% annually. What's it worth today?

Rate per period: 0.04
Periods: 8
PVIF: $\dfrac{1}{(1.04)^{8}} \approx 0.7307$
Present value: $0.7307 \times 10{,}000 \approx \$7{,}307$

If the bond is instead available for $7,000, you're getting a yield slightly better than 4% — enough of a clue to move on to computing the exact yield to maturity. PVIF is the starting point; it is what makes every subsequent bond and DCF calculation tractable.

PVIF and the Discount Factor

If you've read a DCF or bond-pricing textbook, you've probably seen the term "discount factor" (sometimes written as $DF_n$ or $d_n$ ). The discount factor for period $n$ is exactly PVIF:

DF_n = \text{PVIF}(r, n) = \frac{1}{(1 + r)^{n}}

They are the same number with different names. "PVIF" is the term textbooks use when teaching time value of money from a personal finance angle; "discount factor" is the term practitioners use when valuing bonds and building DCF models. When you discount a stream of future cash flows $C_1, C_2, \dots, C_n$ , you are really just multiplying each one by its corresponding PVIF and summing:

PV = \sum_{t=1}^{n} C_t \times \text{PVIF}(r, t)

That's the entire machinery of discounted cash flow valuation, compressed into a single line.

Common Mistakes

Rate/period mismatch. Using an annual rate with a number-of-months period count is the single most frequent error. If the cash flow arrives in months, either divide the annual rate by 12 and use the number of months, or keep the rate annual and use years (or fractions of a year).
Entering the rate as a whole number. 5 instead of 0.05 will give a nonsensical answer. Formatting the cell as a percentage does not change what you typed.
Confusing PVIF with PVIFA. PVIF discounts a single future cash flow. PVIFA (Present Value Interest Factor of an Annuity) discounts an equal-payment stream. Using PVIF where you needed PVIFA will understate the present value by a large margin.
Forgetting to match the rate to the risk of the cash flow. PVIF is mechanical — it does whatever you tell it to do with the rate. The judgment question is which rate. A risk-free cash flow should be discounted at a risk-free rate; a risky one at a higher rate that reflects that risk. Using too low a discount rate is the most common way DCF models overstate value.

Frequently Asked Questions

What is the difference between PVIF and PVIFA?

PVIF discounts a single future cash flow back to today. PVIFA (Present Value Interest Factor of an Annuity) discounts a stream of equal future cash flows. PVIFA is just the sum of PVIFs over all the periods in the annuity — mechanically, PVIFA(r, n) = PVIF(r, 1) + PVIF(r, 2) + … + PVIF(r, n).

What is the difference between PVIF and Excel's `PV` function?

They compute the same thing, but PV is an all-in-one function that takes a future amount directly and returns the present value, while PVIF is just the multiplier for $1. If you only need one answer, PV is faster. If you want to apply the same factor to several different future amounts — as in building a DCF model — computing PVIF once and multiplying is cleaner.

What rate should I use?

Match the rate to the cash flow. For a risk-free cash flow (e.g., a Treasury), use a Treasury yield of matching maturity. For a corporate cash flow, use a rate that reflects both the time value of money and the default/business risk — typically a corporate bond yield or the firm's weighted average cost of capital (WACC). Using a rate that's too low is the single most common way to overstate present value.

Do I need to use PVIF tables anymore?

No. Printed PVIF tables were useful before spreadsheets because the formula involves an exponentiation that is tedious by hand. With Excel, the closed-form expression takes one cell. Tables are still occasionally useful as a sanity check or for textbook problems.

Can I use PVIF for continuous compounding?

The standard PVIF formula assumes discrete compounding once per period. For continuous compounding, the analogous factor is $e^{-rn}$ , which in Excel is =EXP(-A2*B2). For small rates and short horizons the two are very close; they diverge as $r$ and $n$ grow. Most textbook and corporate DCF work uses discrete compounding; derivatives pricing typically uses continuous.

How does inflation fit in?

PVIF gives you a nominal present value if you use a nominal discount rate, and a real present value if you use a real (inflation-adjusted) rate. The rule is to keep nominal and real inputs in the same system: discount nominal cash flows with a nominal rate, or real cash flows with a real rate. Mixing them is a common source of error.