Initial working capital: funding a new operation

Initial working capital funds the inventory and customer credit a new operation needs before its collections support normal trading. Estimate the opening trade balances, then follow the actual payment dates: a single launch-day balance does not show the largest cash deficit.

Define the investment before adding costs

For this schedule, use a narrow operating definition:

Trade working capital = Inventory + Trade receivables - Trade payables

This excludes cash, debt, equipment and tax balances. The broader balance-sheet definition belongs in the existing working-capital guide. State your scope on the approval sheet so the funding request uses the same definitions throughout.

Keep equipment, launch expenses and payroll funding on separate schedules. The SBA's startup-cost guidance recommends separating one-time expenses from monthly expenses to establish how much capital is needed and when. A new division of an established company needs that same separation, even when the parent supplies the cash.

Initial working capital is one part of the funding requirement. It is not a substitute for a full operating cash budget.

Start with the purchasing and sales files

Bring the opening purchase-order list, supplier terms, planned shipment schedule and customer billing assumptions. Keep inventory at its carrying cost; receivables use invoice amounts. Add expected invoice, payment and collection dates to the relevant rows.

For each month, carry forward inventory, receivables and payables. The formulas are:

Closing inventory = Opening inventory + Purchases - Cost of goods sold
Closing receivables = Opening receivables + Credit sales - Collections
Closing payables = Opening payables + Purchases - Supplier payments

These formulas assume no write-offs, returns, deposits or other adjustments. Add separate movement columns when those exist. Use dated weeks instead of months if suppliers must be paid before an important collection within the month.

The working-capital-days calculation can test whether the resulting holding and collection assumptions are plausible; it does not replace the payment schedule.

Build the opening balances

A US distributor is opening a new regional operation. Launch is month 0. All sales are on credit, purchases are inventory additions, and the operation begins with no balances. These are planning assumptions, not industry benchmarks.

Use the table's column order in A:I. In I2, enter and fill down:

=F2+G2-H2

Launch requires $60,000 of trade investment. The target operating balances require $175,000. That is the balance tied up once the operation reaches the assumptions shown, rather than another expense to add to the purchase payments.

Reconcile the investment to cash

Supplier payments equal opening payables plus purchases minus closing payables. With the first table in rows 2:5, enter launch supplier payments in J2:

=B2-H2

For the next month's payments, enter in J3:

=H2+B3-H3

Fill J3 down. Net trade cash movement in K2 is =E2-J2. Cumulative movement in L2 is =SUM($K$2:K2); fill both down.

The largest month-end trade cash deficit is $125,000, found with =MAX(0,-MIN(L2:L5)). This is before payroll, rent, taxes, equipment and cash reserves. Actual funding could need to be higher if payments fall earlier within a month.

The proof is cumulative gross profit minus closing trade working capital. At month 2, $50,000 - $175,000 = -$125,000. At month 3, $80,000 - $175,000 = -$95,000. The SEC's financial-statement guide distinguishes point-in-time balance sheets from period cash flow statements; the bridge connects those different views here.

Show recovery separately

If the operation eventually closes, release only the balances it can actually convert to cash:

The assumed release is $158,000, which is $17,000 below carrying value. Put collections and inventory proceeds on their expected dates; deduct any additional wind-down costs separately. For discounting those dated amounts, use NPV with working capital.

Where it goes wrong

• Adding balances to payments. The supplier-payment schedule already includes purchasing cash; adding opening inventory again duplicates funding.
• Treating sales as collections. A launch can report a profit while customer invoices remain unpaid.
• Using only month-end dates. A balanced month can contain a substantial earlier cash shortfall.
• Assuming full recovery. Inventory markdowns and bad debts reduce cash released at closure.

Use working-capital cost to assess the cost of carrying the investment once its amount and timing are clear.

Check your opening assumptions in Covirage

Upload your purchase schedule, planned collections and opening-balance file: Covirage maps the columns, and its tools compute and check the investment and cash bridges. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.

See Covirage for finance teams for the supporting context.