Calculating Switching Values for Project Assumptions

Introduction

A project evaluation depends on estimates: the initial investment, future prices, sales, and operating costs. Sensitivity analysis asks how NPV changes when an assumption changes. A switching value takes that question one step further: it identifies the specific value of an assumption at which a decision changes. That change may be from positive to negative NPV, or from one project having the higher NPV to another having the higher NPV.

The calculation is an algebra problem built on the NPV model. Specify the cash flows and discount rate, express NPV in terms of the changing input, and solve either for NPV equal to zero or for two NPVs equal to each other. A switching value is not, by itself, a forecast or a probability statement.

Definition: A zero-NPV switching value is the value of a project assumption at which the project's NPV equals zero, holding the other stated assumptions fixed. A project-ranking switching value is the value at which the NPVs of two projects are equal. The relevant choice, including whether to reject both projects, must be assessed using the NPVs on either side of the switching value.

Set Up the NPV Equation

For a project with an initial outlay $I_0$ at time 0 and cash flows $C_t$ at the ends of years $t=1,\ldots,n$, the NPV at effective annual discount rate $i$ is

\operatorname{NPV}=-I_0+\sum_{t=1}^{n}\frac{C_t}{(1+i)^t}.

This model assumes the cash-flow timing is stated correctly, the annual rate is appropriate and consistent with the periods, and the cash flows used are the project's relevant cash flows for the decision. In the examples below, cash flows are deterministic, occur at year-end, and are evaluated at a fixed discount rate. Unless stated otherwise, taxes, financing effects, and changes in working capital are excluded. In an applied model they must be incorporated where relevant.

A convenient case occurs when one assumption $x$ changes cash flows linearly, while timing and discount rate remain fixed. Write each cash flow as $C_t(x)=a_t+b_t x$. Then

\operatorname{NPV}(x) =-I_0+\sum_{t=1}^{n}\frac{a_t+b_t x}{(1+i)^t} =A+Bx,

where $A=-I_0+\sum a_t/(1+i)^t$ and $B=\sum b_t/(1+i)^t$. If $B\ne 0$, the zero-NPV value is $x=-A/B$. If comparing projects $A$ and $B$, express their difference as $\operatorname{NPV}_A(x)-\operatorname{NPV}_B(x)$; the ranking switch occurs where that difference is zero.

Why the Switching-Value Equation Works

The method follows directly from the definition of NPV. For one project, changing the assumption changes the cash flows and therefore their present values. The zero-NPV threshold is the point at which those present values exactly offset the initial investment. For a comparison, equal NPVs mean the discounted advantage of one project's cash flows exactly offsets its additional investment or other disadvantages.

\operatorname{NPV}(x)=A+Bx=0 \quad\Longrightarrow\quad x=-\frac{A}{B}, \qquad B\ne 0.

For two projects with linear NPVs, write $\operatorname{NPV}_A(x)=A_A+B_Ax$ and $\operatorname{NPV}_B(x)=A_B+B_Bx$. Equating the two gives

(A_A-A_B)+(B_A-B_B)x=0 \quad\Longrightarrow\quad x=-\frac{A_A-A_B}{B_A-B_B}, \qquad B_A\ne B_B.

If the coefficient of $x$ is zero, there is no unique switching value: the NPVs are either equal for every value in the model or never equal. If cash flows are nonlinear in the assumption, the equation may instead be quadratic, piecewise, or require numerical solution. In all cases, check that the solution is within the economically meaningful range and satisfies the assumptions used to derive it.

State the decision and the changing input.
Identify whether the target is one project's NPV equal to zero or two project NPVs equal to one another. Hold all other assumptions fixed.

Write cash flows as functions of the input.
Keep the time period, sign, and units of each cash flow explicit. Discount each amount at its actual time.

Solve the appropriate equation.
Set one NPV to zero for an acceptability threshold, or subtract the project NPVs and set the difference to zero for a ranking threshold.

Interpret and verify.
Substitute the result into the original NPV equation, compare values on either side if needed, and check feasibility and the do-nothing alternative.

Worked Applications

Worked Example: Maximum Initial Investment at Zero NPV

