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: February 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 is the cornerstone of modern capital budgeting and investment analysis. Unlike simple metrics like payback period or accounting rate of return, NPV captures the fundamental economic reality that money has time value. A dollar today is worth more than a dollar tomorrow because it can be invested to earn returns. According to Investopedia, NPV is widely considered the most theoretically sound method for evaluating investment projects.

    The CFA Institute curriculum emphasizes NPV as the primary tool for capital budgeting decisions. The NPV rule is elegant in its simplicity: 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. A negative NPV indicates the project destroys value by earning less than the required return.

    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.

    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. Early-stage ventures may use 40%+ to account for high failure probability.

    Personal Investments

    Use your expected return from alternative investments. Stock market historical returns (7-10%) provide a reasonable benchmark for most investors.

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

    Each capital budgeting metric answers a different question. Understanding when to prioritize each helps make better investment decisions.

    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

    For more guidance, visit the Real Estate tools hub and the Valuefy blog.

    Pair this tool with the Payback Period Calculator and the Property Tax Calculator to cross-check inputs. For strategic context, read our e-commerce valuation case study and explore the Real Estate & Investment tools hub.

    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.