Free Financial Tool

    NPV Calculator: Net Present Value with IRR & Sensitivity Analysis

    Calculate Net Present Value (NPV), Internal Rate of Return (IRR), and Profitability Index. Compare multiple investment projects side-by-side with sensitivity analysis.

    By Valuefy TeamCFA, Finance AnalystsLast Updated: April 20268 min read

    Try an example:

    Investment Details
    Enter your investment parameters
    NPV Analysis Results

    Enter your investment details to see NPV analysis.

    What Is Net Present Value (NPV)?

    Net Present Value (NPV) is the difference between the present value of expected future cash flows and the initial investment cost, discounted at the investor's required rate of return. A positive NPV means the investment creates value above the cost of capital; a negative NPV means it destroys value. NPV is the gold standard for capital budgeting decisions.

    Net Present Value is the cornerstone of modern capital budgeting and investment analysis. According to a landmark survey of 392 CFOs by Graham and Harvey, 74.9% of chief financial officers always or almost always use NPV when evaluating capital investments, making it one of the two most popular techniques alongside IRR (75.7%). Unlike simple metrics like payback period or accounting rate of return, NPV captures the fundamental economic reality that money has time value.

    The CFA Institute curriculum emphasizes NPV as the primary tool for capital budgeting decisions. The 2026 AFP Cost of Capital Survey confirms that 83% of organizations use discounted cash flow techniques to evaluate projects. The NPV rule is straightforward: accept projects with positive NPV, reject those with negative NPV. A positive NPV means the project generates returns exceeding the cost of capital, creating intrinsic value for shareholders.

    In practice, NPV analysis involves three critical inputs: the initial investment, projected cash flows, and the discount rate. While the first two are relatively straightforward to estimate, choosing the appropriate discount rate requires careful consideration of the project's risk profile. Higher-risk ventures warrant higher discount rates, reflecting the greater uncertainty in future cash flows. This risk adjustment is what makes NPV superior to metrics that ignore time value of money.

    For comprehensive investment analysis, combine NPV with Internal Rate of Return (IRR) and Payback Period calculations. While NPV tells you the absolute dollar value created, IRR provides the percentage return, and payback period indicates liquidity risk. Together, these metrics offer a complete picture of investment merit.

    How Do You Calculate NPV Step by Step?

    The NPV formula with summation notation:

    NPV = -C0 + SUM(t=1 to n) [ Ct / (1 + r)^t ]

    Where:

    • C0 = Initial investment (negative cash flow at time 0)
    • Ct = Cash flow at time period t
    • r = Discount rate (required rate of return)
    • t = Time period (1, 2, 3, ... n)
    • n = Total number of periods

    Understanding the Discount Rate

    The discount rate is arguably the most important input in NPV calculations. It represents the opportunity cost of capital - the return you could earn on an alternative investment of similar risk.

    According to the 2026 AFP survey, 83% of organizations use CAPM to estimate the cost of equity, and 62% use their calculated cost of capital as the standard hurdle rate. The remaining 38% set a hurdle rate above the cost of capital to account for execution risk.

    IndustryTypical WACCKey Driver
    Utilities5-7%Regulated cash flows, high debt capacity
    Food Processing~6%Non-cyclical demand, stable margins
    Real Estate (REITs)6-9%Asset-backed, high leverage
    Healthcare8-10%Regulatory risk, long R&D cycles
    Software~10%High equity beta, low capital intensity
    Retail8.5-12.5%Consumer cyclicality, thin margins
    Semiconductors~10.8%High cyclicality, capex-heavy

    Source: Damodaran, NYU Stern (Jan 2025). Market average WACC: 7.63%. Ranges reflect company size and leverage differences.

    Corporate Projects

    Use WACC (Weighted Average Cost of Capital), typically 8-12% for established companies. This reflects the blended cost of debt and equity financing.

    Real Estate

    Cap rates typically range 5-10% depending on property type and location. Add premium for development projects or value-add opportunities.

    Startups & Venture

    High discount rates of 20-50% reflect extreme uncertainty. Calculate your burn rate and runway to stress-test assumptions.

    Personal Investments

    Use your expected return from alternative investments. Historical stock market ROI (7-10%) provides a reasonable benchmark for most investors.

    NPV vs. IRR vs. Payback Period: Which Should You Use?

    Use NPV to measure the absolute dollar value an investment creates. Use IRR to express the annualized percentage return. Use payback period to assess liquidity risk. When NPV and IRR disagree on project ranking, always prioritize NPV because it maximizes shareholder value in absolute terms.

    In the Graham and Harvey survey, 75.7% of CFOs use IRR, 74.9% use NPV, and approximately 57% use payback period. Each metric answers a different question, and experienced analysts use all three together.

    NPV

    Answers: How much value does this investment create in today's dollars?

    • Absolute dollar value created
    • Accounts for time value
    • Best for project ranking
    • Requires discount rate input

    IRR

    Answers: What is the project's annualized rate of return?

    • Percentage return metric
    • Easy to compare to hurdle rate
    • Can have multiple solutions
    • Calculate IRR

    Payback Period

    Answers: How long until I recover my initial investment?

    • Simple liquidity measure
    • Proxy for investment risk
    • Ignores post-payback cash flows
    • Calculate Payback

    When Metrics Conflict

    NPV and IRR usually agree on accept/reject decisions but can rank projects differently. When comparing mutually exclusive projects, always prioritize NPV. A $1 million project with 20% IRR creates more value than a $10,000 project with 100% IRR. NPV tells you the actual dollar value created; IRR only tells you the percentage return.

    What Are Real-World NPV Examples?

    Equipment Purchase Decision

    A manufacturing company evaluates a $100,000 CNC machine expected to generate $30,000 in annual cost savings for 5 years. Using a 10% discount rate (company WACC):

    Year 1: $30,000 / 1.10 = $27,273
    Year 2: $30,000 / 1.21 = $24,793
    Year 3: $30,000 / 1.33 = $22,539
    Year 4: $30,000 / 1.46 = $20,490
    Year 5: $30,000 / 1.61 = $18,627
    Total PV = $113,722
    NPV = $113,722 - $100,000 = $13,722

    Positive NPV of $13,722 indicates the machine creates value. The company should proceed with the purchase as it exceeds the 10% required return.

    Real Estate Investment

    An investor considers a $500,000 rental property with $48,000 annual net operating income and expected sale at $600,000 in 7 years. Using an 8% discount rate:

    PV of rental income (7-year annuity at 8%) = $249,917
    PV of sale price = $600,000 / 1.71 = $350,877
    Total PV = $600,794
    NPV = $600,794 - $500,000 = $100,794

    The $100,794 NPV suggests strong value creation. Combined with the 9.6% cap rate ($48,000 / $500,000), this investment meets institutional quality standards.

    Startup Investment

    A venture capitalist evaluates a $250,000 seed investment in a SaaS startup. Expected cash flows show losses initially, then growth. Using 25% discount rate for early-stage risk:

    Year 1: -$50,000 / 1.25 = -$40,000
    Year 2: $25,000 / 1.56 = $16,026
    Year 3: $100,000 / 1.95 = $51,282
    Year 4: $200,000 / 2.44 = $81,967
    Year 5: $500,000 (exit) / 3.05 = $163,934
    Total PV = $273,209
    NPV = $273,209 - $250,000 = $23,209

    Despite the high discount rate reflecting startup risk, NPV remains positive. The investment earns above the 25% hurdle rate, though sensitivity analysis at 30% and 35% would test robustness.

    What Are the Limitations of NPV Analysis?

    While NPV is the gold standard for capital budgeting, it has important limitations that practitioners must understand to avoid misapplication.

    Discount Rate Sensitivity

    Small changes in the discount rate can dramatically change NPV, especially for long-duration projects. A project positive at 10% might be negative at 12%. Always perform sensitivity analysis across a range of discount rates.

    Cash Flow Estimation Uncertainty

    NPV is only as accurate as its cash flow projections. For new products or technologies, forecasting errors can be substantial. Use scenario analysis (pessimistic, base, optimistic) to understand the range of possible outcomes.

    Ignores Strategic Value

    NPV captures only quantifiable cash flows. Strategic benefits like market positioning, learning opportunities, or option value from future expansion may not be reflected. Real options analysis can help capture this additional value.

    Assumes Reinvestment at Discount Rate

    NPV implicitly assumes intermediate cash flows can be reinvested at the discount rate. For projects with very high returns, this may be unrealistic. Modified IRR (MIRR) addresses this limitation for some applications.

    Scale Blindness in Rankings

    When capital is unlimited, maximize NPV regardless of size. But when capital is constrained, a smaller project with higher NPV per dollar invested (Profitability Index) may be preferable to a larger project with higher absolute NPV.

    Key Takeaways

    Pair this tool with the IRR Calculator for percentage returns, the Payback Period Calculator for liquidity risk, and the ROI Calculator for quick comparisons. Use our CAPM Calculator to estimate the cost of equity input and the WACC Calculator for a blended discount rate.

    NPV is the most theoretically sound capital budgeting metric because it accounts for the time value of money and provides absolute dollar value of investment returns.

    The NPV rule is simple: accept projects with positive NPV (they create value), reject projects with negative NPV (they destroy value). When comparing projects, choose the one with highest NPV.

    The discount rate is the most critical input. It should reflect both the opportunity cost of capital and the specific risk of the project being evaluated.

    Always perform sensitivity analysis to understand how NPV changes with different discount rate and cash flow assumptions. A robust project remains positive across scenarios.

    Combine NPV with IRR for percentage returns, Profitability Index for capital efficiency, and Payback Period for liquidity assessment to get a complete investment picture.

    Frequently Asked Questions

    Planning to sell your business?

    Get a professional DCF valuation of your company. Our AI-powered analysis uses NPV and IRR methodologies to determine fair market value.