Skip to content
Planvik
Back to Knowledge

Prepare a cash flow statement

What the cash flow statement shows

The cash flow statement (Kapitalflussrechnung in German) explains how your cash position changes over a period. It closes the gap between the profit in the profit and loss statement (P&L) and the bank balance in the balance sheet. In the annual accounts, it is only mandatory for groups and capital-market-oriented companies (§ 264(1) and § 297(1) HGB, the German Commercial Code). It still belongs in the financial plan: as a projected cash flow statement for each plan year, from which the bank reads the cash flow before debt service and with it the DSCR.

To do this, it splits all cash flows into three areas: cash flow from operating activities (the day-to-day business), from investing activities (buying and selling fixed assets) and from financing activities (loans and equity). The sum of the three is the change in cash.

How it differs from a cash flow forecast: The cash flow statement explains the change per period, usually per year, starting from the profit. The cash flow forecast lists cash in and cash out month by month and shows the bank balance. A financial plan needs both: the cash flow forecast steers, the cash flow statement explains.

The indirect method step by step

The indirect method starts with the net income for the year and converts it into operating cash flow. All amounts in euros.

ItemAmount
Net income120,000
+ Depreciation60,000
− Increase in receivables25,000
+ Increase in payables15,000
− Increase in inventories10,000
= Cash flow from operating activities160,000
− Investment in fixed assets90,000
= Cash flow from investing activities−90,000
+ New loans taken out50,000
− Repayment30,000
= Cash flow from financing activities20,000
= Change in cash90,000

Profit is 120,000 euros, yet cash only rises by 90,000 euros. The difference lies mainly in the investment and the build-up of receivables. Depreciation is added back because it reduces profit without costing any money; EBITDA uses the same logic. In this simplified example, interest stays in net income and therefore in the operating cash flow; the Planvik Excel file calculates the same way. Under DRS 21, you would add paid interest back in the operating section and deduct it in financing activities; the change in cash stays the same.

Cash flow from P&L and balance sheet

Planvik derives the cash flow statement from your P&L and balance sheet, with separate sections, linked formulas and consistent sign logic.

Create your financial plan

Direct or indirect method

There are two ways to present the operating cash flow:

Both routes lead to the same operating cash flow; they differ only in presentation.

Common mistakes

  1. Depreciation not added back. It reduces profit without costing any money, so it has to be added back.
  2. Working capital with the wrong sign. A build-up of receivables ties up money and counts as negative; a rise in payables frees money up.
  3. Interest counted twice. It is already included in net income. If you show it in financing activities under DRS 21, add it back in the operating section.
  4. Investments booked under operating activities. Purchases of fixed assets belong under investing activities.

Frequently asked questions

Which method does the bank require?

The indirect method is the norm, but both are accepted. What matters is that the derivation is easy to follow.

How does it differ from cash flow forecasting?

The cash flow statement explains the change in cash per year, starting from the profit. Cash flow forecasting lists cash in and cash out month by month and shows the bank balance. The financial plan contains both.

Does interest paid belong in the operating cash flow?

Under DRS 21, interest paid belongs to financing activities and interest received to investing activities. The international standard IAS 7 allows a choice between the operating and the financing section. What matters is to treat it the same way every time.

Why does profit differ from cash flow?

Because of non-cash items such as depreciation, because of changes in working capital and because of investments, which reduce your cash without affecting profit.