A hypothetical equipment project requires an initial investment $I_0$, produces end-of-year net cash inflows of $28,000 in each of years 1, 2, and 3, and has a $5,000 salvage cash flow at the end of year 3. Use an effective annual discount rate $i=10\%$. Find the maximum initial investment that gives NPV equal to zero, then find the NPV if the quoted investment is $70,000.

Method. Treat the initial investment as the input to be switched. At zero NPV, it must equal the present value of all future project cash flows. The common mistake is to discount the salvage amount as though it occurred in year 1; it occurs at the end of year 3.

The year-end discount factors are $1/1.10=0.9090909$, $1/1.10^2=0.8264463$, and $1/1.10^3=0.7513148$. The annuity factor for three end-of-year payments is $a_{\overline{3}|}=2.486851991$. Thus the inflows have present value $28{,}000(2.486851991)=$69{,}631.86$, and the salvage cash flow has present value $5{,}000(0.7513148)=$3{,}756.57$. Using unrounded factors, their total present value is $73,388.43.

Therefore the zero-NPV investment switching value is $I_0=$73{,}388.43$, rounded to the nearest cent. At an investment of $70,000, NPV is $-$70{,}000+$69{,}631.86+$3{,}756.57=$3{,}388.43$. The check is consistent: the quoted investment is below the maximum zero-NPV investment, so NPV is positive.

Worked Example: Operating-Cost Value That Changes the Project Ranking

Two hypothetical projects each run for four years, with end-of-year cash flows and no terminal value. The effective annual discount rate is $i=8\%$. Project A costs $80,000 initially and has annual gross cash benefits of $42,000, less an unknown annual operating cost $c$. Project B costs $68,000 initially and produces annual net cash inflows of $27,000. Find $c$ at which their NPVs are equal, and determine which project has the higher NPV on each side.

Method. Subtract B's NPV from A's and solve for the zero of that difference. The common mistake is to compare annual operating cash flows alone and ignore the $12,000 difference in initial investment.

The four-year annuity factor is $a_{\overline{4}|}=3.31212684$. Therefore,

\begin{aligned} \operatorname{NPV}_A-\operatorname{NPV}_B &=(-80{,}000-(-68{,}000)) +\bigl[(42{,}000-c)-27{,}000\bigr](3.31212684)\\ &=-12{,}000+(15{,}000-c)(3.31212684). \end{aligned}

Set the difference equal to zero. Then $(15{,}000-c)(3.31212684)=12{,}000$, so $15{,}000-c=12{,}000/3.31212684=$3{,}623.05$, and $c=$11{,}376.95$, rounded to the nearest cent.

At this value, Project B's NPV is $-$68{,}000+$27{,}000(3.31212684)=$21{,}427.42$. Project A's annual net cash flow is $42,000−$11,376.95=$30,623.05, giving NPV $-$80{,}000+$30{,}623.05(3.31212684)=$21{,}427.42$, using unrounded values for the calculation. As $c$ increases, A's NPV decreases while B's remains fixed. Thus A ranks higher below the switching cost; B ranks higher above it.

Worked Example: Selling Price That Equalizes Two Project NPVs

A hypothetical three-year project comparison uses an effective annual discount rate $i=10\%$; all cash flows occur at year-end, and there are no terminal cash flows. Project A requires $50,000 initially, sells 200 units per year at price $p$, and has annual operating costs of $12,000. Project B requires $40,000 initially, sells 100 units per year at the same price, and has annual operating costs of $8,000. Find the price at which the project NPVs are equal. Then decide whether either project has positive NPV at that price.

Method. Form the difference in NPVs as a function of the common selling price. The common mistake is to call the price where rankings switch a zero-NPV price; equality between two NPVs does not mean either NPV is zero.

The three-year annuity factor is $a_{\overline{3}|}=2.486851991$. The annual cash-flow difference, A minus B, is $(200p-$12{,}000)-(100p-$8{,}000)=100p-$4{,}000$. The initial-investment difference is $-$10,000$. Therefore,

\operatorname{NPV}_A-\operatorname{NPV}_B =-10{,}000+(100p-4{,}000)(2.486851991).

