Free to Use

Net Present Value Calculator

What is the net present value of my investment? Find out instantly with our free NPV calculator. Calculate net present value, IRR approximation, payback period, and profitability index for any investment scenario with dynamic cash flow inputs.

Calculation completed successfully! โœ“
Please enter valid positive numbers in all fields.

Cash Flows by Year

Year Cash Flow ($)
Net Present Value
$0.00
Total value of cash flows today
Internal Rate of Return (IRR)
โ€”
Estimated annual return rate
Payback Period
โ€”
Years to recover investment
Decision
โ€”
Accept or Reject
Profitability Index
โ€”
Benefit-cost ratio
The Net Present Value Formula
NPV = ฮฃ(CF_t / (1 + r)^t) โˆ’ Initial Investment

CF_t = Cash flow in year t

r = Discount rate (as decimal, e.g., 10% = 0.10)

t = Year number

Initial Investment = Upfront cost (outflow)

How NPV Works

Net Present Value (NPV) calculates the present value of all future cash flows (both inflows and outflows) discounted at a specific rate, minus the initial investment. A positive NPV means the investment is expected to generate more value than it costs โ€” accept the project. A negative NPV means the investment is expected to lose value โ€” reject the project.

The discount rate reflects the opportunity cost of capital โ€” the return you could earn from an alternative investment of similar risk. A higher discount rate reduces the present value of future cash flows, making NPV more conservative.

IRR Approximation Method

The Internal Rate of Return (IRR) is the discount rate that makes NPV equal to zero. If NPV is positive at the given rate and negative at a higher rate, we estimate IRR using linear interpolation between these two rates. If NPV is already negative at the given rate, IRR is below the discount rate.

Example 1: New Equipment Purchase

A company invests $50,000 in new equipment with a discount rate of 8%. Expected annual cash flows: Year 1: $12,000, Year 2: $14,000, Year 3: $16,000, Year 4: $18,000, Year 5: $20,000.

NPV = $12,000/(1.08)ยน + $14,000/(1.08)ยฒ + $16,000/(1.08)ยณ + $18,000/(1.08)โด + $20,000/(1.08)โต โˆ’ $50,000 = $11,071.38 โ€” a positive NPV indicating a profitable investment.

Example 2: Real Estate Investment

An investor puts $200,000 into a rental property with a discount rate of 6%. Expected annual cash flows: Year 1: $24,000, Year 2: $26,000, Year 3: $28,000, Year 4: $30,000, Year 5: $32,000, Year 6: $34,000, Year 7: $36,000.

NPV = $24,000/(1.06)ยน + $26,000/(1.06)ยฒ + $28,000/(1.06)ยณ + $30,000/(1.06)โด + $32,000/(1.06)โต + $34,000/(1.06)โถ + $36,000/(1.06)โท โˆ’ $200,000 = โˆ’$17,886.21 โ€” a negative NPV suggesting the investment may not meet the required return.

Try entering these values into the calculator to verify the results!

Understanding Net Present Value

Net Present Value (NPV) is one of the most fundamental concepts in capital budgeting and investment analysis. It measures the difference between the present value of cash inflows and the present value of cash outflows over a period of time. NPV is widely used in corporate finance, real estate investing, and personal investment decisions.

The core principle behind NPV is the time value of money โ€” a dollar today is worth more than a dollar tomorrow because you can invest it and earn a return. By discounting future cash flows back to their present value, NPV provides a single dollar figure that represents the net value created by an investment.

Key Decision Rules
  • NPV > 0: The investment adds value โ€” accept the project. The present value of future cash flows exceeds the initial cost.
  • NPV = 0: The investment breaks even โ€” you're indifferent. The return equals the discount rate.
  • NPV < 0: The investment destroys value โ€” reject the project. The present value of future cash flows is less than the initial cost.

The Time Value of Money

The time value of money (TVM) is the bedrock concept behind NPV. It states that money available now is worth more than the same amount in the future due to its potential earning capacity. This principle is why we discount future cash flows when calculating NPV.

