Overview

Download this Cash Flow Statement Excel Template to summarize a company's cash inflows and outflows. The cash flow statement is one of the three key financial statements that show the cash inflows and outflows during a specific period of time (generally a month, a quarter, or a year). This statement acts as a bridge between the income statement and balance sheet by how money moved in and out of the business.

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).

cash-flow-statement-template-excel-image

Screenshot from the template.

How to Use This Template

This 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!
Share
Reviews Add a review
Avatar
Julia

More From Corporate Finance Institute®

Browse our top rated business templates. See All
Energy Industry Comps Template Energy Industry Comps Template
314
21
This energy industry comps template provides a guideline and example of what a comparables universe would look like for a…
Financial Institution Dividend Discount Model
905
23
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
577
0
The loan payment calculator allows users to determine the principal and interest payment each month until the full balance of…
DDM - Excel Dividend Discount Model Template
719
57
The dividend discount model template allows investors to value a company base on future dividend payments. This is based on…
Non-directional trading strategy template Non-directional Trading Strategies Template
621
0
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
restructuring financial model template preview 1 Restructuring Financial Model Template
897
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…