Scenario Analysis With Correlated Forecast Drivers

Why Analyze Joint Scenarios?

A project’s value depends on several forecasts at once. Strong sales may occur alongside higher variable costs, a larger investment in working capital, or a lower discount rate. Weak demand may instead coincide with high unit costs and more expensive financing. Because these drivers can move together, assessing each one in isolation can create combinations that are inconsistent with the business conditions being modeled.

Scenario analysis addresses this by defining a small set of coherent joint outcomes. Each scenario specifies a complete set of relevant assumptions, including operating forecasts, working-capital requirements, and the discount rate appropriate to that scenario. The resulting NPVs show how project value changes across those outcomes. They do not, by themselves, guarantee that all possible outcomes have been considered or that assigned probabilities are objectively correct.

Definition: A scenario is a specified joint state of the project’s forecast drivers. A scenario NPV is the project’s net present value calculated using the cash flows and discount-rate assumptions assigned to that state. If scenarios are assigned probabilities, those probabilities must describe the joint states, be nonnegative, and sum to 1.

Use a consistent time line. A working-capital investment is a cash outflow when it increases; working capital recovered at project completion is a cash inflow. Discount each cash flow from the date it occurs. The effective annual rate $i_s$ for scenario $s$ applies once per year in these examples; a cash flow at time $t$ is discounted by $(1+i_s)^t$. A different compounding frequency requires a matching conversion of the rate and time units.

\operatorname{NPV}_s=-I_0+\sum_{t=1}^{T}\frac{CF_{t,s}}{(1+i_s)^t}

Here $I_0$ is the time-0 investment, including any initial working-capital outlay, $CF_{t,s}$ is the net project cash flow at time $t$ in scenario $s$, and $T$ is the project horizon. If the project ends at time $T$, the final cash flow includes any working capital recovered then. The discount rate should match the risk of the project cash flows being valued; a rate that does not match that risk can produce a misleading NPV.

Building a Scenario Before Discounting

First construct each scenario’s cash flows, then discount them. In a simplified setting with taxable operating margins and no depreciation or other tax adjustments, after-tax operating cash flow is $(\text{sales}-\text{cash operating costs})(1-\tau)$, where $\tau$ is the tax rate. This simplifying assumption is not a general tax model: actual project analysis may require depreciation tax shields, disposal taxes, or other tax effects.

Working capital is tracked separately from operating earnings. If working capital rises between time 0 and time 1, the increase uses cash at time 1. If all remaining working capital is released when the project ends, that release is a cash inflow at the terminal date. The next example applies this convention consistently across joint scenarios.

Worked Example: Valuing Three Joint Operating Scenarios

A hypothetical two-year project requires fixed investment of $650 and initial working capital of $100. The tax rate is 25%, and there are no depreciation deductions, salvage proceeds, or other tax adjustments. In each scenario, annual sales and cash operating costs are constant over the two years. Working capital changes at time 1 and is fully recovered at time 2. Calculate each scenario NPV and the expected NPV using the stated probabilities.

Scenario	Probability	Annual sales	Annual costs	Working capital at time 1	Annual effective discount rate
Downside	0.25	$900	$600	$140	10%
Central	0.50	$1,200	$650	$130	8%
Upside	0.25	$1,400	$700	$150	7%

Method and time-0 cash flow. The initial outflow is the $650 fixed investment plus $100 of working capital, so $I_0=650+100=750$. Apply the 25% tax rate to each scenario’s annual operating margin. At time 1, subtract the increase in working capital from the after-tax operating cash flow. At time 2, add the full release of working capital to that year’s after-tax operating cash flow.

Downside scenario. Annual pre-tax margin is $900-600=300$, giving after-tax operating cash flow $300(1-0.25)=225$ per year. Working capital rises by $140-100=40$, so $CF_{1,\text{down}}=225-40=185$. At time 2, the $140 balance is released, so $CF_{2,\text{down}}=225+140=365$. Discount at the scenario’s 10% annual rate:

\operatorname{NPV}_{\text{down}} =-750+\frac{185}{1.10}+\frac{365}{1.10^2} =-750+168.181818\ldots+301.652893\ldots \approx -280.17

