Calculate the Net Present Value (NPV) of an investment by entering your initial investment, discount rate, and up to 10 years of cash flows. You'll get back the NPV result, total undiscounted cash flows, and a breakdown chart showing present values by year — helping you decide whether a project is worth pursuing.
Net Present Value (NPV)
--
Total Present Value of Cash Flows
--
Total Undiscounted Cash Flows
--
Investment Decision
--
NPV is a financial metric that measures the profitability of an investment by calculating the difference between the present value of all future cash inflows and the initial investment cost. It accounts for the time value of money — meaning a dollar today is worth more than a dollar in the future. A positive NPV indicates the investment is expected to generate more value than it costs.
A positive NPV means the investment is expected to generate returns exceeding the discount rate, creating value — typically a signal to proceed. A negative NPV means the projected returns fall short of the required rate of return, suggesting the investment may destroy value. An NPV of zero means the investment exactly meets the required rate of return.
The discount rate (also called the required rate of return or hurdle rate) reflects the minimum acceptable return on an investment, often based on the cost of capital or a target return rate. It's used to convert future cash flows into today's dollars. A higher discount rate places less value on future cash flows, making it harder for projects to show a positive NPV.
A cash flow is the net amount of money expected to be received (or paid) at the end of each time period. Cash flows can be positive (inflows like revenue) or negative (outflows like expenses). In NPV analysis, each period's cash flow is discounted back to its present value using the formula CFt / (1 + r)^t.
The NPV formula is: NPV = Σ [CFt / (1 + r)^t] − Initial Investment. Here, CFt is the cash flow in period t, r is the discount rate, and t is the time period. You sum the discounted values of all future cash flows and subtract the upfront investment to arrive at the NPV.
NPV gives you a dollar value representing how much value an investment adds above the required rate of return. IRR (Internal Rate of Return) is the discount rate at which the NPV equals zero — it's expressed as a percentage. Both metrics are related, but NPV is generally considered more reliable for comparing projects of different sizes because it measures absolute value creation.
Yes — that's one of NPV's key strengths. Unlike simple payback period calculations, NPV handles uneven or irregular cash flows by discounting each year's cash flow individually. This calculator lets you enter up to 10 different annual cash flow values to reflect real-world project structures.
In Excel, use the =NPV(rate, value1, value2, ...) function for the future cash flows, then subtract the initial investment separately: =NPV(rate, cf1:cf10) - initial_investment. Note that Excel's NPV function assumes cash flows occur at the end of each period and does not automatically include the Year 0 outflow, so you must subtract it manually.