What Is Net Present Value (NPV)? Formula and How to Calculate It

Search Fintrev

Search our guides, reviews and glossary.

Net present value (NPV) is the difference between the present value of an investment’s expected future cash flows and the present value of what it costs, with every amount discounted at a chosen rate of return. The NPV formula turns cash that arrives in different years into today’s dollars, so inflows and outflows can be compared directly. A positive result means the investment is expected to earn more than the discount rate. A negative result means it is expected to earn less.

The discount rate is the minimum return the investor will accept. It usually reflects the cost of financing the project or the return available on another investment of similar risk. NPV answers a single question: after accounting for the time value of money and that required return, how much value does this investment add, in dollars, today?

The NPV Formula

Single cash flow

When a project costs money today and returns one cash flow at a future date, the formula is:

NPV = Cash flow / (1 + i)^t − Initial investment

where:

• i = the required return, or discount rate, per period
• t = the number of periods until the cash flow arrives

Multiple cash flows

Most projects produce cash over several periods. The general net present value equation adds up the discounted net cash flow of every period:

NPV = Σ [R_t / (1 + i)^t], summed from t = 0 to n

where:

• R_t = net cash flow in period t (inflows minus outflows for that period)
• i = discount rate, or the return that could be earned on alternative investments of comparable risk
• t = the period number
• n = the total number of periods

The initial investment sits at t = 0. Because (1 + i)^0 equals 1, it is not discounted; it simply enters the sum as a negative number. Every later cash flow is divided by a larger factor the further away it is. If the investment is spread over several periods (a building constructed over two years, for example), each outlay is discounted to its own date, just like the inflows.

How NPV Works: Discounting and the Time Value of Money

NPV rests on the time value of money: as long as interest rates are positive, a dollar received today is worth more than a dollar received later. A dollar in hand can be invested and earn a return in the meantime, and inflation reduces what a future dollar will buy. Even a cash flow certain to arrive must be discounted, because an equal sum held today could be earning interest while you wait.

Here is a hypothetical illustration. An investor is offered either $100 today or $105 one year from now. The $105 represents a 5% return for waiting. Whether that is a good deal depends on what else the investor could do with $100. If an equally risky alternative pays less than 5% over the year, waiting for $105 is worthwhile. If the investor could earn 8% with no risk, the $105 offer falls short. At an 8% discount rate, the $105 is worth $105 / 1.08 = $97.22 today, which is less than the $100 available now. The NPV of choosing to wait is −$2.78.

What a required rate of return tells you

The discount rate is the required rate of return, the standard the project is measured against. It can come from several sources:

• Cost of capital. A company often uses its weighted average cost of capital (WACC), the blended cost of its debt and equity financing. A project that earns less than this rate does not cover the cost of the money used to fund it.
• Opportunity cost. An investor may use the return available on an alternative investment of similar risk.
• A risk-adjusted hurdle rate. Riskier projects are typically assigned higher rates because their cash flows are less certain. Government bonds are generally treated as the near-riskless baseline, so investments riskier than Treasuries must offer a higher return to justify the risk. A company may apply a higher rate to a speculative new venture than to a routine equipment replacement. Using a single companywide rate for every project tends to favor risky projects and penalize safe ones.

The relationship between NPV and the discount rate

NPV moves in the opposite direction from the discount rate. Raising the rate increases the denominator (1 + i)^t for every future cash flow, which shrinks their present values while the up-front cost stays the same. When interest rates rise, the discount rates companies apply tend to rise with them, and projects that looked attractive can turn marginal or negative.

The effect is stronger for distant cash flows. Discounting a cash flow 10 years out at 12% instead of 8% cuts its present value far more, in percentage terms, than the same change applied to a cash flow one year out. Long-lived projects whose returns come late are therefore the most sensitive to the choice of rate.

How to Calculate NPV Step by Step

1. List every cash flow and its timing. Include the initial investment, operating inflows and outflows in each period, any additional investment along the way, and any salvage or resale value at the end.
2. Net the cash flows by period. For each period, subtract outflows from inflows to get one net figure.
3. Choose the discount rate and match it to the period length. An annual rate applies to annual cash flows. Monthly cash flows need a monthly rate (see below).
4. Discount each net cash flow. Divide each one by (1 + i)^t, where t is its period number.
5. Add up the discounted values. Include the initial investment as a negative figure at t = 0. The total is the NPV.

Converting an annual rate to a periodic rate

If cash flows arrive monthly or quarterly, the annual discount rate has to be converted to a compound periodic rate:

Periodic rate = (1 + annual rate)^(1 / periods per year) − 1

