Why Construct Project Scenarios?
A single NPV forecast can conceal how much the decision depends on operating conditions. A project may look attractive if customer demand is strong, selling prices hold, and input costs remain controlled, but unattractive if demand is weak while prices and costs move adversely. Scenario analysis makes those combined outcomes visible by calculating project value under several deliberately described sets of assumptions.
A scenario is not a prediction with certainty, and “best,” “base,” and “worst” do not automatically mean equally likely outcomes. They are organized cases for examining how a coherent operating story affects cash flows and NPV. Unless probabilities are explicitly given and a probability-weighted value is requested, calculate and report each scenario’s NPV separately.
From an Operating Story to NPV
Start by stating which assumptions define each case. For an operating project, those assumptions might include sales volume, selling price, variable cost per unit, and fixed operating cost. Move the related assumptions together to express a scenario that makes sense as a whole. For example, a weak-demand case might also involve discounting to maintain sales and less favorable purchasing terms. Combining the most favorable value of every input into one “best” case is not a substitute for explaining why those inputs could occur together.
After defining each bundle, translate it into period-by-period cash flows using the same accounting and cash-flow conventions across cases. Under the standard project-valuation model, NPV is the present value of future project cash flows less the time-zero investment. If \(C_t\) is the project’s net cash flow at the end of year \(t\), \(I_0\) is the initial outlay, and \(i\) is the effective annual required return, then:
This form assumes annual periods, end-of-year cash flows, and a constant effective annual discount rate. If a cash flow occurs at a different time, discount it for the actual time period under the stated rate convention. In scenario analysis, analysts often hold the discount rate fixed so that the difference in NPV reflects the operating assumptions being compared. If the required return is changed between cases, state why and identify that the comparison now reflects both cash-flow and discount-rate changes.
Deriving Operating Cash Flow After Tax
A useful bridge from operating assumptions to project cash flow is annual operating cash flow after tax. Let EBITDA be revenue less cash operating costs, let \(D\) be depreciation, and let \(T\) be the tax rate. Under the assumptions that depreciation is tax-deductible, the project has positive taxable operating income, and taxes are paid in the same period, taxable operating income is \(\text{EBITDA}-D\). Cash operating flow after tax is EBITDA less tax, because depreciation is not a cash payment.
The second form follows by distributing \(T\): \(\text{EBITDA}-T\text{EBITDA}+TD=\text{EBITDA}(1-T)+TD\). The term \(TD\) is the tax reduction attributable to deducting depreciation. This formula does not by itself handle a tax loss when the tax benefit cannot be used immediately, nor does it include capital expenditures, working-capital investment, or asset-sale taxes. Those items must be included separately when relevant.
Specify the operating assumptions and explain which conditions make the case favorable, central, or adverse.
Calculate operating cash flow under each case, then include investment, working capital, and terminal cash flows at their correct dates.
Use the stated rate and timing convention to calculate a separate NPV for each case.
Report what the cases show about value and decision exposure; do not treat the cases as probabilities unless probabilities are supplied.
Worked Example: Building Three Operating Scenarios
A hypothetical four-year project requires equipment costing $320 thousand and initial working capital of $20 thousand. The equipment’s expected end-of-year-4 salvage value is $32 thousand. It is depreciated straight-line from $320 thousand to $32 thousand over four years. The working capital is recovered at the end of year 4. The effective annual required return is 10%, the tax rate is 25%, and annual operating assumptions remain constant within each scenario. Assume all cases have positive taxable operating income, taxes are paid each year, salvage equals the equipment’s book value at disposal, and there are no other cash flows. Calculate the worst-, base-, and best-case NPVs.
Method. First construct each case’s annual EBITDA from units, price, variable cost, and fixed cost. Then calculate after-tax operating cash flow and discount operating and terminal cash flows. The scenario bundles represent, respectively, weak demand and pricing with high costs; central operating assumptions; and stronger demand and pricing with operating efficiencies.
Depreciation is \((320-32)/4=72\) thousand dollars per year. The time-zero outlay is \(320+20=340\) thousand dollars. The terminal cash flow is \(32+20=52\) thousand dollars: salvage plus recovery of working capital.
| Scenario | Units | Price per unit | Variable cost per unit | Annual fixed cost |
|---|---|---|---|---|
| Worst | 9,000 | $85 | $55 | $190 thousand |
| Base | 10,000 | $90 | $50 | $180 thousand |
| Best | 11,000 | $95 | $45 | $170 thousand |
Worst case. Revenue is \(9{,}000(85)=\$765{,}000\), or $765 thousand. Variable cost is \(9{,}000(55)=\$495{,}000\), or $495 thousand. Thus EBITDA is \(765-495-190=80\) thousand. Taxable operating income is \(80-72=8\) thousand, tax is \(0.25(8)=2\) thousand, and annual after-tax operating cash flow is \(80-2=78\) thousand.
Base case. Revenue is \(10{,}000(90)=\$900{,}000\), variable cost is \(10{,}000(50)=\$500{,}000\), and EBITDA is \(900-500-180=220\) thousand. Taxable operating income is \(220-72=148\) thousand, tax is \(0.25(148)=37\) thousand, and annual after-tax operating cash flow is \(220-37=183\) thousand.
Best case. Revenue is \(11{,}000(95)=\$1{,}045{,}000\), variable cost is \(11{,}000(45)=\$495{,}000\), and EBITDA is \(1{,}045-495-170=380\) thousand. Taxable operating income is \(380-72=308\) thousand, tax is \(0.25(308)=77\) thousand, and annual after-tax operating cash flow is \(380-77=303\) thousand.
At 10%, the four-year annuity factor is \(1/1.10+1/1.10^2+1/1.10^3+1/1.10^4=3.1698654\), and the year-4 discount factor is \(1/1.10^4=0.6830135\). Therefore:
Rounded to two decimals in thousands, the NPVs are \(-\$57.23\) thousand, \(\$275.60\) thousand, and \(\$655.99\) thousand. The negative worst-case NPV means that this case destroys value at the stated required return; the positive base and best cases do not guarantee that the project will achieve those values.
Check. In every case, year-4 cash flow includes the $52 thousand terminal amount in addition to that year’s operating cash flow. The salvage value is not taxed in this example because it equals book value. The common mistake avoided is to omit working-capital recovery or to add it at time zero rather than at the project’s end.
Scenario NPVs With a Changing Operating Forecast
Operating cash flow need not be the same in every year. A base case might assume gradual customer adoption; a downside case might assume slower adoption; and an upside case might assume faster uptake. Once each scenario has produced its own annual cash-flow forecast, discount each year’s amount separately. Do not multiply one year’s cash flow by an annuity factor unless the cash flow is in fact level over the relevant years.
Worked Example: Unequal Annual Cash Flows and a Terminal Recovery
A hypothetical project requires equipment costing $250 thousand and working capital of $15 thousand at time 0. At the end of year 3, the equipment is sold for $25 thousand and all $15 thousand of working capital is recovered. The following figures are the project’s annual after-tax operating cash-flow forecasts, in thousands, under three operating scenarios. The effective annual required return is 8%; all annual cash flows occur at year-end. Assume the terminal sale has no additional tax effect. Calculate each scenario’s NPV.
| Scenario | Year 1 operating cash flow | Year 2 operating cash flow | Year 3 operating cash flow |
|---|---|---|---|
| Worst | $90 thousand | $95 thousand | $100 thousand |
| Base | $110 thousand | $125 thousand | $140 thousand |
| Best | $130 thousand | $155 thousand | $180 thousand |
The time-zero outlay is \(250+15=265\) thousand dollars. Year 3 receives the operating cash flow plus terminal receipts of \(25+15=40\) thousand. The discount factors are \(1/1.08=0.9259259\), \(1/1.08^2=0.8573388\), and \(1/1.08^3=0.7938322\).
Worst case. Present value is \(90(0.9259259)+95(0.8573388)+(100+40)(0.7938322)\). The three terms are \(83.3333\), \(81.4472\), and \(111.1365\) thousand dollars. Their sum is \(275.9170\) thousand, so NPV is \(275.9170-265=\$10.9170\) thousand.
Base case. Present value is \(110(0.9259259)+125(0.8573388)+(140+40)(0.7938322)\). The terms are \(101.8518\), \(107.1674\), and \(142.8898\) thousand dollars. Their sum is \(351.9090\) thousand, so NPV is \(351.9090-265=\$86.9090\) thousand.
Best case. Present value is \(130(0.9259259)+155(0.8573388)+(180+40)(0.7938322)\). The terms are \(120.3704\), \(132.8875\), and \(174.6421\) thousand dollars. Their sum is \(427.9000\) thousand, so NPV is \(427.9000-265=\$162.9000\) thousand.
Rounded to two decimals in thousands, the scenario NPVs are $10.92 thousand, $86.91 thousand, and $162.90 thousand. The key timing check is that working-capital recovery and salvage are discounted from year 3, not treated as year-1 receipts.
What the Scenario Range Does—and Does Not—Say
The range of scenario NPVs helps decision-makers see whether the project remains attractive under adverse operating assumptions and how much its value varies across the cases examined. A positive base-case NPV accompanied by a negative worst-case NPV is a warning that the decision is exposed to downside conditions. A positive NPV in all three cases is more robust against the particular assumptions included, but it does not rule out outcomes outside those cases.
Scenario analysis is distinct from one-variable sensitivity analysis. Sensitivity analysis changes one input while holding others fixed to measure the effect of that input. A scenario deliberately changes a bundle of assumptions to describe a broader operating situation. The bundle should be explained in words as well as shown in a table, so the reader can understand why the assumptions belong together.
Keep the following controls in view when constructing and presenting cases:
- Keep timing consistent. Place each operating cash flow, investment, tax payment, terminal receipt, and working-capital recovery in the period when it occurs.
- Keep units consistent. If cash flows are in thousands, express the initial outlay and all terminal amounts in thousands as well.
- Use the same valuation method. Apply the same NPV formula and stated discount-rate convention to each case unless the analysis explicitly justifies a change.
- Label assumptions, not certainties. “Best case” is a favorable constructed case, not a guarantee that the project will perform that way.
- Do not infer probabilities. Three scenarios do not imply that each has a one-third chance of occurring.
A common exam trap is to calculate cash flows for one scenario but use another scenario’s terminal value, working-capital balance, or tax assumption. The correction is to maintain a complete, clearly labeled set of inputs and cash flows for each case, then calculate NPV from that case alone. Also avoid ranking a project solely by its best-case NPV: the decision should reflect the full set of stated outcomes and the decision-maker’s criteria.
Check Your Understanding
For each problem, use the stated effective annual rate and year-end timing. Report money to the nearest cent unless amounts are stated in thousands.
- A two-year project costs $100 at time 0 and produces $60 at each year-end. At an effective annual required return of 10%, calculate its NPV. (Answer: $4.13)
- A project costs $150 thousand and has no terminal cash flow. Its annual after-tax cash flow is $60 thousand in the downside case and $90 thousand in the upside case, level for two years. At an effective annual required return of 10%, calculate both NPVs. (Answer: downside NPV = \(-\$45.87\) thousand; upside NPV = \(\$6.20\) thousand)
- A four-year project costs $200 thousand, has no salvage value or working capital, and depreciates straight-line to zero. Its annual EBITDA is $90 thousand in the downside case and $110 thousand in the base case. The tax rate is 25%, all taxable income is positive, and the effective annual required return is 10%. Calculate both NPVs. (Answer: downside NPV = \(\$53.59\) thousand; base-case NPV = \(\$101.14\) thousand)
- Equipment costs $240 thousand and working capital of $15 thousand is required at time 0. Annual after-tax operating cash flow is $75 thousand for three years; at year 3, equipment is sold for $20 thousand and the working capital is recovered. At an effective annual required return of 8%, with no tax effect on the sale, calculate NPV. (Answer: \(-\$33.93\) thousand)
- A project costs $300 thousand and has no terminal cash flow. Its year 1, 2, and 3 after-tax operating cash flows, in thousands, are respectively: worst case \(100,90,80\); base case \(120,120,100\); best case \(140,150,160\). At an effective annual required return of 10%, calculate all three NPVs and identify which cases have positive NPV. (Answer: worst = \(-\$74.61\) thousand; base = \(-\$16.60\) thousand; best = \(\$71.45\) thousand; only the best case has positive NPV)