Central scenario. Annual pre-tax margin is $1{,}200-650=550$, giving after-tax operating cash flow $550(0.75)=412.50$. Working capital rises by $130-100=30$. Thus $CF_{1,\text{central}}=412.50-30=382.50$ and $CF_{2,\text{central}}=412.50+130=542.50$. Discount at 8%:

\operatorname{NPV}_{\text{central}} =-750+\frac{382.50}{1.08}+\frac{542.50}{1.08^2} =-750+354.166667\ldots+465.106310\ldots \approx 69.27

Upside scenario. Annual pre-tax margin is $1{,}400-700=700$, giving after-tax operating cash flow $700(0.75)=525$. Working capital rises by $150-100=50$. Hence $CF_{1,\text{up}}=525-50=475$ and $CF_{2,\text{up}}=525+150=675$. Discount at 7%:

\operatorname{NPV}_{\text{up}} =-750+\frac{475}{1.07}+\frac{675}{1.07^2} =-750+443.925234\ldots+589.571229\ldots \approx 283.50

Expected NPV. Weight the scenario NPVs by their probabilities, using unrounded scenario values in the calculation:

E[\operatorname{NPV}] =0.25(-280.165289\ldots)+0.50(69.272977\ldots)+0.25(283.496463\ldots) \approx 35.47

The scenario NPVs range from approximately $-$280.17$ to $+$283.50$. The expected NPV is approximately $35.47. It is a probability-weighted average of the stated outcomes, not a promise that the project will produce that amount. Common mistake avoided: omitting the time-1 increase in working capital understates the initial operating cash flow, while omitting the time-2 recovery understates the terminal cash flow. Working capital must be tracked at the dates when cash is invested and recovered.

Why the Probability-Weighted NPV Formula Holds

Suppose the possible joint scenarios are indexed by $s$, with probabilities $p_s$. Let $\operatorname{NPV}_s$ be the NPV in scenario $s$. Expected NPV is the expectation of that scenario-valued outcome: multiply each possible value by its probability and add. This is the discrete definition of expected value.

E[\operatorname{NPV}]=\sum_s p_s\operatorname{NPV}_s, \qquad \sum_s p_s=1

If every scenario uses the same discount rate $i$, substitution of the NPV formula and rearrangement of finite sums gives:

\begin{aligned} E[\operatorname{NPV}] &=\sum_s p_s\left(-I_0+\sum_{t=1}^{T}\frac{CF_{t,s}}{(1+i)^t}\right)\\ &=-I_0+\sum_{t=1}^{T}\frac{\sum_s p_sCF_{t,s}}{(1+i)^t}\\ &=-I_0+\sum_{t=1}^{T}\frac{E[CF_t]}{(1+i)^t}. \end{aligned}

The rearrangement works because the discount factors and initial investment are common to the scenarios. If the discount rate changes by scenario, as it often does in risk-matched analysis, expected NPV is still the probability-weighted average of the scenario NPVs. But it generally cannot be calculated by discounting expected cash flows at an average scenario rate. The rate and cash flows belong together within each joint scenario.

Worked Example: When Average Inputs Do Not Give Expected NPV

A hypothetical one-year project requires fixed investment of $250 and initial working capital of $50. Its tax rate is 20%, and there are no other tax adjustments. Each scenario ends after one year and recovers its stated ending working capital. The joint scenarios are: weak demand with probability 0.30, sales of $500, costs of $350, ending working capital of $50, and a 12% annual discount rate; moderate demand with probability 0.50, sales of $700, costs of $400, ending working capital of $70, and a 9% rate; and strong demand with probability 0.20, sales of $900, costs of $500, ending working capital of $100, and a 6% rate. Calculate expected NPV and compare it with an NPV calculated using probability-weighted average inputs.

Method. The time-0 outflow is $250+50=300$. For each scenario, calculate after-tax operating cash flow, add the ending working-capital recovery, and discount the resulting terminal cash flow at that scenario’s rate.

Weak demand. After-tax operating cash flow is $(500-350)(0.80)=120$. The terminal cash flow is $120+50=170$, so $\operatorname{NPV}_{\text{weak}}=-300+170/1.12=-148.214286\ldots$.

