To calculate NPV with a discount rate, apply the formula NPV = Σ [Ct / (1 + r)^t] − C0: divide each year’s expected net cash flow (Ct) by (1 + r) raised to the power of that year, add the discounted amounts together, and subtract the upfront cost (C0). A positive result means the project earns more than the return you required when you chose the rate; a negative result means it falls short.
The Three Inputs You Need First
Before you touch the formula, pin down three numbers. Get any one of them wrong and the output is meaningless.
Initial investment (C0). The total cash leaving your account on day one. That includes the purchase price of equipment, installation, shipping, legal fees, and any permits or licenses needed before operations begin. If you buy machinery for $80,000 and pay $12,000 to install it, C0 is $92,000. Anything you forget here inflates the NPV and makes the project look better than it is.
Projected cash flows (Ct). The net cash the project is expected to generate in each future period, usually measured annually. Net is the key word: start with revenue, subtract operating costs, and you’re left with the cash that actually hits the bank. Non-cash entries like depreciation get added back, because they reduce the tax bill without consuming cash. A common shortcut formula is EBIT × (1 − tax rate) + depreciation.
The discount rate (r). The minimum return you require to justify tying up capital in this project instead of putting it somewhere else. This is the most consequential number in the whole calculation. A project that looks strong at 8% can look terrible at 12%, so choose the rate deliberately and be ready to test it. Most companies use their weighted average cost of capital, but any defensible hurdle rate works as long as you apply it consistently.
One consistency rule matters here. If your cash flows are built with inflation baked in, use a nominal discount rate. If they’re stated in constant, inflation-adjusted dollars, use a real rate. Mixing the two systematically distorts the answer. The Fisher equation links them: (1 + nominal) = (1 + real) × (1 + inflation).
The Formula and What Each Piece Does
With the inputs assembled, the formula is:
NPV = Σ [Ct / (1 + r)^t] − C0
Each piece does one job. Ct is the net cash flow in year t. The term (1 + r)^t grows exponentially as t gets larger, so cash flows further in the future are divided by a bigger number and are worth less in today’s terms. The summation symbol (Σ) tells you to repeat the discounting for every year of the project and add the results. Then you subtract C0 to account for what you spent upfront.
The intuition is simple. A dollar received five years from now is worth less than a dollar in hand today, because today’s dollar could be invested and earning returns during those five years. The discount rate quantifies exactly how much less each future dollar is worth.
A Worked Example, Year by Year
Say you’re evaluating a project that costs $100,000 upfront and is expected to produce the following after-tax cash flows across four years, with a 10% discount rate.
- Year 1: $30,000
- Year 2: $40,000
- Year 3: $50,000
- Year 4: $35,000
Step 1: Discount Each Cash Flow
Convert the rate to decimal form and add one: 0.10 + 1 = 1.10. Raise that base to the power of each year and divide the cash flow by the result.
- Year 1: $30,000 / (1.10)^1 = $30,000 / 1.10 = $27,272.73
- Year 2: $40,000 / (1.10)^2 = $40,000 / 1.21 = $33,057.85
- Year 3: $50,000 / (1.10)^3 = $50,000 / 1.331 = $37,565.74
- Year 4: $35,000 / (1.10)^4 = $35,000 / 1.4641 = $23,905.47
Notice how Year 3’s $50,000 shrinks to about $37,566 in present-value terms. That’s the discount rate doing its job. The further out the cash flow, the heavier the haircut.
Step 2: Sum the Present Values
Add the four discounted amounts: $27,272.73 + $33,057.85 + $37,565.74 + $23,905.47 = $121,801.79. That’s the total present value of the project’s future earnings.
Step 3: Subtract the Initial Investment
$121,801.79 − $100,000 = $21,801.79. The NPV is positive, which means the project is expected to earn more than the 10% return you required.
Running the Calculation in a Spreadsheet
Few people in practice do this arithmetic by hand. Spreadsheets handle it in seconds, but there’s a trap in Excel and Google Sheets that catches people constantly. The built-in NPV function treats the first value you give it as a cash flow at the end of period one, not at time zero. If you feed it the initial investment as the first value, the function discounts that cost by one period, understating it and inflating your answer.
The fix is simple. Leave the initial investment out of the NPV function and subtract it separately. In Excel, the formula looks like =NPV(rate, Year1:YearN) + C0, where C0 is entered as a negative number. If your cash flows happen at irregular intervals instead of neatly at year-end, use XNPV instead; it accepts a specific date for each cash flow and returns a more precise result.
What a Positive, Negative, or Zero NPV Means
A positive NPV means the present value of the future cash flows exceeds the cost, so the project is expected to create wealth above your required rate of return. The dollar amount tells you how much value the project adds in today’s terms. In the example above, the $21,802 NPV means the project is worth roughly $21,802 more than it costs, after accounting for the time value of money.
A negative NPV means the project falls short of your required return. That isn’t the same as losing money in an accounting sense. It means the return isn’t high enough to compensate for the risk and opportunity cost of the capital. An NPV of zero means the project earns exactly the discount rate, no more and no less.
A few things NPV won’t tell you. It won’t capture strategic benefits like entering a new market, building a brand, or blocking a competitor. It won’t flag risks that don’t appear in the cash flow forecast, like regulatory changes or key-person dependencies. And the whole answer depends on the rate you chose. Treat NPV as the most important input to a capital decision, not the only one.
Stress-Testing the Discount Rate
Because the discount rate drives the result so heavily, run the calculation at more than one rate before you commit. Compute NPV at your base-case rate, then at rates one or two percentage points higher and lower. If a two-point increase flips your NPV from positive to negative, the project’s viability depends heavily on the cost of capital staying low. That’s useful information you won’t get from a single number.
Do the same with the cash flow projections themselves. What if revenue comes in 15% below forecast? What if operating costs run 10% higher? A short table showing NPV under optimistic, base, and pessimistic assumptions turns a point estimate into a range. Projects that stay positive across most scenarios are meaningfully safer than projects that need everything to go right.
When a Project Runs Beyond Your Forecast Window
Many projects keep producing cash well past the last year you’ve projected. A factory built today might run for decades. When that’s the case, add a terminal value to capture cash flows beyond the explicit projection period. The most common approach is the perpetual growth model: estimate the cash flow for year n+1 and divide it by the difference between the discount rate and a long-term growth rate, so Terminal Value = Cash Flow in Year n+1 / (r − g). The growth rate (g) should be modest, because no business grows faster than the overall economy forever; analysts typically use a figure between 1% and 3%.
Treat the terminal value like any other future cash flow. Discount it back to today by dividing by (1 + r)^n, then add it to the sum of your explicitly forecasted present values. In long-horizon projects, the terminal value often ends up being a large share of total NPV, so small changes to the growth assumption can move the final number significantly. Stress-test it the same way you stress-test the discount rate.