Net Present Value (NPV) Calculation Steps

Net Present Value (NPV) Calculation Steps
Net Present Value (NPV) Calculation Steps

Net Present Value Analysis is a financial cash flow analysis technique that helps in project selection. Moreover, NPV project selection criteria falls under the classification of benefit measurement method. Further, NPV analysis uses discounted cash flow technique to assess project profitability. In fact, major advantage of net present value method is that it uses the concept of time value of money. My post Project Selection Methods Top 5 Criteria especially covers theory of NPV technique in great detail. However, this post describes the essential NPV calculation steps. Moreover, this post will also cover some suggested PMP exam question as a study guide.

Net Present Value Example Problem

Let us consider a npv example problem in order to demonstrate how this technique helps in project selection. To begin with, assume a project that requires an investment of INR 20,000. Further consider risk free rate of return is 8%. The following paragraph lists future cash flows of the project.

  • First year  INR 5,000
  • Second year INR 6,000
  • Third year INR 8,000
  • Fourth year INR 7,000
  • Fifth year INR 4,000

Another important aspect of npv calculation is that it is independent of currency. In the following example I have used INR you can replace it with any currency of your choice.

Net Present Value Formula

The following mathematical equation represents net present value formula.

    \[NPV=\sum_{t=1}^{N} \frac{FV_t}{(1 + k)^t} - PV\]

Net Present Value Method Calculation Steps

The following paragraphs enumerates steps involved in calculating net present value (npv).

NPV Calculation Step 1

  • To begin with firstly arrange all future cash flows corresponding to each year of receipt. The following table illustrates this. Another key point to remember is that NPV  calculation is not dependent of currency. Hence in my example I have not used any currency symbol.
  First Year Second Year Third Year  Fourth Year Fifth Year
Future Cash Flow 5000 6000 8000 7000 4000

NPV Calculation Step 2

  • Next step is to calculate present value of each of the future cash flow
  • Mathematical expression of Present Value (PV) is;

        \[PV = \frac{FV}{(1 + k)^N}\]

  • Where; k = discounting factor / interest rate and N = Number of time periods
  First Year Second Year Third Year  Fourth Year Fifth Year
Future Cash Flow 5000 6000 8000 7000 4000
Present Value (PV)  5000 / (1+0.08)

5000 / 1.08

6000 / (1+0.08)^2

6000 / 1.17

8000 / (1+0.08)^3

8000 / 1.26

7000 / (1+0.08)^4

7000 / 1.36

4000 / (1+0.08)^5

4000 / 1.47

NPV Calculation Step 3

  • Now add all the present values of future cash flows.
  • The following table illustrates steps involved in calculating present value of future cash flows.
First Year Second Year Third Year Fourth Year Fifth Year
Future Cash Flow 5000 6000 8000 7000 4000
Present Value (PV)  5000 / (1+0.08)

5000 / 1.08

4630

6000 / (1+0.08)^2

6000 / 1.17

5144

8000 / (1+0.08)^3

8000 / 1.26

6351

7000 / (1+0.08)^4

7000 / 1.36

5145

4000 / (1+0.08)^5

4000 / 1.47

2722

NPV Calculation Step 4

  • Now that you have investment value and the net present value of future cash flow. This information will help you to calculate NPV.
  • In order to calculate NPV subtract investment value (cash outflow) from Sum of Present Value (PV) of all future cash flows.
  • You will be left with either a positive or a negative value.
Sum of Present Value 23,992
Investment Value 20,000
Net Present Value (NPV) 23,992 – 20,000 = 3,992

NPV Calculation Step 5

  • Finally analyse the NPV value that you have.
  • In order to arrive at the  project selection decision the following criteria is followed.
    • Accept the project if NPV is greater than zero. (NPV > 0 Accept).
    • Reject the project is NPV is less than zero. (NPV < 0 Reject).
    • While comparing two projects always select the project with a higher NPV.

The following image depicts all the steps involved in calculating Net Present Value (NPV) .

Net Present Value (NPV) Calculation Steps

Net Present Value Analysis PMP Exam Questions

As a matter of fact, Project Management Professional (PMP) certification examination has never asked for detailed NPV calculation. However, it is important to understand the steps. NPV PMP exam questions are of the following types

NPV PMP Exam Question

Project A has NPV of INR 50,000 and takes 1 year to complete. Project B has NPV  of INR 75,000 but takes 2 years to complete. Which project will you choose?

NPV PMP Exam Question Solution

Answer: Select Project B

When we have to select two projects then always choose the project with higher NPV. In fact, the element of time has no selection basis here as npv methods caters for time value of money.

Also read: Project Selection Methods Top 5 Criteria

Summary

As shown above net present value calculation steps are simple to understand. To summarize NPV project selection technique is an important financial analysis tool that every project manager should be aware of. However, PMP exam requires to know application of fundamental knowledge of project selection.

8 thoughts on “Net Present Value (NPV) Calculation Steps

  1. I agree! This is the clearest explanation I’ve seen. I think there may be a typo in “NPV Calculations step 3,” the time period values for “N” don’t align w the year. It is shown again in the “NPV Calculation Steps” correctly.

  2. Yeah, I agree. Your explanation was just what I needed. Especially the last section…. I don’t like math. Thank you for the page you created for us and time and energy you put into making our lives easier. I may eventually pass a CAPM.

  3. Thank you! This is the best and most complete explanation of NPV that I have found on the internet, so far.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.