Forecasting the Incremental Cash Flows of a Launch
A product launch can generate substantial sales without generating an equally large increase in company cash flow. Some buyers may switch from an existing product, so part of the launch’s apparent revenue replaces revenue the company already earned. A useful forecast therefore asks what changes for the company because it launches the product, rather than treating the launch as a stand-alone business.
The central adjustment is to subtract the contribution lost on cannibalized sales. The forecast should also include costs that arise because of the launch, depreciation’s effect on taxes, and the cash tied up in working capital. Unavoidable costs that would continue whether or not the launch occurs do not belong in the incremental forecast.
From Product Sales to Incremental Operating Profit
Start with the launch product’s revenue and variable costs. Their difference is its contribution before fixed costs. Then subtract the contribution lost on existing products that the launch displaces. This adjustment is not generally equal to the displaced products’ sales revenue: the company also avoids the variable costs it would have incurred to serve those sales.
Next subtract fixed costs that are avoidable only if the project is undertaken. A cost is avoidable in this context if the company can avoid it by not launching the product. For example, an additional product-specific supervisor may be avoidable, while an allocated share of headquarters rent may not be. Depreciation is then deducted to find operating income before tax (EBIT), even though depreciation itself is not a cash payment in the period.
For a project with positive taxable EBIT, a constant tax rate \(T\), and immediate use of any tax deductions, taxes attributable to the project are \(T \times \text{EBIT}\). The corresponding operating cash flow is:
This expression assumes the project’s tax effects can be used in the period shown and that the forecast is an unlevered project forecast: financing costs are not included in operating profit. If project losses cannot be used immediately to reduce other taxable income, the tax treatment needs to reflect when those losses can actually provide a tax benefit.
Why Cannibalization Is a Lost Contribution
Suppose an existing product would have sold \(q\) units without the launch. Its unit selling price is \(p\), and its unit variable cost is \(c\). If the launch displaces those units, the company loses \(qp\) of existing-product revenue but avoids \(qc\) of variable cost. The net reduction in operating profit is therefore \(qp-qc=q(p-c)\), the contribution those units would have earned.
This is why simply subtracting the old product’s lost revenue overstates the harm from cannibalization: it ignores the costs no longer incurred. Conversely, ignoring cannibalization overstates the benefit of the launch. The incremental forecast needs both sides of the comparison.
Calculate its revenue and variable costs using the expected launch sales and the assumptions for price and unit cost.
For each existing product affected, estimate the lost units and multiply by that product’s contribution per unit.
Subtract avoidable fixed costs and depreciation; exclude unavoidable costs that do not change because of the launch.
Apply the assumed tax treatment to EBIT, add back noncash depreciation, and separately record capital expenditure and working-capital changes at their cash-flow dates.
Worked Example: A Three-Year Launch Forecast
A company is considering a launch lasting three years. Assume annual new-product sales of 12,000 units at $50 each, with a variable cost of $28 per unit. The launch is expected to displace 2,000 units per year of an existing product, which sells for $40 per unit and has a variable cost of $24 per unit. Avoidable fixed costs are $90,000 per year. Equipment costs $120,000 at time 0 and is depreciated straight-line over three years to zero book value, with no salvage proceeds. Net working capital of $30,000 is required at time 0 and fully recovered at the end of year 3. Assume a 25% tax rate, positive taxable EBIT in each year, and immediate use of tax deductions. Ignore financing costs. Find the initial cash flow and annual project cash flows.
Method. Forecast the incremental operating profit, calculate tax on that EBIT, add back depreciation to obtain operating cash flow, and then place equipment and working-capital cash flows at their specified dates.
1. New-product contribution. Revenue is \(12{,}000 \times \$50=\$600{,}000\). Variable costs are \(12{,}000 \times \$28=\$336{,}000\). The new product’s contribution is \(\$600{,}000-\$336{,}000=\$264{,}000\).
2. Cannibalized contribution. The existing product earns \(\$40-\$24=\$16\) of contribution per unit. The lost contribution is \(2{,}000 \times \$16=\$32{,}000\). Thus, operating contribution after cannibalization is \(\$264{,}000-\$32{,}000=\$232{,}000\).
3. EBIT and tax. Annual depreciation is \(\$120{,}000/3=\$40{,}000\). EBIT is \(\$232{,}000-\$90{,}000-\$40{,}000=\$102{,}000\), so project tax is \(0.25 \times \$102{,}000=\$25{,}500\).
4. Annual operating cash flow. Add back the noncash depreciation: \(\$102{,}000-\$25{,}500+\$40{,}000=\$116{,}500\). The same annual amount applies in each of the three years under the stated constant assumptions.
5. Initial and terminal cash flows. At time 0, the company pays \(\$120{,}000\) for equipment and invests \(\$30{,}000\) in working capital, giving an initial cash flow of \(-\$150{,}000\). Years 1 and 2 each have a cash flow of \(\$116{,}500\). In year 3, working capital is recovered, so the cash flow is \(\$116{,}500+\$30{,}000=\$146{,}500\).
Check. The time-0 outflow equals the equipment purchase plus the initial working-capital investment. The year-3 amount exceeds the ordinary operating cash flow by exactly the $30,000 recovered. The method avoids treating all displaced sales revenue as a loss and avoids counting depreciation as a cash expense.
Working Capital and the Timing of Cash
A launch may require inventory, receivables, or other operating resources before the related customer cash is collected. The net investment in those resources is captured by net working capital. An increase in required net working capital is a cash outflow; a decrease or recovery is a cash inflow. It is a separate cash-flow adjustment, not an operating expense to deduct when calculating EBIT.
The timing matters. If a launch requires an initial working-capital investment and a larger balance is needed later as sales grow, the increase is another cash outflow when the additional funds are committed. If the project ends and that working capital is recovered, record the recovery at the end. Do not subtract the entire balance from operating profit or count its recovery as revenue.
Worked Example: Growing Sales and a Changing Working-Capital Balance
A two-year launch requires equipment costing $180,000 at time 0. Assume straight-line depreciation of $90,000 in each year, no salvage proceeds, and a 30% tax rate. The launch sells 8,000 units in year 1 and 10,000 in year 2, at $80 per unit with variable costs of $46 per unit. It displaces 1,000 existing-product units in year 1 and 1,500 in year 2; each displaced unit would have earned $12 of contribution. Avoidable fixed costs are $100,000 in year 1 and $110,000 in year 2. Required net working capital is 8% of the following year’s forecast new-product sales: the time-0 balance is based on year 1 sales, and the balance at the end of year 1 is based on year 2 sales. The balance is fully recovered at the end of year 2. Assume positive taxable EBIT and immediate use of tax deductions. Calculate the project cash flows at times 0, 1, and 2.
Method. Calculate each year’s EBIT and operating cash flow separately, then add the cash effect of each change in working capital to the appropriate date.
1. Year 1 operating cash flow. Revenue is \(8{,}000 \times \$80=\$640{,}000\), and variable costs are \(8{,}000 \times \$46=\$368{,}000\), giving new-product contribution of \(\$272{,}000\). Cannibalized contribution is \(1{,}000 \times \$12=\$12{,}000\). EBIT is \(\$272{,}000-\$12{,}000-\$100{,}000-\$90{,}000=\$70{,}000\). Tax is \(0.30 \times \$70{,}000=\$21{,}000\), so operating cash flow is \(\$70{,}000-\$21{,}000+\$90{,}000=\$139{,}000\).
2. Year 2 operating cash flow. Revenue is \(10{,}000 \times \$80=\$800{,}000\), and variable costs are \(10{,}000 \times \$46=\$460{,}000\), giving contribution of \(\$340{,}000\). Cannibalized contribution is \(1{,}500 \times \$12=\$18{,}000\). EBIT is \(\$340{,}000-\$18{,}000-\$110{,}000-\$90{,}000=\$122{,}000\). Tax is \(0.30 \times \$122{,}000=\$36{,}600\), so operating cash flow is \(\$122{,}000-\$36{,}600+\$90{,}000=\$175{,}400\).
3. Working-capital cash flows. Year 1 sales are \(\$640{,}000\), so the time-0 balance is \(0.08 \times \$640{,}000=\$51{,}200\). Year 2 sales are \(\$800{,}000\), so the required year-1 ending balance is \(0.08 \times \$800{,}000=\$64{,}000\). This is an additional investment of \(\$64{,}000-\$51{,}200=\$12{,}800\) at time 1. The full \(\$64{,}000\) is recovered at time 2.
4. Combine the cash flows. At time 0, the equipment and working-capital outflows total \(-\$180{,}000-\$51{,}200=-\$231{,}200\). At time 1, cash flow is \(\$139{,}000-\$12{,}800=\$126{,}200\). At time 2, cash flow is \(\$175{,}400+\$64{,}000=\$239{,}400\).
Check. Working capital rises from $51,200 to $64,000, so the year-1 change is an outflow of $12,800; the year-2 recovery is the full $64,000 balance. Neither amount changes EBIT or the tax calculation.
Common Traps in Launch Forecasts
- Subtracting cannibalized revenue rather than contribution. The lost product’s variable costs are also avoided. Subtract lost units times the existing product’s contribution per unit.
- Ignoring cannibalization. A launch’s sales are not all incremental if some customers switch from an existing company product.
- Including unavoidable allocated expenses. An accounting allocation is not automatically an incremental cost. Include it only if it changes because the launch is undertaken.
- Deducting depreciation as if it were a cash payment. Depreciation reduces taxable EBIT; after calculating tax, add it back to operating cash flow.
- Putting working capital into EBIT. Working capital is a use or release of cash, not an operating expense. Record the change at the date it occurs.
For example, if the launch displaces existing-product sales of $80,000 and the associated variable costs would have been $50,000, the lost contribution is $30,000. Subtracting the full $80,000 would overstate the reduction in project profit by $50,000. The corrected adjustment is \(\$80{,}000-\$50{,}000=\$30{,}000\).
Check Your Understanding
For each problem, assume the stated tax rate applies to positive project EBIT and that tax deductions can be used immediately.
- A launch sells 5,000 units for $60 each at a variable cost of $35 per unit. It displaces 400 existing-product units, each with a contribution of $9. Avoidable fixed costs are $25,000 and annual depreciation is $20,000. At a 25% tax rate, find annual operating cash flow. (Answer: $77,300)
- A new product has revenue of $300,000 and variable costs of $180,000. It displaces 700 units of an existing product with contribution of $14 per unit. Avoidable fixed costs are $40,000 and depreciation is $30,000. At a 30% tax rate, find operating cash flow. (Answer: $58,140)
- A project has equipment outlay of $90,000 at time 0 and annual operating cash flow of $50,000 in each of years 1 and 2. It requires $12,000 of working capital at time 0, requires a total balance of $18,000 at the end of year 1, and recovers the full balance at the end of year 2. Find the project cash flow at each date. (Answer: Time 0: \(-\$102,000\); year 1: \(\$44,000\); year 2: \(\$68,000\))
- A launch has revenue of $240,000, variable costs of $144,000, cannibalized contribution of $15,000, avoidable fixed costs of $30,000, depreciation of $24,000, and an allocated $20,000 overhead charge that will continue even if the launch is rejected. At a 25% tax rate, find operating cash flow. (Answer: $44,250)
- A launch has revenue of $400,000 and variable costs of $250,000. It displaces existing-product sales of $50,000; the variable costs avoided on those sales would have been $30,000. Avoidable fixed costs are $50,000 and depreciation is $50,000. At a 20% tax rate, find operating cash flow. (Answer: $74,000)