Moderate demand. After-tax operating cash flow is $(700-400)(0.80)=240$. The terminal cash flow is $240+70=310$, so $\operatorname{NPV}_{\text{moderate}}=-300+310/1.09=-15.596330\ldots$.

Strong demand. After-tax operating cash flow is $(900-500)(0.80)=320$. The terminal cash flow is $320+100=420$, so $\operatorname{NPV}_{\text{strong}}=-300+420/1.06=96.226415\ldots$.

Expected NPV. Use the joint scenario probabilities and retain unrounded values:

\begin{aligned} E[\operatorname{NPV}] &=0.30(-148.214286\ldots)+0.50(-15.596330\ldots)+0.20(96.226415\ldots)\\ &\approx -33.02. \end{aligned}

For comparison, the probability-weighted averages are sales $0.30(500)+0.50(700)+0.20(900)=680$, costs $0.30(350)+0.50(400)+0.20(500)=405$, ending working capital $0.30(50)+0.50(70)+0.20(100)=70$, and discount rate $0.30(12\%)+0.50(9\%)+0.20(6\%)=9.3\%$. Plugging those averages into one calculation gives after-tax operating cash flow $(680-405)(0.80)=220$, terminal cash flow $220+70=290$, and NPV $-300+290/1.093\approx -34.68$. That is not the expected NPV of $-$33.02$.

Common mistake and correction. The incorrect calculation treats the average rate and average cash flow as if they formed a real joint outcome. In general, the expectation of a cash flow divided by its scenario discount factor is not the average cash flow divided by the average discount factor. Calculate each NPV within its coherent joint scenario, then probability-weight the NPVs. This matters especially when strong cash flows tend to occur with lower rates, or weak cash flows with higher rates.

Interpreting the Range and Downside

A scenario range is the lowest and highest NPV among the scenarios actually specified. It is not necessarily a statistical confidence interval or a bound on every possible outcome. The range can be useful for identifying the magnitude of modeled variation, while probabilities can summarize how much weight the analysis assigns to different outcomes. In particular, the probability of a negative NPV is the sum of the probabilities of all scenarios with NPV below zero.

Scenario analysis also makes assumptions visible. A scenario table should say which sales, cost, working-capital, and rate assumptions occur together. Pairing the most favorable value of every driver may create an implausible “best case”; pairing every unfavorable value may do the same for a “worst case.” Such combinations should be used only when they represent a coherent state the analyst intends to evaluate. Probabilities should be attached to the joint scenarios, not assembled by multiplying separate driver probabilities unless independence is a justified assumption.

Worked Example: Expected Value and Downside Probability Across Scenarios

A hypothetical two-year project has fixed investment of $400 and initial working capital of $40. The tax rate is 25%, with no depreciation or other tax adjustments. Working capital increases at time 1 and is fully recovered at time 2. The joint forecasts are:

Favorable: probability 0.20; sales of $600 and costs of $300 in year 1, sales of $700 and costs of $350 in year 2; working capital is $60 at time 1; discount rate is 5%.
Central: probability 0.50; sales of $550 and costs of $350 in year 1, sales of $600 and costs of $360 in year 2; working capital is $50 at time 1; discount rate is 8%.
Adverse: probability 0.30; sales of $500 and costs of $380 in year 1, sales of $520 and costs of $390 in year 2; working capital is $70 at time 1; discount rate is 12%.

Calculate the cash flows and NPVs, then report the scenario range, expected NPV, and probability of a negative NPV.

Favorable scenario. Year 1 after-tax operating cash flow is $(600-300)(0.75)=225$. Working capital increases by $60-40=20$, so $CF_1=225-20=205$. Year 2 after-tax operating cash flow is $(700-350)(0.75)=262.50$; adding the $60 working-capital release gives $CF_2=322.50$. Thus:

\operatorname{NPV}_{\text{fav}} =-440+\frac{205}{1.05}+\frac{322.50}{1.05^2} =-440+195.238095\ldots+292.517007\ldots \approx 47.76

The $440 initial outflow includes both fixed investment and initial working capital.

Central scenario. Year 1 after-tax operating cash flow is $(550-350)(0.75)=150$. Working capital rises by $50-40=10$, giving $CF_1=150-10=140$. Year 2 after-tax operating cash flow is $(600-360)(0.75)=180$; adding the $50 release gives $CF_2=230$. Therefore:

