New product financial model: revenue, costs and cash

A new product financial model connects unit demand, net price, product costs and launch spending to profit and cash. Build the operating case from explicit inputs, then add customer collections, inventory and supplier payment timing. A positive operating result does not by itself establish that the launch funds its own cash needs.

Gather the rows behind the business case

Start with the sales forecast by product and month, price approvals, supplier quotes, inventory requirements, launch budget and payment terms. After launch, replace estimates with sales lines, credit notes, purchase records and payment exports. Keep plan and actual columns separate, with a source and owner for each assumption.

Use net realized prices after discounts and returns. Keep one-time launch spending separate from ongoing expenses, following the distinction between initial and recurring expenses in the SBA's startup-cost guidance. Finance must still assess the accounting treatment of the underlying items.

This is the complete operating case, rather than a demand estimate alone. For the established margin definition and cost classification, use the separate gross profit margin guide.

Set up the monthly inputs

A US distributor plans to launch a new accessory. The illustrative month begins with no inventory, customer receivables or supplier payables for this product. Launch spending is expensed and paid in the month, as are recurring expenses. There are no taxes, financing, equipment purchases or noncash expenses in the example.

Put field names in column A and the base case in B. Use column C for the lower-volume case. The row numbers below are spreadsheet row numbers; monetary values are USD.

The scenario changes only sales volume. Purchases adjust to that volume while preserving the required closing inventory. This assumes purchasing can still be changed; signed minimum orders would need a different purchase schedule.

Calculate revenue, profit and cash

Continue the same worksheet with these calculated rows. Copy the formulas from B to C for the second case.

The core Excel formulas make the difference between cost and payment explicit:

=B2*B4
=B16*B4
=B17*B7

The first values units sold, the second values units purchased, and the third calculates the portion of purchases paid this month. Microsoft documents SUM as adding a range of numbers, which supports the recurring-plus-launch expense totals above. Covirage is not affiliated with Microsoft.

All monetary results shown are exact to the dollar. The contribution per unit is $36: the $80 net price less $44 variable cost. This is the amount available toward the operating and launch expenses, using this example's defined costs. It is not the same as the final operating result.

Prove the cash result through working capital

The base case reports a $17,000 operating result but adds only $14,400 to cash. The SBA explains the difference between accrual and cash recording: the sale date and the payment date can differ. Here, receivables and inventory use cash while unpaid suppliers provide temporary funding.

With zero opening working capital, the check is:

Cash change = Operating result − Closing receivables − Closing inventory + Closing payables

The base case gives $17,000 − $40,000 − $13,200 + $50,600 = $14,400. The lower-volume case gives −$1,000 − $30,000 − $13,200 + $39,600 = −$4,600. Both match the direct cash calculation in the table.

Use a separate check cell:

=B15-B20-B21+B22-B23

It must return zero. For an ongoing product, use changes in receivables, inventory and payables instead of closing balances. The existing working capital guide covers that broader relationship.

Read the scenario as a decision

Selling 500 fewer units reduces revenue by $40,000 and contribution by $18,000. Operating results fall by that same $18,000 because recurring and launch spending stay fixed. Cash change deteriorates by $19,000, reflecting the changed collections and supplier funding as well as the operating result.

The product owner should explain the volume assumption. Sales should validate realized pricing; operations should validate order flexibility and required stock. Finance owns the cash reconciliation and comparison with actual results. Use the broader FP&A analysis guide for the surrounding planning process.

Where it goes wrong

• Purchases treated as cost of goods sold. Unsold inventory belongs in the inventory schedule; paying for it still affects cash.
• List price used as net revenue. Discounts, rebates and credit notes must enter the realized-price assumption or a separate adjustment.
• Launch costs repeated indefinitely. Keep their timing explicit while preserving any continuing support or marketing commitments.
• Collections assumed from sales alone. Replace the simple collection percentage with invoice timing when terms or overdue balances matter.

Compare your product workbook in Covirage

Bring your prepared new-product workbook and a sample of your own sales, purchase or cost export to Covirage. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the comparisons 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 this work supports finance teams.