For an 8% annual rate and monthly cash flows: (1.08)^(1/12) − 1 ≈ 0.643% per month. Dividing 8% by 12 (0.667%) would overstate the monthly rate, because it ignores compounding within the year. The number of periods changes too: five years of monthly cash flows means 60 periods, not 5.

Example of Calculating NPV

The figures below are a hypothetical teaching example, not terms or results from any real company.

A business is considering a machine that costs $50,000 today. Management expects it to produce the following net cash flows, received at the end of each year, and no salvage value after year 4:

• Year 1: $15,000
• Year 2: $18,000
• Year 3: $20,000
• Year 4: $12,000

The company’s required rate of return for projects of this risk is 10% per year.

Step 1: The initial investment

The $50,000 is paid at the start, at t = 0. No time has passed, so it is not discounted. It enters the calculation as −$50,000.

Step 2: The present value of future cash flows

Each year’s cash flow is divided by 1.10 raised to its year number:

• Year 1: $15,000 / 1.10 = $13,636.36
• Year 2: $18,000 / 1.21 = $14,876.03
• Year 3: $20,000 / 1.331 = $15,026.30
• Year 4: $12,000 / 1.4641 = $8,196.16

The present value of the inflows is $51,734.85.

Step 3: Net the two

NPV = $51,734.85 − $50,000 = $1,734.85

The project clears the 10% hurdle and adds about $1,735 of value in today’s dollars. Note what the undiscounted numbers would have suggested: the inflows total $65,000, an apparent $15,000 gain. Most of that apparent gain is the compensation the company requires for tying up $50,000 for four years at 10%.

What happens at a higher discount rate

Run the same cash flows at 12%:

• Year 1: $15,000 / 1.12 = $13,392.86
• Year 2: $18,000 / 1.2544 = $14,349.49
• Year 3: $20,000 / 1.404928 = $14,235.61
• Year 4: $12,000 / 1.573519 = $7,626.22

Present value of inflows: $49,604.18. NPV = −$395.82.

Two percentage points on the discount rate turned an acceptable project into one that destroys value at the required return. The rate at which NPV equals exactly zero lies between 10% and 12%, and that rate is the project’s internal rate of return.

Adding salvage value

If the machine could be sold for $5,000 at the end of year 4, that amount would be added to the year 4 cash flow before discounting. At 10%, it would add $5,000 / 1.4641 = $3,415.07 to the NPV, raising it to $5,149.92. Ignoring a real residual value understates NPV; assuming one that never materializes overstates it.

Interpreting NPV: Positive, Negative and Zero

• Positive NPV: The investment is expected to earn more than the required return, and the NPV figure is the estimated value added beyond that return.
• Negative NPV: The investment is expected to earn less than the required return. That does not necessarily mean it loses money in absolute terms: in the 12% example the machine still returns more cash than it costs; it just does not earn 12%.
• Zero NPV: The investment earns exactly the discount rate. It covers the cost of capital but adds nothing beyond it.

This leads to the net present value rule: accept investments with a positive NPV and reject those with a negative NPV. When projects are mutually exclusive (only one can be chosen, such as two designs for the same factory), the rule favors the one with the higher NPV, because it is expected to add the most value. When capital is limited and several positive-NPV projects compete for the same budget, the dollar figure alone is not enough, which is covered in the limitations below.

Calculating NPV in Excel

Spreadsheets are the most common way to calculate NPV, especially with many periods. Excel’s function is:

=NPV(rate, value1, [value2], …)

Excel’s NPV function assumes the first value it receives arrives at the end of period 1 and discounts it accordingly. If you include the t = 0 investment inside the function, Excel discounts it by one period and understates the cost. The standard approach keeps the initial investment outside:

=NPV(rate, future cash flows) + initial investment

For the example above, with −50,000 in cell B1 and the four inflows in B2:B5:

=NPV(10%, B2:B5) + B1

This returns 1,734.85.

The NPV function also assumes equal spacing between cash flows. For cash flows on irregular dates, Excel’s XNPV function takes a list of values and a matching list of dates and discounts each one by the actual time elapsed. Google Sheets offers the same functions with the same conventions. Financial calculators handle NPV through a cash flow worksheet, where the t = 0 amount is entered separately from the later flows.

What Is NPV Used For?

Capital budgeting. Companies use NPV to decide whether to buy equipment, build plants, launch products, enter markets or acquire other businesses. It compares a project’s projected return with the hurdle rate required for approval, and it lets managers rank projects on a common, time-adjusted basis.

Valuing companies and securities. Applied to a business, the same calculation is called discounted cash flow (DCF) analysis. An analyst projects a company’s future free cash flows, discounts them, and compares the result with the price of the shares or of the whole firm, often measured as enterprise value. Warren Buffett has described valuing businesses this way, estimating the present value of future cash flows and comparing it with the current price.

