#4 Principles of fin....

profilelar.ro
cash_flows_2013revision.xlsx

Sheet1

All negative cash outlflows should be entered as a negative number including a net loss
Carpet Company- Statement of Cash Flows (Direct Method) For Year Ending Dec. 31, 2010
Cash Flow from Direct Operating Activities
Cash flows from operating:
Cash received from customers:
Cash paid for merchandise:
Cash paid for wages/other operating expenses:
Cash paid for income taxes:
Net cash flow - operating activities: (Total) 0
Cash flows from investing:
Cash paid for equipment: _________
Net cash flow - operating activities: (Total) -------------------------------------à +I15 0
Cash flows from financing:
Cash received from issuing stock: ________
Cash paid for Dividends: ________
Net cash flow financing activities: ------------------------------------------------à +I19+I20 0
Reconciliation Statement of Cash Flows (Direct Method)- For Year Ending Dec. 31, 2010
·         Net increase in cash from 2009 to 2010: __________ 0
·         Cash balance at prior year (2009): __________ 0
·         Cash balance at current year-end (2010): __________ 0
See: Next page for Carpet Company- Statement of Cash Flows (Indirect Method) For Year Ending Dec. 31, 2010
Carpet Company- Statement of Cash Flows (Direct Method) For Year Ending Dec. 31, 2010
Cash flows from operating:
Net income:________
The following are the adjustments
to reconcile net income to cash provided by operations.
Adjustment in accounts receivables: ________
Adjustment in merchandise inventory: ________
Adjustment in accounts payable: ________
Adjustment in income taxes payable: ________
Add back depreciation expense: ________
Net cash flow - operating activities: (Total) ----------------------à _______________ 0
(Cash flow from Investing and from financing activities and reconciliation are the same under direct and indirect methods)
Cash flows from investing:
Cash paid for equipment: _________
Net cash flow - operating activities: (Total) -------------------------------------à +I15 0
Cash flows from financing:
Cash received from issuing stock: ________
Cash paid for Dividends: ________
Net cash flow financing activities: ------------------------------------------------à +I19+I20 0
Reconciliation Statement of Cash Flows (Direct Method)- For Year Ending Dec. 31, 2010
·         Net increase in cash from 2009 to 2010: __________ 0
·         Cash balance at prior year (2009): __________ 0
·         Cash balance at current year-end (2010): __________ 0
For Indirect Method- Cash Flow Rules- These rules are based on comparison of a previous year's balance sheet to a current balance sheet and apply to the
assets and liabilities line items from a previous year's balance to a current year's balance.
Cash Flow Rules are:
If Assets go up from the previous year to the current year, it is a use of cash (Company increased assets and decreased cash)
If Assets go down from the previous year to the current year, it is a source of cash (Company sold assets and increased cash)
If Liabilities go up from the previous year to the current year, it is a source of cash (Company increased its cash flow by using debt)
If Liabilities go down from the previous year to the current year, it is a use of cash (Company decreased cash flow by paying debt)