How to Prepare a Cash Flow Statement | HBS Online (2024)

Cash flow statements are one of the three fundamental financial statements financial leaders use. Along with income statements and balance sheets, cash flow statements provide crucial financial data that informs organizational decision-making. While all three are important to the assessment of a company’s finances, some business leaders might argue cash flow statements are the most important.

Business owners, managers, and company stakeholders use cash flow statements to better understand their companies’ value and overall health and guide financial decision-making. Regardless of your position, learning how to create and interpret financial statements can empower you to understand your company’s inner workings and contribute to its future success.

Related:

Here’s a look at what a cash flow statement is and how to create one.

Free E-Book: A Manager's Guide to Finance & Accounting

Access your free e-book today.

DOWNLOAD NOW

What Is a Cash Flow Statement?

A cash flow statement is a financial report that details how cash entered and left a business during a reporting period.

According to the online course Financial Accounting: “The purpose of the statement of cash flows is to provide a more detailed picture of what happened to a business’s cash during an accounting period.”

Related:

Since cash flow statements provide insight into different areas a business used or received cash during a specific period, they’re important financial statements when it comes to valuing a company and understanding how it operates.

A typical cash flow statement comprises three sections: cash flow from operating activities, cash flow from investing activities, and cash flow from financing activities.

How to Create a Cash Flow Statement

How to Prepare a Cash Flow Statement | HBS Online (1)

1. Determine the Starting Balance

The first step in preparing a cash flow statement is determining the starting balance of cash and cash equivalents at the beginning of the reporting period. This value can be found on the income statement of the same accounting period.

The starting cash balance is necessary when leveraging the indirect method of calculating cash flow from operating activities. However, the direct method doesn’t require this information.

2. Calculate Cash Flow from Operating Activities

One you have your starting balance, you need to calculate cash flow from operating activities. This step is crucial because it reveals how much cash a company generated from its operations.

Cash flow from operations are calculated using either the direct or indirect method.

Direct Method

The direct method of calculating cash flow from operating activities is a straightforward process that involves taking all the cash collections from operations and subtracting all the cash disbursem*nts from operations. This approach lists all the transactions that resulted in cash paid or received during the reporting period.

Indirect Method

The indirect method of calculating cash flow from operating activities requires you to start with net income from the income statement (see step one above) and make adjustments to “undo” the impact of the accruals made during the reporting period. Some of the most common and consistent adjustments include depreciation and amortization.

Related: Financial Terminology: 20 Financial Terms to Know

Both the direct and indirect methods will result in the same number, but the process of calculating cash flow from operations differs.

While the direct method is easier to understand, it’s more time-consuming because it requires accounting for every transaction that took place during the reporting period. Most companies prefer the indirect method because it's faster and closely linked to the balance sheet. However, both methods are accepted by Generally Accepted Accounting Principles (GAAP) and International Financial Reporting Standards (IFRS).

Related: GAAP vs. IFRS: What Are the Key Differences and Which Should You Use?

3. Calculate Cash Flow from Investing Activities

After calculating cash flows from operating activities, you need to calculate cash flows from investing activities. This section of the cash flow statement details cash flows related to the buying and selling of long-term assets like property, facilities, and equipment. Keep in mind that this section only includes investing activities involving free cash, not debt.

4. Calculate Cash Flow from Financing Activity

The third section of the cash flow statement examines cash inflows and outflows related to financing activities. This includes cash flows from both debt and equity financing—cash flows associated with raising cash and paying back debts to investors and creditors.

When using GAAP, this section also includes dividends paid, which may be included in the operating section when using IFRS standards. Interest paid is included in the operating section under GAAP, but sometimes in the financing section under IFRS as well.

5. Determine the Ending Balance

Once cash flows generated from the three main types of business activities are accounted for, you can determine the ending balance of cash and cash equivalents at the close of the reporting period.

The change in net cash for the period is equal to the sum of cash flows from operating, investing, and financing activities. This value shows the total amount of cash a company gained or lost during the reporting period. A positive net cash flow indicates a company had more cash flowing into it than out of it, while a negative net cash flow indicates it spent more than it earned.

Cash Flow Statement Example

To help visualize each section of the cash flow statement, here’s an example of a fictional company generated using the indirect method.

How to Prepare a Cash Flow Statement | HBS Online (3)

Go to the alternative version.

This cash flow statement is for a reporting period that ended on Sept. 28, 2019. As you'll notice at the top of the statement, the opening balance of cash and cash equivalents was approximately $10.7 billion.

During the reporting period, operating activities generated a total of $53.7 billion. The investing activities section shows the business used a total of $33.8 billion in transactions related to investments. The financing activities section shows a total of $16.3 billion was spent on activities related to debt and equity financing.

