Can your business fund its growth plan?

A growing sales plan can produce a profit while leaving too little cash for the next supplier payment. To assess whether you can fund it, connect your profit forecast to expected collections, payment dates and a projected balance sheet.

In the original illustrative example below, a consumer packaged goods business forecasts $86,400 of profit before income taxes over three months. Its base plan stays above the owner's $20,000 cash target at each month-end. When half of new wholesale invoices take one additional month to collect, Month 2 cash falls to $4,600.

The resulting $15,400 gap below the target calls for a change in the plan or confirmed funding. It is not evidence that a lender will provide that amount, and monthly totals do not establish the lowest cash balance within a month.

Set out the business and the assumptions

This sample CPG brand buys finished products for resale through its online store and wholesale accounts. All amounts are in US dollars. It is a simplified management planning example, not a client result, a historical financial statement or assurance on a forecast.

• Opening balances: cash $60,000; customer receivables $30,000; inventory $80,000; equipment net of accumulated depreciation $30,000; supplier payables $40,000; loan principal $20,000; owner equity $140,000.
• Sales and collections: 60% of sales are direct and collected in the month of sale. The other 40% are wholesale, collected in the following month in the base case. The opening $30,000 receivable is collected in Month 1 in both cases.
• Inventory and suppliers: the business receives and owns all purchases in the stated month. Suppliers receive half in that month and half in the next month. The opening $40,000 payable is paid in Month 1. Inventory costs include qualifying inbound costs; none are counted again in operating expenses.
• Operating costs: payroll and related employer costs, advertising, fulfillment, payment processing and other operating expenses total $22,000, $24,000 and $26,000. They are paid in the month incurred, leaving no related opening or closing accruals. Processor fees are shown as separate payments for this illustration; there are no held or unsettled processor balances at month-end.
• Equipment, debt and owners: depreciation is $1,000 a month on existing nonproduction equipment. There are no equipment purchases or disposals. The existing loan requires $200 of interest each month and $3,000 of principal at the end of Month 3. Owner distributions are $3,000 a month. There is no new borrowing or owner contribution.

To isolate the timing question, assume no returns, discounts, credit losses or inventory write-downs. The business uses FIFO, and inventory's net realizable value is at least its cost. The sample assumes no entity-level income tax expense or liability. Owner income taxes are outside the business model; the distributions are not a calculation of the owners' tax needs. Sales-tax receipts and remittances are excluded from the sample. These assumptions must be replaced with the actual obligations before using a forecast to commit cash.

Calculate profit before scheduling the payments

The sales plan rises from $100,000 to $140,000. Product cost of goods sold is assumed to be 55% of sales. That percentage is a planning input for this sample; a real forecast should use supported product costs, expected prices and sales mix.

On a smaller screen, scroll across each table to see all columns.

Quarterly sales of $360,000 less $198,000 of product cost, $72,000 of other operating expenses, $3,000 of depreciation and $600 of interest produce $86,400 of profit before income taxes. Owner distributions and loan principal payments do not reduce that profit.

Purchases total $270,000, but only $198,000 becomes cost of goods sold. The remaining increase is inventory: $80,000 opening inventory + $270,000 purchases − $198,000 cost of goods sold = $152,000 closing inventory. Paying a supplier does not by itself turn the purchase into an expense.

For this example, each sale meets the revenue-recognition conditions and the customer obtains control in the stated sales month. Under US GAAP, that transfer determines the timing of revenue for these product sales; the collection date does not. Inventory cost and any required valuation adjustment need their own support. See ASC 606-10-25-23, ASC 330-10-30-1 and ASC 330-10-35-1B.

Turn collections and payment dates into a cash budget

Month 1 collections are $60,000 from direct sales plus the $30,000 opening receivable, or $90,000. Month 2 collects $72,000 from direct sales and $40,000 from Month 1 wholesale sales, or $112,000. Month 3 collects $84,000 plus $48,000, or $132,000.

Month 1 supplier payments are the $40,000 opening payable plus half of that month's $100,000 purchase, or $90,000. Month 2 pays $50,000 plus $45,000, or $95,000. Month 3 pays $45,000 plus $40,000, or $85,000.

Each month follows the same calculation: beginning cash plus receipts, less payments, equals ending cash. That closing balance becomes the next month's opening balance. Depreciation reduces profit but is not another cash payment. Principal and owner distributions reduce cash and their respective balance-sheet accounts.

