calcy treasure chest of featuresLove the calculators but not the ads?

Take a sneak peek at the Ad-Free Design being enjoyed by hundreds of members for less than 25¢ a week. Full details and a bonus!

NPV Calculator to Calculate Discounted Cash Flows

Calculator Preferences
Net Present Value (NPV) Calculator Sign
Net Present Value (NPV) Calculator

This calculator will calculate the Net Present Value (NPV) for a series of future uneven cash flows. Plus the calculator will display a printer friendly Discounted Cash Flows Schedule that you can print out and use for sensitivity analysis. The Learn tab includes:

  • What is NPV?
  • What is Discounting?
  • What is the Discounted Cash Flow (DCF) Method?
  • Importance and benefits of conducting NPV analysis on prospective investments.
Learn More

Selected Data Record:

A Data Record is a set of calculator entries that are stored in your web browser's Local Storage. If a Data Record is currently selected in the "Data" tab, this line will list the name you gave to that data record. If no data record is selected, or you have no entries stored for this calculator, the line will display "None".

DataData recordData recordSelected data record: None
Disc rate:Discount rate:Discount rate:Discount rate:

Discount rate:

Enter the rate you want the NPV Calculator to discount the entered cash flows. Note that the discount rate is also commonly referred to as the Cost of Capital. Enter as a percentage, but without the percent sign (for .06 or 6%, enter 6).

Begin year:Begin year:Year of initial investment:Year of initial investment:

Year of initial investment:

Optional. If you would like the calculator to populate the Year column with the actual year labels, enter the 4-digit year of the initial outflow (capital outlay). Otherwise leave blank. Note that if you make changes to this field after creating and/or completing the cash flow entry form, the entry form will be cleared. So be sure you are happy with this entry before creating and completing the entry form.

# of yrs:# of years:Number of years to include:Number of years to include in form:

Number of years to include in form:

Enter the number of years you would like included in the outflow/inflow form. Optionally, if you entered a 4-digit start year you can enter the 4-digit end year. In either case, this is a required field. Note that if you make changes to this field after creating and/or completing the cash flow entry form, the entry form will be cleared. So feel free to enter more years than you think you might need as the calculator will simply ignore any extra blank years.

Year entry column:

If you entered a 4-digit year above, then this column will be automatically populated with the appropriate years based on the year entered in the line above.

Outflow entry column:

Enter the initial outflow amount on the first line (required) and then on any subsequent lines where additional amounts were invested (enter as positive values). Note that numbers entered in this column are usually entered as negative values when using an NPV spreadsheet function, however this NPV Calculator converts the values to negative for you.

Inflow entry column:

Enter cash inflows in the years they are projected to be received. You must have at least one value in this column for the NPV calculation to begin.

Net CF:Net cash flow:Net cash flow:Net cash flow:

Net cash flow:

The is the sum of all outflows less the sum of all inflows.

# of years:# of years:Number of years:Number of years:

Number of years:

This is the total number of cash flow years that were included in the calculations -- which includes the year of the initial cash outflow.

NPV:NPV:Net Present Value:Net Present Value:

Net Present Value:

This is the total of all discounted cash flows (NPV). If this result is positive, the project is considered to be desirable. If the NPV is a negative number, the project is considered to be undesirable.

If you would like to save the current entries to the secure database, tap or click on the Data tab, select "New Data Record", give the data record a name, then tap or click the Save button. To save changes to previously saved entries, simply tap the Save button. Please select and "Clear" any data records you no longer need.

Feedback AppreciatedFeedback Greatly AppreciatedYour Feedback Would Be Greatly AppreciatedYour Feedback Is Greatly Appreciated
Heading

Tip

Help and Tools

Help and Tools:

This section, which you can Unstick or Hide in the Calculator Preferences (just above the top of the calculator), contains the following tabs (content too long to fit within bordered frame can be scrolled up and down):

About: Click this tab for an introduction to the calculator.

Instructions: Click this tab for step-by-step instructions for using the calculator.

Terms: Click this tab for a list of the descriptions that are located within each popup help button (info icons).

PCalc: Click this tab for a handy "pocket" calculator you can use when you need to calculate an entry needed for the calculator.

Data: Click this tab to save a set of entries or a note in between visits. Entries and notes will be stored to your web browser's local storage (if supported by your browser of choice), meaning they can only be recalled with the same device and web browser you were using when you saved them. If you'd like to save entries and notes between devices you can do so by subscribing to the Ad-Free Member Version.

 

Favorites

Add or remove this page to/from my favorites.

Adjust Calculator Width:

Move the slider to left and right to adjust the calculator width. Note that the Help and Tools panel will be hidden when the calculator is too wide to fit both on the screen. Moving the slider to the left will bring the instructions and tools panel back into view.

Also note that some calculators will reformat to accommodate the screen size as you make the calculator wider or narrower. If the calculator is narrow, columns of entry rows will be converted to a vertical entry form, whereas a wider calculator will display columns of entry rows, and the entry fields will be smaller in size ... since they will not need to be "thumb friendly".

Show/Hide Popup Keypads:

Select Show or Hide to show or hide the popup keypad icons located next to numeric entry fields. These are generally only needed for mobile devices that don't have decimal points in their numeric keypads. So if you are on a desktop, you may find the calculator to be more user-friendly and less cluttered without them.

Stick/Unstick Tools:

Select Stick or Unstick to stick or unstick the help and tools panel. Selecting "Stick" will keep the panel in view while scrolling the calculator vertically. If you find that annoying, select "Unstick" to keep the panel in a stationary position.

If the tools panel becomes "Unstuck" on its own, try clicking "Unstick" and then "Stick" to re-stick the panel.