At the bottom of the cash flow statement, the three sections are summed to total a $3.5 billion increase in cash and cash equivalents over the course of the reporting period. Therefore, the final balance of cash and cash equivalents at the end of the year equals $14.3 billion.

Financial Decision-Making

Whether you’re a manager, entrepreneur, or individual contributor, understanding how to create and leverage financial statements is essential for making sound business decisions.

The statement of cash flows is one of the most important financial reports to understand because it provides detailed insights into how a company spends and makes its cash. By learning how to create and analyze cash flow statements, you can make better, more informed decisions, regardless of your position.

Are you interested in gaining a toolkit for making smarter financial decisions and the confidence to clearly communicate them to key stakeholders? Explore Financial Accounting—one of three courses comprising our Credential of Readiness (CORe) program—to discover how you can unlock critical insights into your organization’s performance and potential. Not sure which course is right for you? Download our free flowchart.

Data Tables

Company A - Statement of Cash Flows (Alternative Version)

Year Ended September 28, 2019 (In millions)

Cash and cash equivalents, beginning of the year: $10,746

OPERATING ACTIVITIES

Activity Amount
Net Income 37,037
Adjustments to Reconcile Net Income to Cash Generated by Operating Activities:
Depreciation and Amortization 6,757
Deferred Income Tax Expense 1,141
Other 2,253
Changes in Operating Assets and Liabilities:
Accounts Receivable, Net (2,172)
Inventories (973)
Vendor Non-Trade Receivables 223
Other Current and Non-Current Assets 1,080
Accounts Payable 2,340
Deferred Revenue 1,459
Other Current and Non-Current Liabilities 4,521
Cash Generated by Operating Activities 53,666

INVESTING ACTIVITIES

Activity Amount
Purchases of Marketable Securities (148,489)
Proceeds from Maturities of Marketable Securities 20,317
Proceeds from Sales of Marketable Securities 104,130
Payments Made in Connection with Business Acquisitions, Net of Cash Acquired (496)
Payments for Acquisition of Intangible Assets (911)
Other (160)
Cash Used in Investing Activities (33,774)

FINANCING ACTIVITIES

Activity Amount
Dividends and Dividend Equivalent Rights Paid (10,564)
Repurchase of Common Stock (22,860)
Proceeds from Issuance of Long-Term Debt, Net 16,896
Other 149
Cash Used in Financing Activities (16,379)

Increase / Decrease in Cash and Cash Equivalents: 3,513

Cash and Cash Equivalents, End of Year: $14,259

Go back to the article.

I am a seasoned financial analyst with extensive expertise in financial statements and cash flow analysis. I have a background in finance and accounting, and I have successfully assisted organizations in optimizing their financial strategies. My knowledge is grounded in hands-on experience and a thorough understanding of financial principles.

Now, let's delve into the key concepts outlined in the article about cash flow statements:

  1. Importance of Cash Flow Statements:

    • Cash flow statements are one of the three fundamental financial statements alongside income statements and balance sheets.
    • They provide crucial financial data for organizational decision-making.
    • Some business leaders argue that cash flow statements are the most important among the three.
  2. Users of Cash Flow Statements:

    • Business owners, managers, and company stakeholders use cash flow statements to understand the company's value and overall health.
    • These statements guide financial decision-making across various roles within an organization.
  3. Definition of a Cash Flow Statement:

    • A cash flow statement details how cash enters and leaves a business during a specific reporting period.
    • Its purpose is to provide a detailed picture of what happened to a business’s cash during the accounting period.
  4. Components of a Cash Flow Statement:

    • A typical cash flow statement comprises three sections: cash flow from operating activities, cash flow from investing activities, and cash flow from financing activities.
  5. Steps to Create a Cash Flow Statement:

    • Determine the Starting Balance:
      • Find the starting balance of cash and cash equivalents from the income statement.
    • Calculate Cash Flow from Operating Activities:
      • Use either the direct or indirect method, both accepted by GAAP and IFRS.
    • Calculate Cash Flow from Investing Activities:
      • Detail cash flows related to buying and selling long-term assets.
    • Calculate Cash Flow from Financing Activities:
      • Examine cash inflows and outflows related to financing activities, including debt and equity financing.
    • Determine the Ending Balance:
      • Sum the cash flows from the three main business activities to find the ending balance.
  6. Cash Flow Statement Example:

    • The article provides an example using the indirect method for a fictional company.
    • It shows the starting balance, cash flows from operating, investing, and financing activities, and the ending balance.
  7. Financial Decision-Making:

    • Understanding how to create and leverage financial statements, particularly the statement of cash flows, is crucial for making sound business decisions.
    • It provides detailed insights into how a company spends and makes its cash.

