Welcome to Your Guide on Sensitivity Analysis!

Hello there! Today, we are diving into a crucial part of the HKICPA QP Business Finance curriculum: Sensitivity Analysis. If you have ever looked at a project's projected profit and thought, "But what if the price of raw materials goes up?" or "What if we sell fewer units than expected?", then you are already thinking like a financial manager!

Don't worry if numbers and "what-if" scenarios feel a bit overwhelming right now. We are going to break this down step-by-step using simple language and real-world logic. By the end of this guide, you will understand how to identify which factors could make or break your business project.

1. What is Sensitivity Analysis?

At its heart, sensitivity analysis is a "What-if" tool. In Business Finance, we usually calculate the Net Present Value (NPV) of a project based on certain assumptions (like selling price, labor costs, and sales volume). Sensitivity analysis tests how "sensitive" that NPV is to changes in those assumptions.

The Core Goal: To find out how much a specific variable (like sales volume) can change before the project's NPV hits zero (the break-even point).

Analogy: Imagine you are planning an outdoor BBQ. Your "success" (NPV) depends on the weather, the number of guests, and the price of steak. Sensitivity analysis is like asking: "How much can the price of steak rise before I can't afford this party anymore?"

Key Terms to Remember:

Variable: A single factor that can change (e.g., Sales Volume, Selling Price, Initial Investment, Discount Rate).
Base Case: The original set of assumptions where you calculated your first NPV.
Ceteris Paribus: A fancy Latin term meaning "all other things staying the same." In sensitivity analysis, we usually change only one variable at a time.

2. How to Calculate Sensitivity

In the HKICPA exam, you might be asked to calculate the sensitivity of a specific variable. Here is the magic formula you need:

\(\text{Sensitivity Percentage} = \frac{\text{Project NPV}}{\text{Present Value (PV) of the variable being tested}} \times 100\%\)

Wait, what does the answer mean?
The smaller the percentage, the more sensitive the project is to that variable. This is because a tiny change in that factor could turn your profit into a loss.

Step-by-Step Calculation Example:

Let's say a project has an NPV of \$10,000. The Present Value of Sales Revenue is \$100,000. To find out how sensitive the project is to changes in sales revenue:

1. Identify NPV: \$10,000
\n2. Identify PV of the variable (Sales): \$100,000
3. Apply formula: \( \frac{10,000}{100,000} \times 100\% = 10\% \)

The Interpretation: If your sales revenue drops by more than 10%, your project's NPV will become negative. You now know that sales revenue is a "critical" factor!

Quick Review:

Low % = High Risk: The project is very sensitive to this factor.
High % = Low Risk: The project can withstand a lot of change in this factor.

3. Evaluating Specific Variables

Different variables affect the project differently. Here is how we look at the most common ones:

A. Initial Investment

This is usually the easiest. If your NPV is \$20,000 and your initial cost is \$200,000, the sensitivity is 10%. If the equipment costs 10% more than expected, your NPV hits zero.

B. Sales Volume vs. Selling Price

Be careful here! A change in Selling Price usually affects only the revenue. However, a change in Sales Volume might affect both revenue and variable costs. Always read the question carefully to see if costs change along with volume.

C. The Discount Rate (Cost of Capital)

Calculating sensitivity for the discount rate is a little different. We find the Internal Rate of Return (IRR). The "sensitivity margin" is the difference between your IRR and your Cost of Capital (WACC).

Example: If your WACC is 10% and your IRR is 15%, the discount rate can rise by 5% (or 50% of its current value) before the project becomes unviable.

Summary Takeaway: Sensitivity analysis helps management prioritize. If the "Selling Price" sensitivity is only 2%, management should spend a lot of time researching market prices!

4. Strengths and Weaknesses (Exam Favorite!)

The examiners love to ask you to "critically evaluate" sensitivity analysis. Here is a cheat sheet for your written answers:

Advantages (The Good News):

  • Simple to understand: It presents information in an easy-to-digest percentage format.
  • Identifies Critical Areas: It shows management exactly which variables need the most "babysitting."
  • Helps in Information Gathering: If a variable is highly sensitive, it justifies spending money on better market research.

Disadvantages (The Reality Check):

  • One variable at a time: It assumes variables are independent. In real life, if you raise your Selling Price, your Sales Volume will likely fall. Sensitivity analysis often ignores this link.
  • No Probabilities: It tells you how much a variable can change, but it doesn't tell you how likely it is to change. A 1% sensitivity is scary, but if that variable is "Fixed Rent," it's very unlikely to change!
  • Doesn't provide a "Decision Rule": It doesn't tell you "Accept" or "Reject"; it just provides more information for the decision.

Memory Aid: Think of sensitivity analysis as a Spotlight. It shines a bright light on the most dangerous parts of a project, but it doesn't tell you if it's actually going to rain.

5. Common Pitfalls to Avoid

Don't worry if this seems tricky at first; many students make these mistakes:

1. Using the wrong denominator: Always divide NPV by the Present Value of the variable, not the total cash flow or the undiscounted amount.
2. Forgetting the direction: For costs (like labor), an increase is bad. For revenues (like price), a decrease is bad. The sensitivity percentage usually refers to the "adverse" change.
3. Confusing Sensitivity with Scenario Analysis: Remember, Sensitivity = 1 variable changes. Scenario = A whole "story" changes (e.g., "The Recession Scenario" where price, volume, and costs all change at once).

Sensitivity analysis is the first step in Risk Management. Once you identify a sensitive variable, you can manage the risk. For example:

If the project is highly sensitive to the price of Copper, the company might use a forward contract to lock in the price. This turns a "sensitive" variable into a "fixed" cost!

Quick Review Box

1. Purpose: Measures how NPV changes when one variable changes.
2. Calculation: \(\frac{\text{NPV}}{\text{PV of Variable}} \times 100\%\).
3. Interpretation: The lower the %, the higher the risk.
4. Limitation: Only changes one variable at a time; ignores probability.

You've got this! Sensitivity analysis is just a way to make sure we aren't being too optimistic. Keep practicing those PV calculations, and this will become second nature!