347 647 9001+1 714 797 8196Request a Call
Call Me

Cash Flow Statement: Learn to create Cash Flow Statement Template in Excel

August 8, 2013
, , , , , , , , , , ,

What is a Cash Flow Statement?

In financial accounting, a Cash Flow Statement, also known as Statement of Cash Flow, is a financial statement that shows how changes in balance sheet accounts and income affect cash and cash equivalents, and breaks the analysis down to operating, investing, and financing activities. Essentially, the cash flow statement is concerned with the flow of cash in and out of the business. The statement captures both the current operating results and the accompanying changes in the balance sheet. As an analytical tool, the statement of cash flows is useful in determining the short-term viability of a company, particularly its ability to pay bills. International Accounting Standard 7 (IAS 7), is the International Accounting Standard that deals with cash flow statements.

People and groups concerned with cash flow statements include:

  • Accounting personnel, who need to know whether the organization will be able to cover payroll and other immediate expenses

  • Potential lenders or creditors, who want a clear picture of a company's ability to repay

  • Potential investors, who need to judge whether the company is financially sound

  • Potential employees or contractors, who need to know whether the company will be able to afford compensation

  • Shareholders of the business.

If you have done financial modelling, you will know that making right cash flow statement is one of the critical tasks in the process of valuation of the company. Making an exact cash flow statement with all line items as per annual report of the company is an excellent idea but it requires a lot of accounting information of the company and as an Analyst, you always lack the information required to make a detailed cash flow statement.

As an Analyst you only need to have the balancing figure of "Cash and Cash equivalents" to tally the balance sheet and to compute the required figure. One need not make detailed cash flow account as per annual report of the company. You can easily figure out the required Cash and Cash equivalents amount using following equation:

Cash and Cash Equivalents = Total Liabilities + Shareholder's equity “Total Assets (Except Cash and Cash Equivalents)

Today we'll learn how to create Cash Flow Statement Template for a Real life Company - 'LinkedIn'.

Let's get started!

Task 1 in Creating Cash Flow Template: Getting Relevant Data for the Company

  • The numbers we need for creating the Cash Flow Statement of LinkedIn can be found in any of its annual reports or filings. There are many sources on the Internet such as the SEC website, the company website etc. where you can find these reports.

How to find data to make a Cash Flow Statement

Source: LinkedIn

  • Download both the PDF file and the Excel file by clicking the links as indicated in the above image

  • After downloading Excel file clean the data for P&L account and Balance sheet and make it in a presentable format as below.

LinkedIn's income statement template

LinkedIn's Balance Sheet

Task 2 in Creating Cash Flow Template: Classifying Balance Sheet Items

  • Classify each item on the balance sheet under Operating activity, Investing Activity or Financing Activity depending upon how they impact business

Cash Flow Statement

Task 3 in Creating Cash Flow Template: Developing the template in Excel

  • Type in the balance sheet items as you've classified them. Remember that the first item under Operating Activities is the Net Income.

Net income in cash flow statements
  • Just above the parameters, mention the currency and unit of the values you'll enter into the Balance Sheet. Enter the first year of projection in the next column. In our case, we start from 2010 and extend till 2012

Projections in Cash Flow Statements
  • Thereafter you can change the format of Years

  • To do so, select the Fiscal Years and Press 'Ctrl+1' and change the format to 'FY 0'

Formatting the Cash Flow Statement Template
  • Format the title row as shown below. Ensure that you mention the 'year ending' above the years

Formatting the rows
  • The Net Income values must be linked from the Income Statement

Linking the net income values from the income statment
  • Increase in Assets leads to a decrease in cash, hence we take Value in 2011 “Value of 2012 as the cash outflow for 2012

  • Using similar method calculate the cash outflow for all the operating items under Assets

Calcluating Cash outflow
  • Increase in Liabilities leads to an increase in cash, hence we take Value of 2011 as the cash inflow for 2012

  • Using similar method, calculate the cash outflow for all the operating items under Liabilities

Calculating cash outflow for all the liabilities
  • Using a similar concept as illustrated, we can calculate the cash inflows due to Investing and Financing Activities.

Finding Cash inflows due to investing and financing activities

Task 4 in Creating Cash Flow Template: Calculating Cash Balance

Calculating Total Cash Flow from Operating activities.

Calculating total cash flow from operating activities

Calculating Total Cash Flow from Investing activities

Calculating total cash flow from Investing activities

Calculating Total Cash Flow from Financing

Calculating total cash flow from Financing

Calculating Change in Cash

    Sum of Cash flow from Operating, Investing and Financing gives us overall change in Cash balance for that year.

Calculating sum of cash flow from operating, investing and financing activities

Calculating Final Cash Balance
  • Note that Cash at beginning of current year = Cash at ending of previous year

Cash at the beginning of the year is equal to the cash at the ending of previous year

Final Cash Flow Statement

Finding the final cash flow statement

This is our final Cash Flow Statement. Note that we haven't shown the Cash Flow for 2010. This is because our balance sheet does not have 2009 data. It is a simple matter of extending the formulas otherwise.

In case you're interested in learning in depth about how to create Cash Flow Statement template and complex financial models for companies, you can join our Financial Modeling course.

Templates to download:

  • UnFilled Cash Flow Statement Template: We've have created Cash Flow Statement template for you, where the subheadings are given and you have to use the functions to get the right values for you! You can go through the case and fill in the yellow boxes. We also recommend that you try to create this structure on your own

  • Filled Cash Flow Statement Template: You can also check if the information you recorded, matches our numbers or not.

  • If you have any doubts or queries, feel free to post them below


About the Author

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

Post ID = 30111