Turn annual profit and balance-sheet movements into a structured view of operating, investing, and financing cash flow.
This editable Excel workbook applies the indirect method: begin with net income, account for working-capital movements and other operating adjustments, then record investing and financing cash flows. The resulting statement shows how those activities change cash and build to the closing cash balance across the annual periods displayed in the model.
Reconcile profit to operating cash
Separate accounting profit from cash generation by showing the effect of working-capital changes and other operating cash-flow adjustments.
See what changed the cash balance
Review operating, investing, and financing activities together instead of assessing each source or use of cash in isolation.
Compare annual cash-flow direction
Use the multi-year statement and chart to identify whether closing cash is rising, falling, or being supported by financing activity.
What does the indirect cash flow view help you analyze?
The workbook organizes the main annual cash-flow drivers into one statement, making it easier to trace the movement from net income to operating cash flow and then to the final change in cash held.
Operating cash conversion: assess how net income translates into cash after working-capital movements and other operating adjustments.
Investment in fixed assets: isolate fixed-asset expenditure and other investing cash flows from day-to-day operations.
Debt and equity activity: capture debt drawdowns or repayments, equity raisings or buybacks, and other financing cash flows.
Net change in cash: combine the operating, investing, and financing sections to calculate the movement in cash for each annual period.
Closing liquidity trend: compare ending cash balances over time and identify periods in which cash growth slows or reverses.
What is inside the workbook?
The model preview shows a five-column annual indirect cash flow statement paired with a visual summary. The statement separates editable business figures from calculated section totals, so users can follow the bridge from net income through cash from operations, investments, financing, and closing cash.
Annual cash-flow inputs
Enter or update net income, changes in working capital, other operating cash flows, fixed-asset expenditure, other investing items, debt movements, equity movements, and other financing items.
Calculated cash-flow sections
Review operating cash flow, investing cash flow, financing cash flow, the change in cash held, and the closing cash balance for each year.
Multi-year visual output
Compare operating, investing, and financing cash flows alongside net cash flow and closing cash in the accompanying chart.
The workbook preview shows annual operating, investing, and financing cash-flow lines, calculated changes in cash, closing cash balances, and a chart for comparing the five displayed years.
Follow the full bridge from net income to closing cash
The statement starts with net income and shows working-capital and other operating adjustments before calculating operating cash flow. Investing and financing sections are then added to determine the annual change in cash held. The chart makes the relationship between operating cash generation, net cash movement, and closing cash easier to review across periods.
How do you use the template?
Prepare the annual source figures
Collect net income, working-capital changes, capital expenditure, debt activity, equity activity, and any other operating, investing, or financing cash-flow items used by your business.
Enter each cash-flow driver
Populate the corresponding annual lines and keep cash inflows and outflows consistent with the sign convention shown in the workbook.
Review the section totals
Check operating, investing, and financing cash flow to understand which category generated or consumed cash in each year.
Trace the closing cash movement
Compare the calculated change in cash held with the closing cash balance and use the chart to spot shifts in the multi-year pattern.
Who is this template for?
This workbook is suited to business owners, founders, controllers, accountants, and finance teams that already have annual income-statement and balance-sheet information and need a clear indirect-method cash flow view. It is especially useful for annual planning, management reporting, liquidity review, and explaining why reported profit does not equal the change in cash. Teams that require a shorter reporting cycle may prefer a more frequent cash-flow format rather than relying only on annual periods.
