Sensitivity Analysis

In the previous section, we discussed the importance of adjusting for risk and uncertainty in investment appraisal. One of the key tools used in this process is sensitivity analysis. Sensitivity analysis helps us understand how changes in key variables can impact the outcome of an investment appraisal.

When conducting sensitivity analysis, we identify the key variables that have the most significant impact on the investment appraisal. These variables can include factors such as sales volume, production costs, interest rates, and inflation rates. By varying these variables and observing the resulting changes in the investment appraisal metrics, we can gain insights into the sensitivity of the investment to different Examples.

There are several methods we can use to conduct sensitivity analysis, including:

1. Example Analysis:In Example analysis, we create different Examples by varying the values of the key variables. For each Example, we calculate the investment appraisal metrics such as net present value (NPV) and internal rate of return (IRR). This allows us to compare the outcomes of different Examples and understand the range of potential outcomes.
2. Sensitivity Graphs:Sensitivity graphs are visual representations of the impact of key variables on investment appraisal metrics. By plotting the values of the key variables on the x-axis and the investment appraisal metrics on the y-axis, we can observe the relationship between the variables and the metrics. This helps us identify the variables that have the most significant impact on the investment appraisal.
3. Tornado Diagrams:Tornado diagrams are another graphical tool used in sensitivity analysis. They show the relative importance of each variable by displaying the range of possible values for each variable and the corresponding impact on the investment appraisal metrics. The variables with the largest impact are shown at the top of the diagram.

By conducting sensitivity analysis, we can better understand the risks and uncertainties associated with an investment. This allows us to make more informed decisions and develop contingency plans to mitigate potential risks.

Let’s consider an example to illustrate the importance of sensitivity analysis. Suppose we are evaluating an investment in a new product line. The key variables that impact the investment appraisal are the sales volume and the production costs.

In the base case Example, we assume a sales volume of 10,000 units per year and production costs of £50 per unit. Based on these assumptions, the investment appraisal metrics indicate a positive net present value (NPV) and internal rate of return (IRR).

However, through sensitivity analysis, we discover that the investment is highly sensitive to changes in sales volume. If the sales volume decreases to 8,000 units per year, the NPV becomes negative and the IRR falls below the required rate of return. This indicates a high level of risk associated with the investment.

With this insight, we can develop contingency plans to mitigate the risk. For example, we can explore strategies to increase the sales volume through marketing initiatives or product differentiation. By understanding the sensitivity of the investment to changes in sales volume, we can make more informed decisions and take appropriate actions to ensure the success of the investment.

In conclusion, sensitivity analysis is a valuable tool in investment appraisal that helps us understand the impact of changes in key variables on the outcome of an investment. By conducting sensitivity analysis, we can identify the variables that have the most significant impact and develop strategies to mitigate potential risks. This allows us to make more informed decisions and increase the chances of a successful investment.

Sensitivity Analysis Examples

In the previous section, we discussed the importance of adjusting for risk and uncertainty in investment appraisal reports. One of the techniques used to assess the impact of these factors is sensitivity analysis. In this section, we will provide some examples of sensitivity analysis calculations using hypothetical figures.

Example 1: Sensitivity Analysis for Net Present Value (NPV)

Let’s consider a hypothetical investment project with an initial cost of £100,000 and expected cash flows of £30,000 per year for the next five years. The discount rate used for the NPV calculation is 10%. However, we want to assess the impact of a potential change in the discount rate.

In this example, we can see that a decrease in the discount rate from 10% to 8% leads to a decrease in the NPV from £21,544 to £18,251. On the other hand, an increase in the discount rate to 12% results in an increase in the NPV to £24,477. This demonstrates the sensitivity of the investment project’s profitability to changes in the discount rate.

Example 2: Sensitivity Analysis for Payback Period

Now let’s consider another hypothetical investment project with an initial cost of £200,000 and expected cash inflows of £50,000 per year. The payback period is calculated by dividing the initial cost by the annual cash inflows.

In this example, we can see that the payback period for the investment project is between 3 and 4 years. If the payback period is set as a maximum of 3 years, the project would be considered acceptable as the initial cost is recovered within the specified timeframe. However, if the payback period is extended to 4 years, the project would not meet the required criteria. This demonstrates the sensitivity of the investment project’s acceptability to changes in the payback period.

Conclusion

Sensitivity analysis is a valuable tool in investment appraisal as it allows us to assess the impact of changes in key variables on the financial viability of a project. By conducting sensitivity analysis, we can identify the level of risk and uncertainty associated with an investment and make informed decisions based on the results. The examples provided in this section illustrate how sensitivity analysis can be used to evaluate different investment Examples and inform decision-making processes.

Next, we will discuss probability analysis, another technique used to assess risk and uncertainty in investment appraisal.