Basic Integrated Cash Flow Explained: Templates and Common Pitfalls

Basic Integrated Cash Flow: Step-by-Step Setup and Examples

A Basic Integrated Cash Flow model links the three primary financial statements—income statement, balance sheet, and cash flow statement—so changes in one automatically update the others. This article walks through a clear, step-by-step setup and provides simple examples to help you build a working integrated cash flow model for a small business or project.

Why integrate cash flow?

• Clarity: Shows how operations, investments, and financing impact cash.
• Accuracy: Ensures consistency across financial statements.
• Decision-making: Helps evaluate funding needs, timing of cash shortfalls, and impact of strategic choices.

Step-by-step setup

1. Define assumptions and timeline

• Choose the model horizon (e.g., monthly for 12 months, or annually for 3–5 years).
• List key drivers: sales growth rate, gross margin, operating expenses, working capital terms (days receivable, days payable, inventory days), capital expenditures (CapEx), depreciation schedule, tax rate, interest rate, debt schedule, and starting cash & balances.

2. Build the income statement (profit & loss)

• Start with Revenue (driven by sales volume × price or a growth-rate time series).
• Subtract Cost of Goods Sold (COGS) to get Gross Profit.
• Subtract Operating Expenses (SG&A, R&D, etc.) to obtain Operating Income (EBIT).
• Subtract Interest and Taxes to get Net Income.
• Add non-cash items (depreciation & amortization) for later cash adjustments.

Example (annual simplified):

• Revenue: 1,000,000
• COGS: 600,000 → Gross Profit: 400,000
• Operating Expenses: 200,000 → EBIT: 200,000
• Interest: 10,000; Tax rate: 25% → Taxes: (EBT × 25%) = 47,500 → Net Income: 142,500

3. Create the balance sheet opening balances

• List opening balances for Cash, Accounts Receivable (A/R), Inventory, Accounts Payable (A/P), Fixed Assets (Gross), Accumulated Depreciation, Debt, and Equity.
• Ensure Assets = Liabilities + Equity.

Example opening balances:

• Cash: 50,000
• A/R: 100,000
• Inventory: 80,000
• A/P: 60,000
• Fixed Assets (net): 200,000
• Debt: 150,000
• Equity: 220,000

4. Build the cash flow statement (indirect method)

Section A — Operating Activities:

• Start with Net Income.
• Add back non-cash charges (depreciation).
• Adjust for changes in working capital: increases in A/R or Inventory reduce cash; increases in A/P increase cash.

Section B — Investing Activities:

• Include CapEx (cash outflow) and proceeds from asset sales.

Section C — Financing Activities:

• Include debt drawdowns/repayments, equity issuances, and dividends.

Example operating cash adjustments:

• Net Income: 142,500
• • Depreciation: 20,000 → 162,500
• ΔA/R: +10,000 (use of cash) → 152,500
• ΔInventory: +5,000 → 147,500
• ΔA/P: +8,000 (source of cash) → 155,500
  Net Cash from Operations: 155,500

CapEx (Investing): -30,000
Debt Repayment (Financing): -20,000
Net Change in Cash: 155,500 – 30,000 – 20,000 = 105,500
Ending Cash = Opening Cash + Net Change = 50,000 + 105,500 = 155,500

5. Link the statements (integration)

• Feed Net Income from the Income Statement into the Cash Flow (starting point) and to Equity (retained earnings) on the Balance Sheet.
• Reflect depreciation on both Income Statement (expense) and as an accumulated depreciation increase on the Balance Sheet.
• Update A/R, Inventory, A/P balances based on working capital changes used in the Cash Flow statement.
• Record CapEx additions to Fixed Assets on the Balance Sheet and as outflows under Investing Activities.
• Update Debt and Equity balances from Financing Activities.
• Carry Ending Cash from the Cash Flow statement to the Balance Sheet cash line. Confirm Assets = Liabilities + Equity each period.

6. Build schedules for detailed drivers

• Accounts Receivable schedule: link sales and collection terms (e.g., % collected same month,