Last updated: Jul 20, 2024

NPV Calculator – Net Present Value

Q: How do I calculate NPV?

To calculate the Net Present Value (NPV): Identify future cash flows - Identify the cash inflows and outflows over the investment period. Determine the discount rate - This rate reflects the investment's risk and the cost of capital. Calculate NPV - Discount each cash flow to its present value using the formula: PV = Cash Flow / (1 + Discount Rate)^Year. Sum the discounted cash flows - Add all present values. Example: For a project with a cash inflow of $1,000 in Year 1 and a discount rate of 10% , NPV = $1,000 / (1 + 0.10)^1 = $909.09 .

Q: What is NPV in finance?

NPV , or N et P resent V alue, in finance, is a way to measure how much value an investment or project might add. It calculates the difference between the present value of cash inflows and outflows over a period. Basically, it helps decide if an investment is worth it by considering both the amount of money made and the time value of money.

Q: Can NPV be negative?

Yes, NPV can be negative . It means the project's cash outflows outweigh the cash inflows when adjusted for the time value of money. Essentially, a negative NPV indicates the investment would lose money rather than gain, suggesting it might not be a good choice .

Created by Bogna Szyk, Tibor Pál, PhD candidate

Tibor Pál

PhD candidate

Tibor is pursuing a Ph.D. in Statistical Methods in Economics at the University of Salerno. His main research activity is developing econometric models applied in macroeconomics with a primary focus on the interrelationship between finance and the real economy. His professional experience includes working as a general ledger (GL) accountant and a financial analyst. At Omni, he translates financial queries and regulations into calculators through JS coding with clear and user-friendly content. He spends the academic year in Italy but is keen to travel to Hungary, Poland, and Malaysia in his free time. Interested in gastronomy and vinery, he is able to feed the whole team with pörkölt - a delicious dish from his homeland. See full profile

Check our editorial policy

, and Dawid Siuda

Dawid Siuda

Dawid is an IT enthusiast and financial specialist passionate about Big Data, Artificial Intelligence, and the FinTech sector. Since his Bachelor’s degree in finance, he is pursuing a master’s degree in Business Informatics. Driven by a thirst for knowledge and personal growth, he actively seeks opportunities to develop his skills and broaden his expertise. He particularly enjoys taking on challenges that push his boundaries. He gained his financial knowledge by helping to organize the Wall Street Conference, the most significant event in Poland dedicated to private investors, and working as a financial consultant at one of the biggest European banks. He’s a passionate math tutor and a big-time car enthusiast. See full profile

Check our editorial policy

Reviewed by Steven Wooding

Steven Wooding

Physicist holding a 1st class degree and a member of the Institute of Physics. Creator of the UK vaccine queue calculator, and featured in many publications, including The Sun, Daily Mail, Express, and Independent. Tenacious in researching answers to questions and has an affection for coding. Hobbies include cycling, walking, and birdwatching. You can find him on Twitter @OmniSteve. See full profile

Check our editorial policy

New

Table of contents

What is the net present value?How to calculate net present value?How to calculate NPV: an example What are the expected cash flows?Net present value (NPV) and internal rate of return (IRR)FAQs

If you are trying to assess whether a particular investment will bring you profit in the long term, this NPV calculator is a tool for you. Based on your initial investment and consecutive cash flows, it will determine the net present value, and hence the profitability, of a planned project.

In this article, we will help you understand the concept of net present value and provide step-by-step instructions on how to calculate NPV. We will also tell you how to interpret the result.

NPV is often used in company valuation – check out the discounted cash flow calculator for more details.

What is the net present value?

By definition, net present value is the difference between the present value of cash inflows and the present value of cash outflows for a given project.

To understand this definition, you first need to know what is the present value. Imagine that you want to have $2200 in your account next year. You know that the yearly interest rate on that account is 10%. It means that you need to put $2000 on that account today to have $2200 twelve months from now. The present value of "$2200 due in 12 months" is $2000.

You can notice that for a positive discount rate, the future value (FV – future value calculator) is always higher or equal to the present value (PV).

Following that logic, every project that needs your investment at the beginning and returns some money each year has a present value of each cash flow: the initial investment and every cash inflow. If you sum up all of these present values, you will get a net present value (NPV) of that project.

💡 Also, check out our related present value calculator and present value of growth opportunities calculator.

