As the accountant for Awesome Foods Incorporated, you are responsible for preparing the cash flow statement. You have decided to prepare the statement using the indirect method and have gathered the following data from the accounting records:
Principal payments on non-current debt $ 50,000
Collections on accounts receivable 287,500
Increase in accounts payable 25,300
Acquisition of equipment by issuing non-current note payable 70,000
Depreciation expense 71,500
Collection of loan principal 58,000
Proceeds from sale of investments, not including $5,100 gain 49,100
Increase in accounts receivable 7,200
Cash payments to purchase capital assets 62,000
Decrease in accrued liabilities 30,600
Payment of cash dividends 43,500
Income tax expense and payment 39,300
Proceeds from sale of capital assets, not including $7,400 loss 22,600
Net income 143,100
Cash sales 217,400
Proceeds from issuance of common shares 300,000
Increase 41,700
Loan to another company 50,000
Bonds payable converted into common shares 130,000
Payments to suppliers 283,100
Decrease in prepaid expenses 12,800
Cash balance: December 31, 2016 62,500
Cash balance: December 31, 2017 462,200
Prepare the cash flow statement for the year ended December 31, 2017, using the indirect method.
Awesome Foods Inc. |
||
Cash Flow from Operating Activities: |
||
Cash Flow from Investing Activities: |
||
Cash Flow from Financing Activities: |
||
Net Increase/(Decrease) in Cash: |
||
Cash Balance: January 1, 2016 |
||
Cash Balance: December 31, 2017 |
Your best friend just lost his job because the company he was working for went bankrupt. He was complaining to you that even though the company had been profitable for three years in a row, it still went out of business. He asks you how this can happen.
Explain the most likely reason for the company declaring bankruptcy. Could your best friend have seen it coming? How?
Answer-
AWESOME FOODS INCORPORATED | ||
STATEMENT OF CASH FLOWS (USING INDIRECT METHOD) | ||
FOR THE YEAR ENDED 31 DECEMBER,2017 | ||
Particulars | Amount | |
$ | ||
Cash flow from operating activities | ||
Net Income | 143100 | |
Adjustments to reconcile net income to net cash provided by operating activities | ||
Adjustment for non cash effects | ||
Depreciation expense | 71500 | |
Loss on sale of equipment | 7400 | |
Gain on sale of investments | -5100 | |
Change in operating assets & liabilities | ||
Increase in accounts receivable | -7200 | |
Incresae in inventory | -41700 | |
Decrease in prepaid expenses | 12800 | |
Decrease in accrued liabilities | -30600 | |
Increase in accounts payable | 25300 | |
Net cash flow from operating activities (a) | 175500 | |
Cash Flow from Investing activities | ||
New capital assets purchased | -62000 | |
Old capital assets sold | 22600 | |
Proceeds from sale of investments | 49100 | |
Net cash Flow from Investing activities (b) | 9700 | |
Cash Flow from Financing activities | ||
Cash dividends paid | -43500 | |
Principal payments of non-current debt | -50000 | |
Collection of loan principal | 58000 | |
Proceeds from issuance of common shares | 300000 | |
Loan to another company | -50000 | |
Net cash Flow from Financing activities (c) | 214500 | |
Net Change in cash c=a+b+c | 399700 | |
Beginning cash balance | 62500 | |
Closing cash balance | 462200 | |
Schedule of non cash investing & financing activities | ||
Acquisition of equipment by issuing non-current note payable | $70000 | |
Bonds payable converted into common shares |
$130000 |
The reason for bankruptcy is the cash flows of the firm. A Higher profitable firm need not be solvent if its cash flows are not well managed. For example if it has higher inventory and receivables the cash flows can be lower than the net profit reported. The net income and expense is reported based on the accrual concept in Income statement and hence it ignores the cash flows of the firm. The cash flows of the firm is the key to remain solvent and net profit is not the indicator of solvency
Yes, my best friend could have seen it coming by reading the cash flow statement which is part of the financial statements published. Cash flow statement gives details of movement in cash and cash equivalent during the year. Hence it is made mandatory to be given as part of financial statements. Cash flow statement shows sources of cash and how it is used in the business. It classifies activities into operating, investing and financing.
As the accountant for Awesome Foods Incorporated, you are responsible for preparing the cash flow statement....
Unit 9 - Statement of Cash Flow As the accountant for Awesome Foods Incorporated, you are responsible for preparing the cash flow statement. You have decided to prepare the statement using the indirect method and have gathered the following data from the accounting records: Principal payments on non-current debt $ 50,000 Collections on accounts receivable 287,500 Increase in accounts payable 24,300 Acquisition of equipment by issuing non-current note payable 70,000 Depreciation expense 71,300 Collection of loan principal 58,000 Proceeds from...
As the accountant for Awesome Foods Incorporated, you are responsible for preparing the cash flow statement. You have decided to prepare the statement using the indirect method and have gathered the following data from the accounting records: Principal payments on non-current debt$ 50,000 Collections on accounts receivable287,500 Increase in accounts payable25,300 Acquisition of equipment by issuing non-current note payable70,000 Depreciation expense71,500 Collection of loan principal58,000 Proceeds from sale of investments, not including $5,100 gain49,100 Increase in accounts receivable7,200 Cash payments...
As the accountant for Awesome Foods Incorporated, you are responsible for preparing the cash flow statement. You have decided to prepare the statement using the indirect method and have gathered the following data from the accounting records Principal payments on non-current debt$ 50,000 Collections on accounts receivable287,500 Increase in accounts payable24,300 Acquisition of equipment by issuing non-current note payable70,000 Depreciation expense71,300 Collection of loan principal58,000 Proceeds from sale of investments, not including $5,100 gain49,100 Increase in accounts receivable7,200 Cash payments...
Question 2 (30 marks) Unit 9 - Statement of Cash Flow As the accountant for Awesome Foods Incorporated, you are responsible for preparing the cash flow statement. You have decided to prepare the statement using the indirect method and have gathered the following data from the accounting records: Principal payments on non-current debt$ 50,000 Collections on accounts receivable287,500 Increase in accounts payable24,300 Acquisition of equipment by issuing non-current note payable70,000 Depreciation expense71,300 Collection of loan principal58,000 Proceeds from sale of...
Question 2 (30 marks) Unit 9 - Statement of Cash Flow As the accountant for Awesome Foods Incorporated, you are responsible for preparing the cash flow statement. You have decided to prepare the statement using the indirect method and have gathered the following data from the accounting records: Principal payments on non-current debt$ 50,000 Collections on accounts receivable287,500 Increase in accounts payable24,300 Acquisition of equipment by issuing non-current note payable70,000 Depreciation expense71,300 Collection of loan principa158,000 Proceeds from sale of...
Cash Flow Statement The accountant of Organic Foods, Inc, assembled the following data entity's statement of cash flows for the period ended December 31, 201 Investment by the owner Collections from customers Advance payments received from customers- Proceeds from sale of an old computer unit - Loan proceeds from bank P100,000 150,000 40,000 5,000 Total cash receipts 370,00 Payments were made for the following items: O Purchase of an office conditioning unit O Salaries P 30,000 135,000 20,000 10,000 15,000...
Principal payments on non-current debis 50,000 Collections an accounts receivable287,500 Increase in accounts payable24,300 Acquisition of equipment by issuing non-current note payable70,000 Depreciation expense71,300 Collection of loan principal58,000 Proceeds from sale of investments, not including $5,100 gain49,100 Increase in accounts receivable7,200 Cash payments to purchase capital assets62,000 Decrease in accrued liabilities 30,600 Payment of cash dividends 46,500 Income tax expense and payments 19,300 Proceeds from sale of capital assets, not including $7,400 loss 22,600 Net income147,100 Cash sales217,400 Proceeds from...
Preparing a Statement of Cash Flows Erie Company reported the following comparative balance sheets: 2019 2018 Assets: Cash $33,200 $12,750 Accounts receivable 53,000 44,800 Inventory 29,500 27,500 Prepaid rent 2,200 6,200 Investments (long-term) 17,600 31,800 Property, plant, and equipment 162,000 149,450 Accumulated depreciation (61,600) (56,200) Total assets $235,900 $216,300 Liabilities and Equity: Accounts payable $16,900 $19,500 Interest payable 3,500 4,800 Wages payable 9,600 7,100 Income taxes payable 5,500 3,600 Notes payable 30,400 53,000 Common stock 100,000 68,500 Retained earnings 70,000...
Determining Net Income from Net Cash Flow from Operating Activities Curwen Inc. reported net cash flow from operating activities of $201,300 on its statement of cash flows for the year ended December 31. The following information was reported in the "Cash flows from operating activities" section of the statement of cash flows, using the indirect method: Decrease in income taxes payable Decrease in inventories $4,500 11,200 17,300 7,800 Depreciation Gain on sale of investments Increase in accounts payable 3,100 Increase...
Curwen Inc. reported net cash flow from operating activities of $201,300 on its statement of cash flows for the year ended December 31. The following information was reported in the Cash Flows from Operating Activities section of the statement of cash flows, using the indirect method: Decrease in income taxes payable $4,600 Decrease in inventories 11,500 Depreciation 17,700 Gain on sale of investments 8,000 Increase in accounts payable 3,200 Increase in prepaid expenses 1,900 Increase in accounts receivable 8,700 a....