Set this to zero: $100p-$4{,}000=$10{,}000/2.486851991=$4{,}021.15$. Hence $100p=$8{,}021.15$, so $p=$80.21$ per unit, rounded to the nearest cent.

At the unrounded switching price, Project B's annual net cash flow is approximately $21.15. Its NPV is $-$40{,}000+$21.15(2.486851991)$, approximately $-$39{,}947.42$. Project A's NPV is equal to that amount by construction; substitution into A's cash flows gives the same result. Both NPVs are negative, so the projects tie in ranking but neither should be selected over doing nothing on the stated NPV criterion. The check also illustrates why a ranking switch and a zero-NPV threshold answer different questions.

Interpreting a Switching Value Carefully

A switching value is conditional on the model. For a price threshold, for example, the calculation assumes the stated sales volume and costs remain fixed as price changes. In reality, changing price may change demand. Similarly, a cost threshold assumes the specified cost changes without changing output, quality, project life, or other cash flows. If assumptions are linked, changing one input in isolation may describe a mathematical sensitivity rather than a plausible business case.

A linear formula is especially useful when an input changes each year's cash flow by a fixed amount per unit of that input. For example, if annual volume $q$ produces a constant contribution per unit and fixed costs do not change, project NPV is linear in $q$. The same setup can be used to solve a zero-NPV or project-equality condition. If volume changes capacity requirements, price, or costs in steps, the cash-flow function may be nonlinear and must be modeled accordingly.

The discount rate must also match the timing and nature of the cash flows. If a cash flow occurs more than once per year, use a consistent period rate and period count, or convert the cash flows to an annual basis correctly. A rate change is not interchangeable with a cash-flow assumption change: if the rate itself is the input, the discounted terms generally make NPV nonlinear in that input.

Common Exam Traps

Discounting from the wrong date. A year-3 cash flow is divided by $(1+i)^3$, not by $1+i$.
Mixing units. If investment is in dollars and annual cash flows are in thousands of dollars, convert one side before solving.
Solving the wrong equation. Set one project's NPV to zero for an acceptability threshold; set the difference in NPVs to zero for a ranking threshold.
Ignoring the direction of the switch. A solved value does not show which project is preferred above or below it. Check the sign of the NPV difference on either side.
Assuming a tie means acceptance. Equal NPVs can both be negative, as in the price example. Compare with the no-project alternative.
Using a linear solution outside its valid range. If the answer implies negative volume, impossible capacity, or cash flows that change discontinuously, the assumed model needs revision.

Key takeaway: A switching value is found by writing NPV as a function of the chosen input and imposing the correct decision condition. Verify the result in the original cash-flow model, then interpret feasibility, ranking, and acceptability separately.

Check Your Understanding

For each problem, use the stated year-end cash flows and effective annual discount rate. Keep the stated assumptions fixed unless the question asks you to vary them.

A hypothetical project has cash inflows of $18,000 at the end of year 1 and $20,000 at the end of year 2. At $i=10\%$, find the initial investment that makes NPV zero. (Answer: $32,892.56.)
Project A costs $60,000 initially and earns $32,000 annually for three years before an annual operating cost $c$. Project B costs $50,000 initially and earns $20,000 net annually for three years. At $i=10\%$, find the operating cost at which their NPVs are equal. (Answer: $7,978.85 per year; A ranks higher below this cost.)
Two three-year projects have no terminal cash flows and use $i=10\%$. Project A costs $48,000 initially, sells 150 units annually at price $p$, and has annual costs of $6,000. Project B costs $40,000 initially, sells 90 units annually at the same price, and has annual costs of $4,000. Find the price at which their NPVs are equal. (Answer: $86.95 per unit.)
A hypothetical project costs $50,000 initially, has annual fixed costs of $5,000, and earns a contribution of $10 per unit sold for three years. If annual volume is the same each year and $i=10\%$, find the smallest whole-number annual volume that gives nonnegative NPV. (Answer: 2,511 units per year.)
A two-year project costs $30,000 initially. It produces cash inflows of $16,000 at year 1 and $12,000 plus a salvage amount $S$ at year 2. At $i=10\%$, find the salvage amount that makes NPV zero. (Answer: $6,700.)

What You'll Learn