
Chapter 4: DCF: risk analysis
© EWP Go to www.emilewoolfpublishing.com for Q/As, Notes & Study Guides 109
Confidence levels for values within a range
We can use normal distribution tables to calculate, at a given confidence level, that
the value of an item will be within a specified range of values above and below the
mean.
For example, suppose that a simulation model produces results showing that the EV
of the NPV for a project is $125,000 and the standard deviation (project volatility) is
$40,000. We can predict at the 95% confidence level that the NPV of the project will
be within a specified range around the EV.
To establish a 95% confidence level for the range around the NPV, we need to
identify the range of values below the mean that represent 47.5% of total
probabilities and the range of values above the mean that represent 47.5% of total
probabilities (since 2 × 47.5% = 95%).
We therefore need to identify the number of standard deviations from the mean that
cover 47.5% of all probabilities. From the normal distribution table, we can identify
that this is 1.96 standard deviations.
At a 95% confidence level, we can therefore predict that the NPV will be somewhere
in the range between 1.96 standard deviations below the mean and 1.96 standard
deviations above the mean.
Similarly, at a 99% confidence level, we can predict that the NPV will be somewhere
in the range between 2.575 standard deviations below the mean and 2.575 standard
deviations above the mean. (This is because there is a probability of 0.4950 that the
value will be 2.575 standard deviations below the mean and a probability of 0.4950
that the value will be 2.575 standard deviations above the mean.)
Example
A simulation model has been used to calculate the expected value of the NPV of a
project. This is + $150,000. The standard deviation of the project is $55,000.
The variability in the NPV approximates to a normal distribution. (This is usual for
the output results from a simulation model.)
At the 95% confidence level, we can predict that the NPV of the project will be in the
range of 1.96 standard deviations above and below the mean. 1.96 × $55,000 =
$107,800. At the 95% confidence level, we can therefore predict that the NPV will be
somewhere in the range $42,800 to $257,800.
At the 99% confidence level, we can predict that the NPV of the project will be in the
range of 2.57 standard deviations above and below the mean. 2.57 × $55,000 =
$141,350. At the 99% confidence level, we can therefore predict that the NPV will be
somewhere in the range + $8,650 to $291,350.