🎯 Why Risk Analysis Is Important

Investment decisions often involve uncertainty in cash flows, costs, market conditions, and assumptions. Risk analysis helps decision-makers:

• Understand the impact of variability on outcomes (e.g., NPV or IRR)

• Prepare for downside scenarios

• Make informed, risk-aware choices

---

🔍 1. Sensitivity and Scenario Analysis

These are two foundational tools for quantifying uncertainty.

---

🔹 A. Sensitivity Analysis

What it does: Tests the effect of changing one input at a time on a project’s output (e.g., NPV, IRR).

Use case: Identify which inputs the investment is most sensitive to.

Excel Tip: Use a Data Table or Tornado Chart to visualize sensitivity.

---

🔹 B. Scenario Analysis

What it does: Examines outcomes under multiple input changes simultaneously, reflecting real-world complexity.

Use case: Evaluate the range of possible outcomes and prepare for adverse conditions.

---

🧮 2. Break-Even Analysis

✅ What is it?

Break-even analysis finds the point where the project’s net cash flows = 0, i.e., where it neither makes nor loses money.

📘 Formula (Simple):

Break-even volume=Fixed CostsSelling Price−Variable Cost per Unittext{Break-even volume} = frac{text{Fixed Costs}}{text{Selling Price} – text{Variable Cost per Unit}}Break-even volume=Selling Price−Variable Cost per UnitFixed Costs​

In capital budgeting, we apply break-even logic to NPV:

• Break-even sales level: At what volume is NPV = 0?

• Break-even price: Minimum sale price to make the project viable

Use case: Helps evaluate risk exposure and define minimum performance thresholds.

---

🌳 3. Real Options and Decision Trees

🔹 A. Real Options Analysis

Definition: Real options give managers the right—but not the obligation—to make future decisions based on new information, similar to financial options.

Use case: Adds strategic flexibility to project valuation, especially under high uncertainty.

📌 Real options can be valued using:

• Decision trees

• Binomial models

• Black-Scholes (in some cases)

---

🔹 B. Decision Tree Analysis

What it does: Graphically represents sequential decisions and chance events.

Example:

• Start project → Success (60%, $10M NPV) or Failure (40%, -$5M NPV)

🧠 Multiply outcomes by their probabilities and compute the Expected Monetary Value (EMV).

Use case: Projects with multiple decision points (e.g., R&D, phased investments)

---

📉 4. Risk-Adjusted Discount Rates (RADR)

✅ What is it?

Adjusting the discount rate used in NPV to reflect the riskiness of a specific project.

📘 Formula:

NPV=∑Ct(1+radjusted)t−C0NPV = sum frac{C_t}{(1 + r_{text{adjusted}})^t} – C_0NPV=∑(1+radjusted​)tCt​​−C0​

Where radjustedr_{text{adjusted}}radjusted​ > WACC for riskier projects.

Use case: Incorporates uncertainty directly into valuation. Common in venture capital or project finance.

🧾 Alternatives:

• Use certainty-equivalent cash flows instead of adjusting the rate.

---

✅ Summary Table: Risk Analysis Tools