August 8, 2013
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.
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:
Today we’ll learn how to create Cash Flow Statement Template for a Real life Company – ‘LinkedIn’.
Let’s get started!
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.
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.
Classify each item on the balance sheet under Operating activity, Investing Activity or Financing Activity depending upon how they impact business
Type in the balance sheet items as you’ve classified them. Remember that the first item under Operating Activities is the Net Income.
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
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’
Format the title row as shown below. Ensure that you mention the ‘year ending’ above the years
The Net Income values must be linked from the Income Statement
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
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
Using a similar concept as illustrated, we can calculate the cash inflows due to Investing and Financing Activities.
Calculating Total Cash Flow from Operating activities.
Calculating Total Cash Flow from Investing activities
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 Final Cash Balance
Note that Cash at beginning of current year = Cash at ending of previous year
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
Our counsellors will get in touch with you with more information about this topic.
* Mandatory Field