Comparing financial choices. NPV applies to any decision with cash flows spread over time: leasing versus buying, refinancing debt, choosing between a lump sum and a stream of payments, or evaluating a rental property.

Real estate and project finance. Property investors discount expected rents and an eventual sale price. Lenders and sponsors of infrastructure projects discount long streams of tolls, fees or contract payments.

Limitations of NPV

It depends entirely on estimates. Future cash flows, the project’s life, salvage value and the discount rate are all assumptions. An NPV is only as reliable as those inputs, and small changes can flip the sign, as the 10% versus 12% example shows. Analysts often run sensitivity tests or scenarios (base, optimistic, pessimistic) rather than relying on a single figure.

The discount rate is a judgment call. Two analysts evaluating the same project can reach different conclusions simply by choosing different rates. A single rate also assumes the project’s risk stays constant over its life.

It ignores scale. NPV is a dollar amount, not a rate. Consider two hypothetical options: Option A has an NPV of $100,000 and Option B an NPV of $1,000. A looks better until you learn A requires $1 million up front and B costs $10. For anyone with finite capital, the return per dollar invested matters. The profitability index (present value of inflows divided by the initial investment) measures it. In the machine example at 10%, it is $51,734.85 / $50,000 ≈ 1.03.

It leaves out nonfinancial factors. Strategic fit, brand effects, regulatory risk, employee impact and flexibility (the option to expand, delay or abandon a project) are not captured unless someone translates them into cash flows.

Inflation must be handled consistently. Nominal cash flows, which include expected price increases, should be discounted at a nominal rate. Real cash flows, in constant dollars, should be discounted at a real rate. Mixing the two distorts the result.

NPV vs. Related Measures

NPV vs. PV

Present value (PV) is the value today of one future cash flow or a stream of them. NPV is PV net of cost: it subtracts the initial investment (and any other outflows) from the present value of the inflows. In the example, the PV of the machine’s cash flows at 10% is $51,734.85, and the NPV is $1,734.85. PV tells you what the future cash is worth now; NPV tells you whether paying the required price for it creates value. NPV is sometimes miscalled “net profit value,” but it is not an accounting profit figure. It is a discounted cash measure, and depreciation and other noncash items enter only through their effect on cash flows such as taxes.

NPV vs. IRR

The internal rate of return is the discount rate that makes a project’s NPV equal to zero. The two measures answer related but different questions. NPV asks: how much value, in today’s dollars, does this investment add at my required return? IRR asks: what annual rate of return does this investment produce? If the IRR is higher than the required rate, the NPV at that rate is positive. For a single, conventional project (one outflow followed by inflows), both lead to the same accept or reject decision.

They can disagree when ranking projects. IRR favors high percentage returns even on small projects, while NPV favors the largest dollar gain. IRR also assumes interim cash flows can be reinvested at the IRR itself, which may not be realistic. A three-year project with a high IRR offers that rate only for three years, and the capital may not earn as much once it is reinvested. Projects whose cash flows switch between negative and positive more than once can have several IRRs or none. For these reasons, corporate finance textbooks generally treat NPV as the primary decision rule for mutually exclusive projects.

NPV vs. payback period

The payback period measures how long it takes to recover the initial investment from cash inflows. In the example, the machine returns $15,000 in year 1 and $33,000 cumulatively by year 2, then recovers the remaining $17,000 during year 3, for a payback of about 2.85 years (assuming cash arrives evenly during the year).

Payback is simple and useful as a rough liquidity or risk screen, but it has two flaws. The standard version ignores the time value of money. And it ignores everything after the payback date: a project that pays back in two years and then stops is ranked ahead of one that pays back in three years and then produces cash for a decade. The discounted payback period fixes the first problem but not the second. NPV counts every cash flow over the project’s life.

NPV vs. ROI

Return on investment expresses gain as a percentage of cost, which makes it useful for comparing the efficiency of investments of different sizes. Basic ROI ignores timing: a 20% return earned over one year and a 20% return earned over five years look the same. NPV is generally preferred for capital budgeting because it measures value added in dollars after accounting for time and required return, while ROI is better suited to quick efficiency comparisons.

The Bottom Line

NPV matters to managers weighing capital projects, analysts valuing companies and anyone comparing choices with cash spread over time. Accept investments with a positive NPV and reject those with a negative one, but treat the figure as only as reliable as its cash flow estimates and chosen rate. Running scenarios and checking scale with the profitability index gives a sounder basis for decisions than relying on a single number.