How to calculate net present value?

Again, the surest way to understand the formula behind NPV is to start with the present value equation:

\small {\rm PV} = \frac{\text{cash flow}}{(1 + r)^n}

where:

$\rm PV$ – Present value of money;
$\text{cash flow}$ – Amount of money you will get in the future;
$r$ – Discount rate (interest rate used in cash flow analysis); and
$n$ – Number of time periods (typically, years) between now and the moment when you will receive your money.

To calculate NPV, you need to sum up the PVs of all cash flows.

The first cash flow $C_0$ – your investment – will happen at a time when $n = 0$ . Additionally, as this is your expenditure, it will be negative in value.
Every other cash flow $C_i$ will be either positive (income) or negative (expenses). Each year, you have to increase the $n$ value by 1.

If you apply all of these principles, you will get the following net present value formula:

\small {\rm NPV} = -C_0 + \sum_{i\ =\ 1}^n\left[\frac{C_i}{(1 + r)^i}\right]

Or, if you don't want to use the summation notation:

\small {\rm NPV} = -C_0 + \frac{C_1}{(1 + r)} + \frac{C_2}{(1 + r)^2}\\[1em]\qquad + \frac{C_3}{(1 + r)^3} + \dots + \frac{C_n}{(1 + r)^n}

Select the Show more annual cash flows checkbox of this NPV calculator to find the net present value of up to ten cash flows (investment and nine cash inflows). If you want to take into account more cash flows, we recommend you use a spreadsheet instead.

How to calculate NPV: an example

Let's analyze the following example: a company has to choose between two projects that both cost $10,000 to implement. Each of them will last for 5 years, but they have different expected cash inflows. The discount rate is 5% in each case. Which project should the company choose?

Time	Project 1	Project 2
Initial investment	$10,000	$10,000
Year 1	$5000	$1000
Year 2	-$1000	$1000
Year 3	$3000	$1000
Year 4	$3000	$5000
Year 5	$2000	$4000

If you use our NPV calculator to determine the NPV for each of these projects, you will discover that the NPV of project 1 is equal to $481.55, while the NPV of project 2 is equal to –$29.13.

This result means that project 1 is profitable because it has a positive NPV. Project 2 is not profitable for the company, as it has a negative NPV. That is why the company should choose to implement project 1.

What are the expected cash flows?

You probably noticed that our NPV calculator determines two values as results. The first one is NPV, and the second is called the "expected cash flow".

This is the present value of all of your cash inflows, not taking the initial investment into account.

Net present value (NPV) and internal rate of return (IRR)

The internal rate of return (IRR calculator) of a project is such a discount rate at which the NPV equals zero. In other words, the company will neither earn nor lose on such a project – the gains are equal to costs.

IRR is typically used to assess the minimum discount rate at which a company will accept the project. It allows you to establish reasonably quickly whether the project should be considered as an option or discarded because of its low profitability.

FAQs

How do I calculate NPV?

To calculate the Net Present Value (NPV):

Identify future cash flows - Identify the cash inflows and outflows over the investment period.
Determine the discount rate - This rate reflects the investment's risk and the cost of capital.
Calculate NPV - Discount each cash flow to its present value using the formula: PV = Cash Flow / (1 + Discount Rate)^Year.
Sum the discounted cash flows - Add all present values.

Example: For a project with a cash inflow of $1,000 in Year 1 and a discount rate of 10%, NPV = $1,000 / (1 + 0.10)^1 = $909.09.

What is NPV in finance?

NPV, or Net Present Value, in finance, is a way to measure how much value an investment or project might add. It calculates the difference between the present value of cash inflows and outflows over a period. Basically, it helps decide if an investment is worth it by considering both the amount of money made and the time value of money.

Can NPV be negative?

Yes, NPV can be negative. It means the project's cash outflows outweigh the cash inflows when adjusted for the time value of money. Essentially, a negative NPV indicates the investment would lose money rather than gain, suggesting it might not be a good choice.

What does NPV equal 1000 mean?

If NPV equals 1000, it means:

The investment is likely profitable - The project's expected earnings exceed its costs.
Positive Return - You're expected to earn 1000 more than the investment's initial cost, considering the time value of money.
This is a strong signal that the investment is a good choice financially.

NPV is a key figure in finance, helping to assess the profitability and viability of investments.