## Investment Decision (5): Sensitivity Analysis

In this post we will cover the topic of sensitivity analysis and uncertainty related to expected return of an investment.

## Uncertainty

When evaluating an investment, it’s important to do as much data gathering and analysis as possible. Good analysis will help you have a greater understanding of the associated costs and returns. However, even the most well-prepared analysis must face the uncertainty of the future. No matter how large your spreadsheet is, no one can predict the future with certainty.

Uncertainty means that some of your assumptions regarding costs, reinvestment, expenses, returns, etc. may be over- or under-estimated. No. It is almost certain your assumption will be wrong. But if we’re certain that we’ll be wrong, how can we make a useful evaluation?

With uncertainty or sensitivity analysis we can use statistical models to tell us which of the parameters in our model will have the biggest impact on the investment evaluation. Furthermore, statistical analysis will help us have a better understanding of the variance in outcomes

## What-If Scenario

Simply put, sensitivity analysis is nothing more than setting up several “What-if” scenarios, testing those assumptions and see how they impact the outcome of the evaluation. For example:

• What if the revenue is 15% lower than expected?
• What is the impact if our margin is 5 base points lower than expected?
• What happens if we’re only able to raise 60% of the funds we need?

Defining a what if scenario allows you to reconsider your assumptions. It’s likely that you have a gut feeling which of the parameters will influence your evaluation most. But to increase confidence you can run the numbers.

There are many ways to do sensitivity analysis. For small projects, simply running the numbers manually in an excel sheet will work just fine. For larger projects you may want to consider professional software.

Below you can find one example of a basic sensitivity analysis and a more advanced sensitivity analysis.

## Sensitivity Analysis Example (Basic)

For the basic sensitivity analysis, I use an example of an equity valuation of a Singaporean mobile app. For this project, it was important to make assumptions about all related costs on an annual basis. The result was an equity valuation using the discounted cash flow model.

In my base model, the valuation of the project was approximately SG \$35.6M.

To do sensitivity analysis, I described 10 additional scenarios varying one or more of the eight different parameters. I ran the numbers for each scenario and laid them out in a separate excel sheet. As you can see, the equity valuation now ranges between SG -\$8.5M and SG \$35.6M with an average value of SG \$18.8M.