Blog · Territory, capacity and quota planning · Finance and FP&A teams
Calculate new product launch ROI from incremental contribution and launch investment over a stated period. Build a monthly spreadsheet from sales and cost exports, compare actuals with the approved case, and check cannibalization and timing.
ROI for new product launch measures the incremental contribution left after launch investment, divided by that investment, over a stated period. It answers whether the launch has earned back its defined investment and how the result compares with the approved case. Sales alone cannot answer that question.
Choose the launch, reporting period, investment boundary, and profit convention. This example uses a US manufacturer's new product, launched on January 1, 2026, with results through March 31, 2026. The return is cumulative, pre-tax, undiscounted contribution ROI for that period; it is neither annualized nor a discounted cash-flow valuation.
Launch ROI = (Incremental contribution during the period − Launch investment) / Launch investment
Incremental contribution = Net launch sales − Variable costs − Incremental ongoing costs − Displaced contribution
Separate one-time investment from ongoing expenses. The SBA's planning guidance distinguishes one-time and monthly costs when estimating the funding required to launch. The same discipline prevents an initial campaign from appearing in both your contribution deduction and investment denominator.
For this management calculation, finance includes the following launch spending in the investment boundary. It excludes existing corporate overhead that does not change because of the launch.
| Launch investment item | Amount (USD) |
|---|---|
| Product design | 20,000 |
| Testing and validation | 15,000 |
| Initial launch campaign | 25,000 |
| Launch investment | 60,000 |
This is a business-case investment schedule, not a statement that every item receives the same accounting or tax treatment. If equipment or inventory is material, define a separate cash investment view and avoid counting the asset purchase and its later expense twice.
Export invoice or sales-credit lines with dates, product codes, units, net sales, and variable costs. Keep returns and rebates in net sales. Add a monthly schedule for incremental support costs and a finance-approved estimate of contribution lost from existing products.
The no-launch baseline matters. The new product's orders may partly replace orders the business would have received anyway. Subtract the lost contribution from those orders, rather than the old product's full revenue. The distinction between sales and contribution is covered in gross margin versus contribution margin.
Here, the realized net selling price is $100 per unit and variable cost is $60 per unit. Incremental support costs are $4,000 each month. Finance estimates displaced contribution from the established product at $5,000 in January, $7,000 in February, and $8,000 in March.
| Month | Units | Net sales (USD) | Variable costs (USD) | Ongoing costs (USD) | Displaced contribution (USD) | Incremental contribution (USD) |
|---|---|---|---|---|---|---|
| January | 1,000 | 100,000 | 60,000 | 4,000 | 5,000 | 31,000 |
| February | 1,500 | 150,000 | 90,000 | 4,000 | 7,000 | 49,000 |
| March | 2,000 | 200,000 | 120,000 | 4,000 | 8,000 | 68,000 |
| Total | 4,500 | 450,000 | 270,000 | 12,000 | 20,000 | 148,000 |
January's contribution is 100,000 − 60,000 − 4,000 − 5,000 = $31,000. The same subtraction gives the other months. Reconcile the underlying sales and variable costs to the ledger, and retain the baseline assumptions supporting displaced contribution.
In Excel, place the monthly summary above in columns A:G, with January through March in rows 2:4. Store each month's first date in column A. On a sheet named Raw, put invoice dates in A, product codes in B, net sales in C, and variable costs in D. Put the launch product code in K5 of the summary sheet.
For net sales in C2, use:
=SUMIFS(Raw!$C$2:$C$10000,Raw!$B$2:$B$10000,$K$5,Raw!$A$2:$A$10000,">="&A2,Raw!$A$2:$A$10000,"<"&EDATE(A2,1))
For variable costs in D2, use:
=SUMIFS(Raw!$D$2:$D$10000,Raw!$B$2:$B$10000,$K$5,Raw!$A$2:$A$10000,">="&A2,Raw!$A$2:$A$10000,"<"&EDATE(A2,1))
Fill both down. Extend the ranges if your export has more rows. Microsoft's SUMIFS documentation explains the use of several criteria and the requirement for equally sized ranges. Check dates are actual spreadsheet dates rather than imported text. Covirage is not affiliated with Microsoft.
Enter the approved ongoing costs in E and displaced contribution in F. In G2, calculate contribution and fill down:
=C2-D2-E2-F2
Put the investment schedule on LaunchCosts with amounts in B2:B4. Set K4 to =SUM(LaunchCosts!B2:B4). The return formula is:
=IF($K$4=0,NA(),(SUM(G2:G4)-$K$4)/$K$4)
Format the result as a percentage. Zero investment makes this ratio undefined, so report the dollar contribution rather than a misleading percentage.
The launch generated $148,000 of incremental contribution against $60,000 of defined investment. Net return is $88,000, and ROI is 88,000 / 60,000 = 146.7%, rounded to one decimal place.
The reconciliation must give that same $88,000 directly from the source categories:
450,000 sales − 270,000 variable costs − 12,000 ongoing costs − 20,000 displaced contribution − 60,000 launch investment = 88,000 net return
For cumulative net contribution after investment in H2, use =SUM($G$2:G2)-$K$4 and fill down. The monthly results are −$29,000, $20,000, and $88,000. The contribution calculation turns positive by February's close; cash recovery may happen later because of customer collections and inventory payment timing. Use a separate cash flow forecast for that funding question.
The SBA's starting-cost guidance separates pre-opening expenses, assets, and cash needed to cover early operating deficits. A positive contribution ROI can coexist with a short-term cash requirement.
The approved case assumed 5,000 units at the same $100 price and $60 variable cost, with the same ongoing costs, displaced contribution, and launch investment. Keep those definitions unchanged in the comparison.
| Measure | Approved case | Actual |
|---|---|---|
| Units | 5,000 | 4,500 |
| Sales (USD) | 500,000 | 450,000 |
| Variable costs (USD) | 300,000 | 270,000 |
| Ongoing costs (USD) | 12,000 | 12,000 |
| Displaced contribution (USD) | 20,000 | 20,000 |
| Incremental contribution (USD) | 168,000 | 148,000 |
| Launch investment (USD) | 60,000 | 60,000 |
| Net return (USD) | 108,000 | 88,000 |
| ROI | 180.0% | 146.7% |
The shortfall is 500 units × ($100 − $60) = $20,000 of contribution. That explains the entire net-return variance and the 33.3 percentage-point ROI shortfall, using unrounded ratios. A positive actual ROI still missed the approved case.
Change only realized price to $90 for the actual 4,500 units. Sales fall to $405,000; incremental contribution becomes $103,000; net return becomes $43,000; ROI becomes 71.7%. This sensitivity shows why volume growth achieved through discounts needs a contribution check. Use break-even analysis when the decision is how much volume would cover the defined costs.
Bring the launch sales export, cost schedule, displaced-contribution assumptions, and approved business case. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the variance with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See how Covirage supports revenue driver analysis.
Include the incremental costs required by the launch: development, testing, launch marketing, training, and other approved investment. Deduct variable selling and fulfillment costs and incremental ongoing expenses from sales contribution. Define the scope first so each cost appears exactly once.
Use contribution or another clearly defined profit measure, not revenue alone. New product revenue may require production, fulfillment, commissions, support, and displaced sales elsewhere. Revenue divided by launch spending is a revenue multiple and does not show the launch's economic return.
Use the horizon approved in the business case, with interim checkpoints on that same basis. Early results can be negative while launch costs arrive before sales. Label the period explicitly and keep a separate cash view when collections or inventory payments occur later.
Subtract the contribution lost when customers switch from existing products to the new product. Compare with a documented no-launch baseline rather than subtracting all old-product sales declines. Pricing, seasonality, supply constraints, and broader demand changes can also explain a decline.