Break-Even Sensitivity Analysis
Break-even sensitivity analysis turns the usual question around. Instead of asking what NPV results from a given input, it asks how far an input can move before NPV hits zero. That critical value is the red line where the project flips from creating value to destroying it. The gap between the expected value and the critical value is the project’s margin of safety on that driver. Note the contrast with accounting break-even, which only asks what sales make accounting profit zero. NPV break-even is stricter because it requires the project to cover its full cost of capital, not merely its reported costs.
Why it matters
Picture each assumption as a tightrope. The expected value is where you stand, and the critical value is the edge beyond which you fall into negative NPV. A driver with a wide gap between the two is forgiving, since it can deteriorate a long way before the project fails. A driver with a narrow gap is dangerous, because a small slip ruins the investment. In Earthilizer, gross profit margin has a tight cushion, so management should watch it closely, while sales growth can fall a long way before NPV turns negative.
Formulas
Worked examples
Earthilizer assumes annual sales growth of 10 percent, and the analysis finds the project breaks even at a growth rate of 5.66 percent. Separately, the gross profit margin breaks even at 31.12 percent against a higher expected level. Which driver is more critical?
Sales growth can fall from 10 percent all the way to 5.66 percent before NPV reaches zero, a wide cushion of more than four percentage points, so the project is fairly resilient to slower growth. Gross profit margin, by contrast, can only deteriorate a small amount before hitting its 31.12 percent break-even, so a slim adverse move wipes out the value. Management should therefore guard the margin assumption far more carefully than the growth assumption. These break-even points come from the Earthilizer worked example.
Common mistakes
- ✗Break-even analysis tells you the probability the project fails. It locates the critical value where NPV is zero, but says nothing about how likely the driver is to reach it.
- ✗NPV break-even and accounting break-even are the same. Accounting break-even ignores the cost of capital, so NPV break-even requires higher sales or margins to clear the required return too.
- ✗A break-even point makes a project safe. Safety depends on the cushion between expected and critical values and on the odds of an adverse move, not on the existence of a break-even point.
- ✗Break-even on one driver accounts for the others. Each critical value holds the remaining drivers fixed, so correlated moves can breach NPV sooner than any single break-even suggests.
Revision bullets
- •Finds the critical value of a driver that pushes NPV to zero
- •The gap from expected to critical value is the margin of safety
- •NPV break-even is stricter than accounting break-even
- •NPV break-even embeds the full cost of capital, accounting break-even does not
- •Earthilizer sales growth breaks even near 5.66 percent, a wide cushion
- •Holds other drivers fixed, so correlated moves can breach NPV earlier
Quick check
The break-even value of a value driver in NPV break-even analysis is the level at which
Why is NPV break-even generally more demanding than accounting break-even?
Connected topics
Sources
- Titman & Martin, Ch. 3Titman, S., & Martin, J. D. Valuation: The Art and Science of Corporate Investment Decisions. Pearson.Sets out break-even sensitivity analysis and the critical values of a project’s value drivers.