Research / Methods & evidence
Profit is not cash: explain the complete cash bridge
Trace $12,000 of profit to a $67,000 cash outflow. A complete worked bridge explains receivables, inventory, equipment and loan principal.
Introduction
A business can report a $12,000 profit and still use $67,000 of cash in the same quarter. The difference is not necessarily a formula error: customers may owe money, inventory may have been purchased, equipment paid for and debt repaid. A useful financial model explains each of those movements instead of treating profit as money available to spend.
A complete quarter, with the assumptions visible
The following original example is illustrative, not an observed company's performance. All amounts are $ for one quarter. Opening cash is $80,000. Revenue is $120,000; cost of goods sold is $72,000 and other operating expenses are $36,000. There are no taxes, interest, depreciation, other noncash charges or foreign-exchange movements in this simplified scenario.
During the quarter, trade receivables increase by $60,000, inventory by $18,000 and trade payables by $24,000. The business also pays $20,000 for equipment and repays $5,000 of loan principal. These are changes during the quarter, not the balances at its end.
| Step | Effect on cash | Explanation |
|---|---|---|
| Operating profit | 12,000 | 120,000 revenue − 72,000 cost of goods − 36,000 expenses |
| Increase in receivables | (60,000) | Revenue recognized but not yet collected |
| Increase in inventory | (18,000) | Purchases exceed the inventory expensed through cost of goods sold |
| Increase in trade payables | 24,000 | Supplier purchases not yet paid for |
| Cash from operating activities | (42,000) | 12,000 − 60,000 − 18,000 + 24,000 |
| Equipment purchase | (20,000) | Investment payment |
| Loan principal repayment | (5,000) | Financing payment |
| Net change in cash | (67,000) | Operating, investment and financing cash movements combined |
| Closing cash | 13,000 | 80,000 opening cash − 67,000 cash used |
Rebuild the result from receipts and payments
A direct calculation reaches the same answer. Customer receipts are $120,000 of sales less the $60,000 increase in receivables: $60,000. Inventory purchases are $72,000 of cost of goods sold plus the $18,000 inventory increase: $90,000. After the $24,000 increase in payables, supplier payments are $66,000.
Receipts of $60,000 less supplier payments of $66,000 and other operating payments of $36,000 produce a $42,000 operating cash outflow. Deducting equipment and principal payments gives the same $67,000 total outflow. Agreement between the two calculations makes the assumptions and cash treatment easier to inspect; it does not prove the assumed collections will happen.
Three omissions can make the bank balance look much stronger
Missing working capital. A model that starts with $12,000 profit and ignores receivables, inventory and payables overstates operating cash by $54,000. Increasing sales on credit can worsen that difference even when the income statement improves.
Missing investment payments. The equipment payment uses cash in the quarter. In a model that also recognizes depreciation, the cash bridge must distinguish the asset payment from its noncash expense. Simply deducting both as cash costs would create a different error.
Missing debt principal. The $5,000 principal payment reduces cash and the loan balance. It is separate from interest expense. A model with an income statement and an interest calculation can still miss this financing payment.
If all three movements are omitted, the model reports $92,000 of closing cash: $80,000 plus profit of $12,000. The correct result under the stated assumptions is $13,000, a $79,000 difference. That difference equals $54,000 of net working-capital investment, $20,000 of equipment and $5,000 of principal.
What the quarter-end figure still cannot tell you
The business closes with positive cash, but it might run short earlier in the quarter. A $20,000 equipment payment in the first week and receipts concentrated in the final week create a different financing problem from evenly spread cash flows. Add actual due dates to estimate the minimum balance, then compare that amount with available cash and committed facilities.
Before relying on a model delivered by someone else, reproduce this logic for its largest working-capital, investment and debt movements. Ask for a schedule that explains the difference between profit and cash using the same periods and units. A closing balance that cannot be reconciled is not a dependable basis for a funding decision.
Method and sources
The numbers and calculations are original illustrative assumptions. The operating, investing and financing distinction and the adjustment of accrual profit for cash effects follow the framework described by the IFRS Foundation's IAS 7 overview. This simplified example does not attempt to cover every presentation or classification requirement of the standard.
For a wider review, see the financial model review checklist. Use the startup budget calculator to work through monthly receipts and payments with your own assumptions.
Try a related calculation
- Break-even calculator
Add an independently reproducible operating case to the handoff pack; this does not audit the entire workbook.
- DCF calculator
Check a defined valuation case using the delivered file's timing and cash-flow convention.