In: Accounting
Joyner Company’s income statement for Year 2 follows:
Sales | $ | 708,000 |
Cost of goods sold | 387,000 | |
Gross margin | 321,000 | |
Selling and administrative expenses | 151,100 | |
Net operating income | 169,900 | |
Nonoperating items: | ||
Gain on sale of equipment | 8,000 | |
Income before taxes | 177,900 | |
Income taxes | 53,370 | |
Net income | $ | 124,530 |
Its balance sheet amounts at the end of Years 1 and 2 are as follows:
Year 2 | Year 1 | ||||
Assets | |||||
Cash and cash equivalents | $ | 97,030 | $ | 80,700 | |
Accounts receivable | 228,000 | 132,000 | |||
Inventory | 319,000 | 276,000 | |||
Prepaid expenses | 8,500 | 17,000 | |||
Total current assets | 652,530 | 505,700 | |||
Property, plant, and equipment | 620,000 | 519,000 | |||
Less accumulated depreciation | 165,300 | 130,600 | |||
Net property, plant, and equipment | 454,700 | 388,400 | |||
Loan to Hymans Company | 46,000 | 0 | |||
Total assets | $ | 1,153,230 | $ | 894,100 | |
Liabilities and Stockholders' Equity | |||||
Accounts payable | $ | 314,000 | $ | 270,000 | |
Accrued liabilities | 45,000 | 51,000 | |||
Income taxes payable | 85,200 | 81,100 | |||
Total current liabilities | 444,200 | 402,100 | |||
Bonds payable | 191,000 | 113,000 | |||
Total liabilities | 635,200 | 515,100 | |||
Common stock | 332,000 | 284,000 | |||
Retained earnings | 186,030 | 95,000 | |||
Total stockholders' equity | 518,030 | 379,000 | |||
Total liabilities and stockholders' equity | $ | 1,153,230 | $ | 894,100 | |
Equipment that had cost $30,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.
1.) | Cash flows from operating activities-Indirect Method | |||
Particulars | Amount | Working | ||
Cash flows from operating activities | ||||
Net income | 124,530 | Given | ||
Adjustments for: | ||||
Depreciation on property, plant & equipment | 45,900 | (165,300-130,600+11,200) | ||
Gain on Sale of equipment | -8,000 | Given | ||
Increase in accounts receivables | -96,000 | (132,000-228,000 ) | ||
Increase in inventories | -43,000 | (276,000-319,000 ) | ||
Decrease in prepaid expenses | 8,500 | (17,000-8,500 ) | ||
Increase in accounts payable | 44,000 | (314,000-270,000) | ||
Increase in income tax payable | 4,100 | (85,200-81,100) | ||
Decrease in accured liabilities | -6,000 | (45,000-51,000) | ||
Cash generated from operating activities | 74,030 | |||
2.) | Statement of Cash flow for Year 2 | |||
Particulars | Amount | Working | ||
Cash flow from operating activities | 74,030 | |||
Cash flows from investing activities | ||||
Sale of equipment | 27,000 | Given | ||
Purchase of property, plant & equipment | -131,200 | (620,000 - 519,000 + 30,200 ) | ||
Loan to Hymans Company | -46,000 | Given | ||
Net cash used in investing activities | -150,200 | |||
Cash flows from financing activities | ||||
Proceeds from issue of common stock | 48,000 | (332,000-284,000 ) | ||
Proceeds from issue of bond payable | 78,000 | (191,000-113,000) | ||
Dividend paid | -33,500 | ( 95,000 + 124,530 - 518,030 ) | ||
Net cash used in financing activities | 92,500 | |||
Net increase in cash and cash equivalents (A) | 16,330 | |||
Cash and cash equivalents at beginning of period (B) | 80,700 | Given | ||
Cash and cash equivalents at end of period =A+B | 97,030 | Given | ||
- | ||||
3.) | Free Cash Flow for year 2 | |||
Net cash provided by opeating activities | 74,030 | |||
Less: Capital Expenditure | 131,200 | |||
Less: Dividends | 33,500 | |||
Free cash flow for year 2 | -90,670 | |||