\operatorname{NPV}_{\text{central}} =-440+\frac{140}{1.08}+\frac{230}{1.08^2} =-440+129.629630\ldots+197.187929\ldots \approx -113.18

Adverse scenario. Year 1 after-tax operating cash flow is $(500-380)(0.75)=90$. The increase in working capital is $70-40=30$, so $CF_1=90-30=60$. Year 2 after-tax operating cash flow is $(520-390)(0.75)=97.50$; adding the $70 release gives $CF_2=167.50$. Therefore:

\operatorname{NPV}_{\text{adv}} =-440+\frac{60}{1.12}+\frac{167.50}{1.12^2} =-440+53.571429\ldots+133.529974\ldots \approx -252.90

The modeled NPV range is approximately $[-$252.90,\ $47.76]$. The expected NPV, calculated with unrounded scenario values, is:

E[\operatorname{NPV}] =0.20(47.755102\ldots)+0.50(-113.182441\ldots)+0.30(-252.898597\ldots) \approx -122.91

Both the central and adverse scenarios have negative NPVs, so the probability of a negative NPV is $0.50+0.30=0.80$, or 80%. The favorable scenario’s positive NPV does not make the expected NPV positive; its probability and magnitude must be considered alongside the other outcomes.

Common Traps in Scenario Analysis

Mixing incompatible assumptions. Do not combine a sales forecast from one state with a discount rate or working-capital requirement from another unless that combination is deliberately defined as a scenario.
Using average inputs as a substitute for scenario valuation. When rates vary, calculate each scenario NPV first. Discounting an average cash flow at an average rate generally does not reproduce expected NPV.
Misplacing working capital. An increase is a cash outflow when it occurs, and the balance is an inflow when recovered. Do not subtract the full working-capital balance in every year.
Rounding too early. Retain unrounded discount factors and scenario NPVs for probability-weighted totals; round the reported monetary results only at the final step.
Overstating what the range means. A minimum-to-maximum range covers the specified scenarios, not necessarily the full set of possible project outcomes.

Key takeaway: Define coherent joint scenarios, construct each scenario’s dated cash flows, and discount those cash flows at the rate assigned to that scenario. Then use scenario probabilities to calculate expected NPV or downside probability, while interpreting the range as a description of the modeled outcomes rather than a guarantee.

Check Your Understanding

For each problem, keep the operating cash flows, working-capital movements, rates, and scenario probabilities aligned. Round monetary answers to the nearest cent.

A hypothetical one-year project requires fixed investment of $300 and initial working capital of $60. The tax rate is 25%; sales are $800, cash operating costs are $500, ending working capital is $80, and the annual effective discount rate is 10%. There are no other tax adjustments. Calculate NPV. (Answer: $-$82.73$)
A hypothetical two-year project requires fixed investment of $500 and initial working capital of $50. The tax rate is 20%; annual sales are $900 and annual cash operating costs are $600 in both years. Working capital rises to $70 at time 1 and is recovered at time 2. At an annual effective discount rate of 10%, calculate NPV. (Answer: $-$93.80$)
A one-year project requires fixed investment of $150 and initial working capital of $50. There are two joint scenarios. Scenario A has probability 0.40, after-tax operating cash flow of $90, a $20 working-capital release, and a 10% annual rate. Scenario B has probability 0.60, after-tax operating cash flow of $180, a $50 release, and a 5% annual rate. Calculate each scenario NPV, expected NPV, and the probability of a positive NPV. (Answer: Scenario A NPV $=-$100.00$; Scenario B NPV $=$19.05$; expected NPV $=-$28.57$; probability of positive NPV $=0.6000$)
Two mutually exclusive joint scenarios have probabilities 0.25 and 0.75 and NPVs of $-$40$ and $+$80$, respectively. Calculate expected NPV. (Answer: $50.00)
A project has an initial outflow of $400 and scenario cash flows of $150 at time 1 and $300 at time 2. The scenario’s annual effective discount rate is 10%, and the stated cash flows already include all operating and working-capital effects. Calculate its NPV and state whether it is positive. (Answer: NPV $=-$15.70$; negative)

What You'll Learn