NPV Calculator

What is NPV or Net Present Value?

NPV or Net Present Value is a financial metric in capital budgeting that is used to evaluate whether a project or an investment is going to yield good return in future or not. It can be simply represented as the difference between the present value of cash inflows and the present value of cash outflows. In the long run a positive NPV value indicates good potential return over investment, while the negative NPV value means that the investment is likely to lose money. Sometimes NPV is also referred as NPW or Net Present Worth.

NPV Calculation Formula

For calculating NPV value using formula, you must already know the estimated value of discount rate (r), all cash flow (both positive and negative) and the total initial investment made by the company. The formula for calculating NPV is as follows:

Where in the above formula:

• N = total number of periods
• n = positive integer
• C = cash flow
• r = discount rate
• NPV = net present value

Calculate NPV with Example

Suppose a company wants to start a new manufacturing plant in the near future. The company is looking forward to invest a total sum of $100000 in its setup at the beginning, where the expected discount rate is 10 percent per-annum. This company has set its goal for 5 years and for these 5 years the cash flows are $10000, $20000, $30000, $40000, $50000 respectively. Let's calculate the NPV and also evaluate whether the company should pursue this decision or not.

The equation we have:

NPV = C₁/(1+r) + C₂/(1+r)² + C₃/(1+r)³ + C₄/(1+r)⁴ + C₅/(1+r)⁵ − initial investment

Let's apply all the known values in the NPV formula here.

NPV = 10000/(1+0.1) + 20000/(1+0.1)² + 30000/(1+0.1)³ + 40000/(1+0.1)⁴ + 50000/(1+0.1)⁵ − 100000

NPV = 6525.88

The positive value of NPV suggests the investment is likely to return profit in the future. In this scenario the NPV is 6525.88, so it seems that the investment is likely to yield profit.

NPV Decision Rule

• If NPV > 0, then the company should accept the investment decision or project. The positive value of NPV is expected to increase the net worth of the company or its shareholders.
• If NPV < 0, the company is expected to lose money, so it shouldn't pursue that investment or project.
• If NPV = 0, this will neither increase nor decrease the value of the company or firm.

Drawbacks of NPV

The discount rates (r) used in the formula above are likely to vary over time. The slight increase or decrease in discount rate can impact the NPV value. Hence it's critical in decision making.

NPV is not effective in comparing two mutually exclusive projects which require different amount of investment.

NPV may not give correct decision when comparing two projects with different time duration.

NPV calculation is based upon assumptions. It's prone to forecasting error. So, companies can't rely on only NPV before making any investment decision. There are other financial tools too (like IRR or Internal Rate of Return) which companies should consider for getting the clear picture.

About this NPV Calculator

Calculating NPV can be a very daunting task, specially when you have so many positive and negative cash flows. There are many tools available that can be used to calculate NPV. You can either use financial calculators like Ti-83, Ti-84 and HP 12c calculator or can take the help from software like MS Excel. This website, npvcalculator.info, is such a tool. It's an online NPV calculator.

To calculate NPV or Net Present Value, enter the initial investment, the expected discount rate and cash flows for each period. You can also add or delete period fields as needed. Then hit the calculate button to get the NPV result.