Net Present Value (NPV) Calculator
Calculate Net Present Value (NPV) of an investment by discounting future cash flows to present value. Determine project profitability with positive values indicating good investments.
About This Calculator
The Net Present Value (NPV) Calculator helps investors, financial analysts, and business owners evaluate the profitability of an investment or project. By discounting expected future cash flows to their present value and comparing them against the initial investment, this tool determines whether a project will create or destroy value. A positive NPV signals a profitable investment, while a negative NPV suggests the project may not meet the required rate of return.
The NPV formula used is: NPV = -C₀ + Σ(Cᵢ / (1 + r)ⁱ), where C₀ is the initial investment, Cᵢ is the cash flow in year i, and r is the discount rate. The calculator also computes the Total Cash Flows (sum of all undiscounted future cash receipts) and the Profitability Index (PI), which is the ratio of the present value of future cash flows to the initial investment. A PI greater than 1.0 indicates a value-creating project.
This calculator supports different currencies and region-specific formatting. It auto-detects your locale (IN, US, or UK) to display results with the appropriate currency symbol and number format. The chart view shows discounted cash flows declining over time, illustrating how the discount rate reduces the value of distant cash flows.
Regional Notes
India: Indian companies typically use discount rates of 10-15% based on the weighted average cost of capital (WACC). The NPV method is widely used in infrastructure, manufacturing, and real estate project evaluation. SEBI recommends NPV analysis for comparing investment proposals.
United States: US companies commonly use WACC-based discount rates of 8-12% for NPV analysis. The IRS provides guidelines on discount rates for tax-related present value calculations. NPV is a standard tool in corporate finance, real estate development, and energy sector project evaluation.
United Kingdom: UK businesses follow HM Treasury's Green Book guidance which recommends a social time preference rate of 3.5% for public sector projects. Private sector companies typically use 8-14% discount rates based on their cost of capital. NPV analysis is standard practice for capital budgeting across all sectors.
Frequently Asked Questions
What is Net Present Value (NPV)?
Net Present Value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows over a period of time. It is used in capital budgeting and investment planning to analyze the profitability of a projected investment or project.
How is NPV calculated?
NPV is calculated by discounting each future cash flow back to its present value using a discount rate, then summing them and subtracting the initial investment. The formula is NPV = -C0 + Σ(Ci / (1 + r)^i) where C0 is initial investment, Ci is cash flow in year i, and r is the discount rate.
What does a positive NPV mean?
A positive NPV means the present value of future cash inflows exceeds the initial investment, indicating the project is expected to generate profit and is worth considering. The higher the positive NPV, the more profitable the investment.
What does a negative NPV mean?
A negative NPV means the present value of future cash inflows is less than the initial investment, indicating the project is expected to generate a loss. In most cases, investments with negative NPV should be rejected unless there are strategic reasons to proceed.
What is a good discount rate for NPV analysis?
A good discount rate depends on the risk profile of the investment and the cost of capital. In India, typical discount rates range from 10-15% for most projects. In the US and UK, rates typically range from 8-12%. Higher-risk projects use higher discount rates to account for uncertainty.
What is the Profitability Index?
The Profitability Index (PI) is the ratio of the present value of future cash flows to the initial investment. A PI greater than 1 indicates a profitable investment. It helps compare projects of different sizes by showing the value created per unit of investment.
How do I choose between two projects using NPV?
When choosing between projects, select the one with the higher positive NPV, as it creates more value. However, also consider the project scale, risk profile, and profitability index. NPV assumes cash flows can be reinvested at the discount rate, which may differ from reality.
Is this NPV calculator free to use?
Yes, this NPV calculator is completely free to use with no registration or account required. You can share your calculations via the URL, which saves all input parameters for easy reference and sharing.