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
REIT Financial Model Template
79
0
This REIT financial model template acts as a guideline for modeling a real estate investment trust (REIT). This model will…
Energy Industry Comps Template Energy Industry Comps Template
964
58
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
1,565
70
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
1,251
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
1,376
95
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
1,171
0
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
See All