In conclusion, mastering the creation and analysis of cash flow statements empowers individuals at all levels to contribute to a company's success by making informed financial decisions.

How to Prepare a Cash Flow Statement | HBS Online (2024)

FAQs

How to Prepare a Cash Flow Statement | HBS Online? ›

Free Cash Flow = Net income + Depreciation/Amortization – Change in Working Capital – Capital Expenditure. Operating Cash Flow = Operating Income + Depreciation – Taxes + Change in Working Capital. Cash Flow Forecast = Beginning Cash + Projected Inflows – Projected Outflows = Ending Cash.

How do I make a cash flow statement online? ›

How to Prepare a Cash Flow Statement Format Indirect Method?
  1. Collect the Necessary Documents: ...
  2. Start With Net Income: ...
  3. Create a List of Non-Cash Operating Activities: ...
  4. Create a Cash List From Cash Operating Activities: ...
  5. List Liabilities: ...
  6. Calculate Operating Adjustments: ...
  7. Add Investing Activities:

How do you prepare a 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)

How do you solve cash flow questions? ›

Free Cash Flow = Net income + Depreciation/Amortization – Change in Working Capital – Capital Expenditure. Operating Cash Flow = Operating Income + Depreciation – Taxes + Change in Working Capital. Cash Flow Forecast = Beginning Cash + Projected Inflows – Projected Outflows = Ending Cash.

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.

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.

How do you know if your cash flow statement is correct? ›

How can you ensure cash flow statement accuracy?
  1. Review your income statement and balance sheet.
  2. Categorize your cash flows correctly. ...
  3. Use the indirect method for operating cash flows. ...
  4. Reconcile your cash flows with your bank statements. ...
  5. Use accounting software and tools. ...
  6. Here's what else to consider.
Sep 14, 2023

What should a statement of cash flow look like? ›

The three main components of a cash flow statement are cash flow from operations, cash flow from investing, and cash flow from financing. The two different accounting methods, accrual accounting and cash accounting, determine how a cash flow statement is presented.

How to prepare a cash flow statement step by step indirect method? ›

How to Build an Indirect Method Cash Flow Statement
  1. Step 1: Calculate Net Income. ...
  2. Step 2: Add Back Any Non-Cash Expenses. ...
  3. Step 3: Account for Changes in Current Assets and Liabilities. ...
  4. Step 4: Adjust for Changes in Long-Term Assets and Liabilities. ...
  5. Step 5: Calculate the Operating Cash Flow.
Jun 16, 2023

What is the easiest way to calculate cash flow? ›

To calculate operating cash flow, add your net income and non-cash expenses, then subtract the change in working capital. These can all be found in a cash-flow statement.

How do you solve for free cash flow? ›

The free cash flow formula is calculated as operating income minus capital expenses. It can be used to determine whether a company has sufficient funds to cover its short-term financial obligations or if it needs to look for external financing sources.

What is an example of a simple cash flow? ›

Examples of cash flow include: receiving payments from customers for goods or services, paying employees' wages, investing in new equipment or property, taking out a loan, and receiving dividends from investments.

Where do you start when creating a statement of cash flows? ›

To create a cash flow statement, organize all cash transactions under the following three primary sections.
  • Cash from operating activities. Record cash expended and received from the company's main line of business. ...
  • Cash from investing activities. ...
  • Cash from financing.
Jan 31, 2024

How to create monthly cash flow? ›

Work out your running cash flow

For each week or month column, take away your net outgoings from your net income. That will give you either a positive cash flow figure (you've got more cash coming in than you're spending) or a negative cash flow figure (you're spending more than you've got coming in).

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

Does QuickBooks online have a cash flow statement? ›

Yes, QuickBooks does provide a cash flow statement as part of its financial reporting capabilities. The cash flow statement in QuickBooks helps track and analyze the movement of cash in and out of a business over a specific period of time.

Can QuickBooks do a cash flow statement? ›

Make better business decisions

Quickly generate your cash flow statement with QuickBooks, and you'll get a clear view of your cash flow for any time period.

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.

Top Articles
Latest Posts
Article information

Author: Dean Jakubowski Ret

Last Updated:

Views: 5805

Rating: 5 / 5 (50 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Dean Jakubowski Ret

Birthday: 1996-05-10

Address: Apt. 425 4346 Santiago Islands, Shariside, AK 38830-1874

Phone: +96313309894162

Job: Legacy Sales Designer

Hobby: Baseball, Wood carving, Candle making, Jigsaw puzzles, Lacemaking, Parkour, Drawing

Introduction: My name is Dean Jakubowski Ret, I am a enthusiastic, friendly, homely, handsome, zealous, brainy, elegant person who loves writing and wants to share my knowledge and understanding with you.