A dollar received today can be invested and grow over time. If you receive a dollar one year from now, you lose the opportunity to earn a return on that dollar for a full year. The discount rate used in NPV calculations represents this opportunity cost โ€” the return you could earn from the next best alternative investment of comparable risk.

๐Ÿ“ˆ Higher Discount Rate

Reduces the present value of future cash flows more aggressively. Results in a lower (or more negative) NPV. Used for riskier investments where you demand a higher return to compensate for uncertainty.

๐Ÿ“‰ Lower Discount Rate

Reduces future cash flows less aggressively. Results in a higher (or more positive) NPV. Used for safer investments like government bonds or blue-chip stocks where risk is minimal.

How to Choose a Discount Rate

Selecting the right discount rate is critical to getting meaningful NPV results. The discount rate should reflect the risk of the investment and your opportunity cost of capital. Here are common approaches:

  • Weighted Average Cost of Capital (WACC): For companies evaluating projects, use their WACC โ€” the blended cost of debt and equity financing.
  • Risk-Free Rate + Risk Premium: Add a risk premium (e.g., 2-5%) to the risk-free rate (e.g., 10-year Treasury bond yield) based on the investment's risk profile.
  • Expected Return on Alternatives: Use the return you could earn from a similar-risk alternative investment as your discount rate.
  • Company Hurdle Rate: Many firms set a minimum acceptable rate of return (hurdle rate) that all projects must meet or exceed.

A common mistake is using too low a discount rate, which overstates NPV and leads to poor investment decisions. When in doubt, use a conservative (higher) rate to stress-test your assumptions.

Frequently Asked Questions

What is the difference between NPV and IRR?
NPV (Net Present Value) gives you a dollar amount representing the value created by an investment. IRR (Internal Rate of Return) gives you a percentage return. NPV is generally preferred because it measures actual value in dollars, while IRR can sometimes give misleading results for non-conventional cash flows (e.g., alternating positive and negative flows). When NPV and IRR conflict, trust NPV โ€” it's the more reliable metric.
What is a good discount rate to use?
A good discount rate depends on your opportunity cost of capital. For personal investments, a common range is 8-12% for stock market investments, 5-8% for real estate, and 2-5% for low-risk bonds. For businesses, the Weighted Average Cost of Capital (WACC) is typically used. The key is that the discount rate should reflect the risk of the specific investment being evaluated.
What does a positive vs negative NPV mean?
A positive NPV means the present value of future cash flows exceeds the initial investment โ€” the investment is expected to generate profit above the required return. A negative NPV means the present value of future cash flows is less than the initial investment โ€” the investment is expected to fall short of the required return. Zero NPV means the investment exactly meets the required return.
Can NPV be used for personal financial decisions?
Absolutely! NPV is useful for many personal finance decisions: comparing rent vs buy a home, evaluating education investments (college vs trade school), deciding on business purchases, comparing investment properties, or analyzing solar panel installations. Any decision with an upfront cost and future benefits can be evaluated using NPV.
What is the payback period and how is it calculated?
The payback period is the time it takes for cumulative cash flows to equal the initial investment. It's calculated by adding up cash flows year by year until the total reaches or exceeds the initial outlay. For example, if you invest $10,000 and receive $3,000 per year, the payback period is about 3.33 years. While simple and intuitive, the payback period ignores the time value of money and any cash flows after the payback date.
Why does NPV decrease when the discount rate increases?
A higher discount rate means you demand a higher return for taking on the investment's risk. When you discount future cash flows at a higher rate, their present value decreases more dramatically. Think of it like zooming out โ€” the higher the rate, the more heavily future cash flows are penalized for being received further in the future. This is why riskier investments with higher discount rates tend to have lower NPVs.

Related Calculators

Explore our other free financial calculators to help with your investment analysis and financial planning.

More from Finance

Check out our other popular finance calculators and tools.

Disclaimer

Educational Purposes Only: This Net Present Value calculator is provided for educational and informational purposes only. Results are estimates based on the information you provide and standard financial formulas. They do not constitute financial advice, investment recommendations, or a guarantee of future returns. Actual investment outcomes depend on many factors including market conditions, tax implications, inflation, and specific investment risks. Always consult with a qualified financial professional before making investment decisions.