Creat Common size cash flow statements that toggles between dividing all cash fl
ID: 2728749 • Letter: C
Question
Creat Common size cash flow statements that toggles between dividing all cash flow account by sales or dividing all cash flow accoutns by beginning cash.
I want please to have the fourmals like
net income ( B5-G5)
Depr ( C5-D5)
to be able to type it there and have it correctly
Blue Sky, Inc. Cash Flow Statement 2 3 In $Thousands 4 Fiscal Year 5 Cash Flows from operations 6 Net Income 7 Depreciation 8 Change in Marketable Securities 9 Change in Accounts Receivable 10 Change in Inventory 11 Change in Prepaid Expenses 12 Change in Accounts Payable 13 Change in Accrued Expenses 14 Change in Other Current Liabilities 15 Cash Flows from operations 16 17 Cash Flows From Investing 18 Change in Gross Plant & Equipment 19 Change in Long Term Investments 20 Total Cash Flows from investing 21 22 Cash Flow From Financing 23 Change in Notes Payable 24 ChangeinLong-term Debt 25 Change in Common Stock at $1 Par 26 Change in Additional Paid-in-Capital 27 Total Dividends 28 Total Cash flows From Financing 29 2014 214.8 120.0 (50.0 (100.0) 400.0) (80.0 40.0 50.0 20.0 (185.2) (550.0) 90.0) (640.0) 50.0 380.0 20.0 481.2 883.2 30 Change in Cash Balance 31 58.0 32 Check against balance sheet 33 Beginning of Cash balance 34 Ending cash balance 35 Change in c ash balance 36 108.0 50.0 (58.0)Explanation / Answer
In the common size Cash flow Statements, there is a numerous cash changing transactions between the opening cash balance and the ending cash balance. All these transactions are being shown in a cash flow statement. But it is very difficult to have a fix format with formula in which you feed in the figures and you got the answer correct because in each and every problem there are a few different transactions which differs it with the other problem. You have to practice it with the format of the balance sheet which is the Current Assets and current liabilities and other assets and liabilities.