In: Accounting
Problem 13-10 Prepare a Statement of Cash Flows; Free Cash Flow [LO13-1, LO13-2, LO13-3]
Joyner Company’s income statement for Year 2 follows:
| Sales | $ | 705,000 |
| Cost of goods sold | 208,000 | |
| Gross margin | 497,000 | |
| Selling and administrative expenses | 217,000 | |
| Net operating income | 280,000 | |
| Nonoperating items: | ||
| Gain on sale of equipment | 7,000 | |
| Income before taxes | 287,000 | |
| Income taxes | 114,800 | |
| Net income | $ | 172,200 |
Its balance sheet amounts at the end of Years 1 and 2 are as follows:
| Year 2 | Year 1 | ||||
| Assets | |||||
| Cash and cash equivalents | $ | 122,800 | $ | 63,500 | |
| Accounts receivable | 265,000 | 133,000 | |||
| Inventory | 319,000 | 271,000 | |||
| Prepaid expenses | 10,000 | 20,000 | |||
| Total current assets | 716,800 | 487,500 | |||
| Property, plant, and equipment | 625,000 | 513,000 | |||
| Less accumulated depreciation | 166,600 | 130,500 | |||
| Net property, plant, and equipment | 458,400 | 382,500 | |||
| Loan to Hymans Company | 47,000 | 0 | |||
| Total assets | $ | 1,222,200 | $ | 870,000 | |
| Liabilities and Stockholders' Equity | |||||
| Accounts payable | $ | 319,000 | $ | 253,000 | |
| Accrued liabilities | 47,000 | 59,000 | |||
| Income taxes payable | 85,100 | 80,000 | |||
| Total current liabilities | 451,100 | 392,000 | |||
| Bonds payable | 194,000 | 103,000 | |||
| Total liabilities | 645,100 | 495,000 | |||
| Common stock | 344,000 | 282,000 | |||
| Retained earnings | 233,100 | 93,000 | |||
| Total stockholders' equity | 577,100 | 375,000 | |||
| Total liabilities and stockholders' equity | $ | 1,222,200 | $ | 870,000 | |
Equipment that had cost $31,200 and on which there was accumulated depreciation of $11,200 was sold during Year 2 for $27,000. The company declared and paid a cash dividend during Year 2. It did not retire any bonds or repurchase any of its own stock.
Required:
1. Using the indirect method, compute the net cash provided by/used in operating activities for Year 2.
2. Prepare a statement of cash flows for Year 2.
3. Compute the free cash flow for Year 2.
| ans 1 | Year 2 | |
| Statement of cash flow | ||
| Cash flows from operating activities | ||
| Net income | $172,200 | |
| Adjustments to reconcile net income to net cash provided by operating activities | ||
| Depreciation expenses 166600-(130500-11200) | 47300 | |
| Gain on sale of equipment | -7000 | |
| Increase in Accounts receivable | -132000 | |
| Increase in Inventory | -48000 | |
| Increase in Accounts Payable | 66000 | |
| Decrease in Accured liabilities | -12000 | |
| Increase in Income tax payable | 5100 | |
| -80600 | ||
| Net cash from operating activities | 91600 | |
| ans 2 | ||
| Statement of cash flow | ||
| Cash flows from operating activities | ||
| Net income | $172,200 | |
| Adjustments to reconcile net income to net cash provided by operating activities | ||
| Depreciation expenses 166600-(130500-11200) | 47300 | |
| Gain on sale of equipment | -7000 | |
| Increase in Accounts receivable | -132000 | |
| Increase in Inventory | -48000 | |
| Increase in Accounts Payable | 66000 | |
| Decrease in Accured liabilities | -12000 | |
| Increase in Income tax payable | 5100 | |
| -80600 | ||
| Net cash from operating activities | 91600 | |
| Cash flows from investing activities | ||
| Purchase of equipment (513000-31200)-625000 | -143200 | |
| Loan to Hymas company | -47000 | |
| Sale of equipment | 27000 | |
| -163200 | ||
| Net cash used investing activities | (163,200.00) | |
| Cash flows from financing activities | ||
| Borrowing of bonds payable | 91,000.00 | |
| Issuance of common stock | 62,000.00 | |
| Payment of Cash Dividend 233100-(93000+172200) | -32100 | |
| 120,900.00 | ||
| Net cash used financing activitie | 120,900.00 | |
| Net Increase in cash and cash equivalents | 49,300.00 | |
| Cash and cash equivalents at beginning of period | 63,500.00 | |
| Ending Balance | 112,800.00 | |
| ans 3 | ||
| Free cash flow=Net cash from operating activities-Capital expenditure | ||
| 91600-143200 | -51600 | |
| It’s a negative free cash flow | ||
| If any doubt please comment | ||