Net Present Value and risk assessment for investments projects

With this application you can calculate the net present value (NPV) for an investment project and assess its risk using the Monte Carlo method.

Net Present Value (NPV) analysis is a form of intrinsic valuation and it is used across finance and accounting for determining the value of a business, investment security, capital project, new venture or cost reduction program. NPV is a measure of a project success reflecting the present value of its cash flows.

Cash flows are usually uncertain since both revenues and expenditure related to the project concern the future. Additionally, probabilities of particular scenarios may be unknown due to many factors (e.g. lack of historical data, lack of sufficient knowledge about possible states of nature etc.).

Monte Carlo simulation can assess a project's stand-alone risk. A project is analyzed under a large number of scenarios with values that are then used to calculate individual NPVs. In each trial, it is chosen at random a “sample” value for each input parameter, respecting the relative frequencies of its probability distribution. This process is repeated, generating as many NPVs we choose. The mean of the NPVs is determined and used as a measure of the project’s expected profitability, and the standard deviation of the NPVs or the probability for resulting NPV > 0 are used as measures of risk.

So...

What is the Net Present Value?

The net present value (NPV) is the value of a project. This is simply the present value of the project’s free cash flows discounted at the cost of capital over the life of a project.

The NPV tells us how much a project contributes to shareholder wealth; the larger the NPV, the more value the project adds—and added value means a higher stock price. This is why the NPV is the best selection criterion, primarily because it addresses directly the central goal of financial management—maximizing shareholder wealth.

That is, a project with a NPV of $1 million is expected to increase shareholder wealth by $1 million. Thus, projects with positive NPV (NPV > 0) are expected to add to shareholder wealth while projects with negative NPV (NPV < 0) should be shunned.

The NPV is used in capital budgeting to analyze the profitability of a projected investment.

Let's begin!

Year Revenues Expenditures

Your results

Net present value =

Number of iterations = 100,000

Distribution: uniform - lower: 0; upper: 1

Please insert the number of years!