Cash Flow Statement Template (2024)

Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.

This cash flow statement template provides you with a foundation to record operating, investing, and financing cash flows annually.

This is what the cash flow statement template looks like:

Cash Flow Statement Template (1)

Download the Free Template

Enter your name and email in the form below and download the free template now!

The Statement of Cash Flows (also referred to as thecash flow statement) is one of the three keyfinancial statementsthat report the cash generated and spent during a specific period of time (i.e. a month, quarter, or year). The statement of cash flows acts as a bridge between the income statement and balance sheet by how money has moved in and out of the business.

Three main sections of Statement of Cash Flows:

  1. Operating Activities: The principal revenue-generating activities of an organization and other activities that are not investing or financing; any cash flows fromcurrent assetsandcurrent liabilities
  2. Investing Activities: Any cash flows from the acquisition and disposal of long-term assets and other investments not included in cash equivalents
  3. 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)

More Free Templates

For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.

Cash Flow Statement Template (2024)

FAQs

Does Excel have a cash flow template? ›

Free Excel Cash Flow Template

Our cash flow template helps measure your company's financial performance. It displays the cash that your company has on hand after deducting elements such as salaries, rent, purchase of assets (e.g. equipment), and costs from the company income.

How do you write a simple cash flow statement? ›

Four Steps to Prepare a Cash Flow Statement
  1. Start with the Opening Balance. ...
  2. Calculate the Cash Coming in (Sources of Cash) ...
  3. Determine the Cash Going Out (Uses of Cash) ...
  4. Subtract Uses of Cash (Step 3) from your Cash Balance (sum of Steps 1 and 2)

What is the format of a cash flow statement? ›

Format of a cash flow statement

There are three sections in a cash flow statement: operating activities, investments, and financial activities. Operating activities: Operating activities are those cash flow activities that either generate revenue or record the money spent on producing a product or service.

How do I create a cash flow statement in Excel? ›

  1. Step 1: List the Business Drivers of Your Cash Flow Forecast. ...
  2. Step 2: Create a Monthly Cash Flow Model. ...
  3. Step 3: Use Simple Excel Formulas to Build a Cash Flow Model. ...
  4. Step 4: Summarise Cash Flow Projections into Tables and Graphs. ...
  5. Step 5: Forecast Equity Financing Requirement and the Use of Funds.
Sep 14, 2020

What is the best template for cash flow? ›

1. Sheetgo. The Sheetgo Cash flow template has been specifically designed and developed for optimal business management. It's more than a money log sheet; it separates accounts payable and receivable for improved oversight of your company.

What are the four rules for creating cash flow statement? ›

Four simple rules to remember as you create your cash flow statement:
  • Transactions that show an increase in assets result in a decrease in cash flow.
  • Transactions that show a decrease in assets result in an increase in cash flow.
  • Transactions that show an increase in liabilities result in an increase in cash flow.
Feb 28, 2024

What are the three types of cash flow statements? ›

The three categories of cash flows are operating activities, investing activities, and financing activities. Operating activities include cash activities related to net income. Investing activities include cash activities related to noncurrent assets.

Is cash flow statement easy? ›

The cash flow statement is believed to be the most intuitive of all the financial statements because it follows the cash made by the business in three main ways: through operations, investment, and financing. The sum of these three segments is called net cash flow.

What is a cash flow spreadsheet? ›

A cash flow template is a prestructured document that helps you create a “statement of cash flows,” also called the cash flow statement. It's one of the four key financial statements and details how much cash came into and went out of your business over a specific period of time. Download Excel template.

How to create cash flow? ›

Here are eleven strategies to help generate a positive cash flow:
  1. Bootstrap the Business.
  2. Talk With Vendors to Negotiate Terms.
  3. Save on Production Cost with Technology.
  4. Delay Expenses.
  5. Start a Partner Referral Program.
  6. Have Operating Assets.
  7. Send Invoices Early.
  8. Check Your Inventory.

What are the two types of cash flow statements? ›

There are two ways to prepare a cash flow statement: the direct method and the indirect method: Direct method – Operating cash flows are presented as a list of ingoing and outgoing cash flows. Essentially, the direct method subtracts the money you spend from the money you receive.

How do you fill out a cash flow worksheet? ›

There are 5 steps to complete the Cash Flow Worksheet:
  1. Review the cash flows options for the engagement.
  2. Define the closing cash and cash equivalents.
  3. Determine the number of analysis items.
  4. Complete the analysis items.
  5. Balance the Cash Flow Worksheet.

How to calculate cash flow statement? ›

Summary. Net Cash Flow = Total Cash Inflows – Total Cash Outflows.

Who is required to prepare cash flow statement? ›

An enterprise should prepare a cash flow statement and should present it for each period for which financial statements are presented. 2. Users of an enterprise's financial statements are interested in how the enterprise generates and uses cash and cash equivalents.

Is there a flow chart in Excel? ›

To access Excel's shape library, go to the insert tab and click “Shapes.” A gallery will appear with a variety of basic shapes including lines, arrows, and geometric shapes. Scroll down to find the flowchart section. Click the flowchart shape you want to add, then drag the shape to size on the Excel sheet.

How do I create a workflow template in Excel? ›

How to create a workflow in Excel
  1. Step 1: Identify the workflow. ...
  2. Step 2: Define inputs and outputs. ...
  3. Step 3: Plan the steps. ...
  4. Step 4: Create worksheets. ...
  5. Step 5: Design data entry forms. ...
  6. Step 6: Enter data. ...
  7. Step 7: Use formulas and functions. ...
  8. Step 8: Apply formatting and conditional formatting.

Top Articles
Latest Posts
Recommended Articles
Article information

Author: Aracelis Kilback

Last Updated:

Views: 5607

Rating: 4.3 / 5 (64 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Aracelis Kilback

Birthday: 1994-11-22

Address: Apt. 895 30151 Green Plain, Lake Mariela, RI 98141

Phone: +5992291857476

Job: Legal Officer

Hobby: LARPing, role-playing games, Slacklining, Reading, Inline skating, Brazilian jiu-jitsu, Dance

Introduction: My name is Aracelis Kilback, I am a nice, gentle, agreeable, joyous, attractive, combative, gifted person who loves writing and wants to share my knowledge and understanding with you.