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

Net Present Value Table


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
 Share  Print Version  Email
Comments & Ratings (0)
If you are a human, do not fill in this field.
Click stars to rate.
   Comments are truncated at 1000 characters

 

Discussion