Sections of the Cash Flow Statement Excel Template
- Operating Activities: includes the revenue-generating activities of an organization and any other activities that are not investing or financing; any cash flows from current assets and current liabilities.
- Investing Activities: any cash flows from the acquisition and disposal of long-term assets and other investments not included in cash equivalents.
- Financing Activities: Any cash flows that result in changes in the size and composition of the contributed equity and borrowings of the entity (i.e. bonds, stock, cash dividends).
Screenshot from the template.
How to Use This TemplateThis Cash Flow Statement Excel Template is simple, clear and can be adjusted according to your business' needs. Download the cash flow statement template and change the hard-coded numbers in blue to your own data. The template will then automatically calculate each of the operating cash flow, investing cash flow, and financing cash flow, and eventually generate the closing cash balance. This closing cash balance figure can then be input into the balance sheet to complete the assets section. We hope you find this Excel template useful for your own financial analysis and modeling!