How to Calculate NPV in Excel

This article provides a step-by-step guide on how to calculate Net Present Value (NPV) for an investment using Microsoft Excel. You can perform this task with Excel on both Windows and Mac computers.

Ensure you have the necessary details of the investment. To calculate NPV, you need to know the annual discount rate (e.g., 1%), the initial investment, and the returns over at least one year.

• It is preferable to have investment returns for 3 or more years, but this is not mandatory.

Open Microsoft Excel. This is the program with a green square icon featuring a white 'X'.

Click on the Blank workbook (New Worksheet). This option can be found in the top left corner of the Excel window.

Enter the discount rate of the investment. Select a cell (e.g., A2) and input the decimal equivalent of the annual discount rate for the investment.

• For instance, if the discount rate is 1%, enter 0.01 in this cell.

Input the initial investment amount. Click on an empty cell (e.g., A3) and enter the initial amount that was used for the investment.

Enter the annual returns. Click on another empty cell (e.g., A4) and enter the return for the first year, followed by the returns for subsequent years.

Select a cell. Click on the cell where you want to calculate the NPV.

Enter the NPV formula. Type =NPV() here. The investment information will be entered inside the parentheses.

Add values to the NPV formula. Inside the parentheses, you will need to input the cell number for the discount rate, the investment amount, and at least one year’s return.

• For example, if cell A2 contains the discount rate, A3 contains the investment amount, and A4 contains the return, your formula will be =NPV(A2,A3,A4).

Press ↵ Enter. This action prompts Excel to calculate the NPV and display the result in the selected cell.

• If the NPV shows a red number, the investment has a negative value.

• If there is no profit within at least one year, the NPV cannot be computed.