The lowest of these three month-end balances is $24,600. That is $4,600 above the illustrative $20,000 target. It is a management target, not a legal minimum, lender covenant or amount suitable for every business. A weekly or daily schedule could reveal a lower balance between month-ends.

Test slower wholesale collections

Now collect half of each new wholesale month's sales in the following month and half one month later. Keep sales, product costs, purchases, operating costs and other payments unchanged. The opening receivable still arrives in Month 1. This is a timing-only scenario: all invoices remain collectible, with no extra fees or interest.

Month 2 loses $20,000 of collections compared with the base case. Month 3 then collects that delayed $20,000, but $24,000 from Month 2 is pushed into Month 4. Total receipts during the quarter fall from $334,000 to $310,000.

Profit remains $86,400 under these assumptions. Month 2 cash falls to $4,600, leaving a $15,400 shortfall against the target. No financing has been inserted to fill it. The largest month-end shortfall is a starting point for a funding discussion, not a complete borrowing requirement. Actual payment dates, financing costs, taxes and the months after this forecast can change the amount.

Check what remains on the balance sheet

The projected closing balance sheet checks whether the cash forecast agrees with the sales and purchase schedules. It also shows where money remains committed at the end of the quarter.

Base receivables are $30,000 + $360,000 − $334,000 = $56,000. With slower collections, they are $30,000 + $360,000 − $310,000 = $80,000. The additional $24,000 receivable explains the $24,000 reduction in closing cash. It has not disappeared or become an expense in this timing-only example.

Supplier payables close at $40,000 + $270,000 − $270,000 = $40,000. Equipment falls from $30,000 to $27,000 after depreciation. Debt falls from $20,000 to $17,000 after the principal payment. Equity is $140,000 + $86,400 profit − $9,000 distributions = $217,400, using the sample's no-entity-income-tax assumption.

A second check starts with base-case profit: add back $3,000 depreciation, subtract the $26,000 increase in receivables and the $72,000 increase in inventory, and include the zero net change in payables. That gives $8,600 of operating cash used. After $3,000 of loan principal and $9,000 of distributions, cash falls by $20,600, from $60,000 to $39,400.

This is a prospective management cash budget. It does not replace a historical GAAP statement of cash flows, which reports operating, investing and financing activity. The reconciliation above applies the distinction between cash movements, noncash expenses and working-capital balances described in ASC 230-10-45-28.

What the owner should decide before committing

The business plans to carry $72,000 more inventory by quarter-end while waiting longer for some customer payments. The collection delay makes the cash position tighter even though the sales plan and profit are unchanged.

The immediate decision is whether to change the purchase and payment plan or secure funding before the Month 2 shortfall. Check customer payment commitments first. Then compare smaller or staged inventory deliveries, supplier terms agreed in advance, and the timing of discretionary owner distributions. Assess minimum order quantities, unit costs, lead times and stockout risk alongside any cash savings. Moving a payment beyond this quarter does not remove the obligation.

If borrowing is part of the response, confirm the available amount, draw conditions, permitted use, fees, interest and repayments with the lender. An unused credit limit is not bank cash, and the existing loan in this example is not assumed to allow additional draws. Extend the forecast through repayment and the next inventory cycle.

Build your own plan from the records

• Start with reconciled balances. Tie opening cash to bank records, identifying outstanding payments, restrictions and processor balances. Reconcile receivables, payables, inventory, equipment and debt to the ledger.
• Schedule actual timing. Use customer terms and collection history, settlement reports, purchase orders, supplier invoices and payroll dates. In a net-payout model, do not deduct processor fees again if receipts already exclude them.
• Include the full obligations. Add returns, trade deductions, inventory losses, supplier deposits, tax payments, equipment spending, leases and owner distributions where applicable. A supplier deposit may be a prepayment until the business owns the goods.
• Check the forecast each week. Compare actual receipts and payments with the prior forecast, investigate differences and update the remaining weeks. Assign responsibility for collections, purchasing and forecast updates.

For the weekly process, read cash flow forecasting for ecommerce businesses. For a narrower purchasing decision, see how much cash you can commit to a production order.

Review your growth plan with Beamarc

Beamarc's accounting advisory can help connect your sales and purchase plans to a cash forecast and the balances expected to remain at period-end. Depending on the agreed scope and available records, the work can include a base plan, a slower-collection scenario and a discussion of the assumptions that affect your next commitment.

We can work with your existing bookkeeper. Responsibilities, forecast periods, update frequency and fees are agreed in writing. Explore our CPG and ecommerce accounting services or request a consultation at beamarc.cpa. Tell us what you plan to fund and when you need to decide.