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...
Please insert the number of years!