Partner Logo
Home  > Net Present Value Table
 Share  Print Version  Email

Other Translations

Net Present Value Table

Provided by the International Finance Corporation


The Net Present Value (NPV) represents the difference between the present value of cash inflows and the present value of cash outflows. It is used in budgeting to analyze the profitability of an investment or project. If the NPV of a prospective project is positive, it should be accepted. However, if NPV is negative, the project should probably be rejected because cash flows will also be negative.

In the Excel file below, enter an interest (discount) rate, the initial investment (negative value), the expected future net cash flows (negative values for payments and positive values for income), and the investment period (max 10 years). The tool also allows for comparison of different investment options by entering the corresponding expected cash flow. The tool will automatically calculate the NPV that you can use to make your investment decisions.

You may adapt the tool to reflect your business needs, type of clientele, products and services you offer.

 

Attachments:
ICON_EXCEL.gif Net Present Value Table for Calculating the Present Value of an Investment

Copyright © 2000 - 2017, International Finance Corporation. All Rights Reserved.

© International Finance Corporation [Year of First Publication].  All rights reserved.
2121 Pennsylvania Avenue, N.W.
Washington, D.C. 20433
Internet:  www.ifc.org
 
The material in this work is copyrighted. Copying and/or transmitting portions or all of this work without permission may be a violation of applicable law.  IFC does not guarantee the accuracy, reliability or completeness of the content included in this work, or for the conclusions or judgments described herein, and accepts no responsibility or  liability for any omissions or errors (including, without limitation, typographical errors and technical errors) in the content whatsoever or for reliance thereon

2121 Pennsylvania Avenue, N.W., Washington, D.C. 20433, www.ifc.org

The material in this work is copyrighted. Copying and/or transmitting portions or all of this work without permission may be a violation of applicable law.  IFC does not guarantee the accuracy, reliability or completeness of the content included in this work, or for the conclusions or judgments described herein, and accepts no responsibility or  liability for any omissions or errors (including, without limitation, typographical errors and technical errors) in the content whatsoever or for reliance thereon.

 Share  Print Version  Email
Ratings (0)
If you are a human, do not fill in this field.
Click stars to rate.