In: Accounting
Joyner Company’s income statement for Year 2 follows:
| Sales | $ | 707,000 |
| Cost of goods sold | 301,000 | |
| Gross margin | 406,000 | |
| Selling and administrative expenses | 217,000 | |
| Net operating income | 189,000 | |
| Nonoperating items: | ||
| Gain on sale of equipment | 8,000 | |
| Income before taxes | 197,000 | |
| Income taxes | 59,100 | |
| Net income | $ | 137,900 |
Its balance sheet amounts at the end of Years 1 and 2 are as follows:
| Year 2 | Year 1 | ||||
| Assets | |||||
| Cash and cash equivalents | $ | 90,200 | $ | 75,600 | |
| Accounts receivable | 262,000 | 142,000 | |||
| Inventory | 320,000 | 271,000 | |||
| Prepaid expenses | 9,000 | 18,000 | |||
| Total current assets | 681,200 | 506,600 | |||
| Property, plant, and equipment | 631,000 | 517,000 | |||
| Less accumulated depreciation | 166,300 | 131,100 | |||
| Net property, plant, and equipment | 464,700 | 385,900 | |||
| Loan to Hymans Company | 40,000 | 0 | |||
| Total assets | $ | 1,185,900 | $ | 892,500 | |
| Liabilities and Stockholders' Equity | |||||
| Accounts payable | $ | 317,000 | $ | 270,000 | |
| Accrued liabilities | 48,000 | 57,000 | |||
| Income taxes payable | 85,600 | 81,500 | |||
| Total current liabilities | 450,600 | 408,500 | |||
| Bonds payable | 203,000 | 111,000 | |||
| Total liabilities | 653,600 | 519,500 | |||
| Common stock | 333,000 | 280,000 | |||
| Retained earnings | 199,300 | 93,000 | |||
| Total stockholders' equity | 532,300 | 373,000 | |||
| Total liabilities and stockholders' equity | $ | 1,185,900 | $ | 892,500 | |
Equipment that had cost $31,600 and on which there was accumulated depreciation of $10,000 was sold during Year 2 for $29,600. 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.
Solution 1:
| Joyner Company | ||
| Statement of Cash Flows (Partial) | ||
| For year 2 | ||
| Particulars | Details | Amount |
| Cash Flow from Operating Activities: | ||
| Net Income | $137,900.00 | |
| Adjustments to reconcile net income to net cash provided by operations: | ||
| Depreciation Expense ($166,300 - $131,100 + $10,000) | $45,200.00 | |
| Gain on sale of equipment | -$8,000.00 | |
| Increase in accounts receivables ($262,000 - $142,000) | -$120,000.00 | |
| Increase in inventory ($320,000 - $271,000) | -$49,000.00 | |
| Decrease in prepaid expenses ($18,000 - $9,000) | $9,000.00 | |
| Increase in accounts payable ($317,000 - $270,000) | $47,000.00 | |
| Decrease in accrued liabilities ($57,000 - $48,000) | -$9,000.00 | |
| Increase in income tax payable ($85,600 - $81,500) | $4,100.00 | |
| Net Cash provided by operating activities | $57,200.00 | |
Solution 2:
| Joyner Company | ||
| Statement of Cash Flows | ||
| For year 2 | ||
| Particulars | Details | Amount |
| Cash Flow from Operating Activities: | ||
| Net Cash provided by operating activities | $57,200.00 | |
| Cash Flow from Investing Activities: | ||
| Purchase of Property, Plant and Equipment ($631,000 - $517,000 + $31,600) | -$145,600.00 | |
| Loan to Hymans Company | -$40,000.00 | |
| Sale of equipment | $29,600.00 | |
| Net Cash used in Investing activities | -$156,000.00 | |
| Cash Flow from Financing Activities: | ||
| Proceed from issue of common stock ($333,000 - $280,000) | $53,000.00 | |
| Dividend Paid ($93,000 + $137,900 - $199,300) | -$31,600.00 | |
| Proceed from issue of bond ($203,000 - $111,000) | $92,000.00 | |
| Net Cash Provided by financing activities | $113,400.00 | |
| Net Increase / (Decrease) in Cash | $14,600.00 | |
| Cash balance at beginning of year | $75,600.00 | |
| Cash balance at end of year | $90,200.00 | |
Solution 3:
Free cash flow = Cash flow from operating activities - Capital expenditure - Dividend
= $57,200 - $145,600 - $31,600
= ($120,000)