Joyner Company’s income statement for Year 2 follows:
Sales | $ | 700,000 |
Cost of goods sold | 207,000 | |
Gross margin | 493,000 | |
Selling and administrative expenses | 216,000 | |
Net operating income | 277,000 | |
Nonoperating items: | ||
Gain on sale of equipment | 7,000 | |
Income before taxes | 284,000 | |
Income taxes | 113,600 | |
Net income | $ | 170,400 |
Its balance sheet amounts at the end of Years 1 and 2 are as follows:
Year 2 | Year 1 | ||||
Assets | |||||
Cash | $ | 120,800 | $ | 73,300 | |
Accounts receivable | 267,000 | 131,000 | |||
Inventory | 319,000 | 276,000 | |||
Prepaid expenses | 9,000 | 18,000 | |||
Total current assets | 715,800 | 498,300 | |||
Property, plant, and equipment | 632,000 | 511,000 | |||
Less accumulated depreciation | 166,700 | 130,100 | |||
Net property, plant, and equipment | 465,300 | 380,900 | |||
Loan to Hymans Company | 47,000 | 0 | |||
Total assets | $ | 1,228,100 | $ | 879,200 | |
Liabilities and Stockholders' Equity | |||||
Accounts payable | $ | 320,000 | $ | 267,000 | |
Accrued liabilities | 44,000 | 55,000 | |||
Income taxes payable | 84,200 | 80,200 | |||
Total current liabilities | 448,200 | 402,200 | |||
Bonds payable | 198,000 | 101,000 | |||
Total liabilities | 646,200 | 503,200 | |||
Common stock | 347,000 | 280,000 | |||
Retained earnings | 234,900 | 96,000 | |||
Total stockholders' equity | 581,900 | 376,000 | |||
Total liabilities and stockholders' equity | $ | 1,228,100 | $ | 879,200 | |
Equipment that had cost $32,000 and on which there was accumulated depreciation of $10,600 was sold during Year 2 for $28,400. 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. In calculating the cash flows statement from indirect method, we will start with the net income. We will add back the non cash item of depreciation & deduct the gain on sale of equipment in it. Then we will adjust the amount for increase or decrease in cash due to increase or decrease in current assets or current liabilities.Like, an increase in current assets will reduce cash, so we will deduct it and a decrease in current assets will increase cash, so we will add it. Similarly, an increase in current liabilities will increase cash, so it will be added and a decrease in current liabilities will reduce cash, so it will be deducted. Before proceeding with the cash flow statement, we will check for certain adjustments given as below:
(a) Depreciation expense for year 2:
Accumulated Depreciation in Year 2 : $166700
Add: Accumulated depreciation of equipment sold : $10600
Less: Accumulated depreciation in year 1: ($130100)
Depreciation for year 2 : $47200
(b) Purchase of equipment:
Ending equipment (year 2, gross amount) : $632000
Add: Cost of the equipment sold : $32000
Less: Beginning equipment (year 1, gross amount): ($511000)
Purchase of equipment $153000
(c) Dividend paid:
Ending retained earnings ( in year 2) : $234900
Less: Net income : ($170400)
Less: Beginning retained earnings : ($96000)
Dividend paid : ($31500)
Statement of cash flows for year 2
Net income $170400
Add: Depreciation $47200
Less: Gain on sale of equipment ($7000)
Less: Increase in accounts receivable ($136000)
Less: Increase in inventory ($43000)
Add: Decrease in prepaid expenses $9000
Add: Increase in accounts payable $53000
Less: Decrease in accrued liability ($11000)
Add: Increase in income tax payable $4000
Cash from operating activities $86600
2. We will take cash from operating activities from above point (1)
Cash from operating activities $86600
Purchase of equipment ($153000)
Sale of equipment $28400
Loan to hymans company ($47000)
Cash from investing activities ($171600)
Dividends paid ($31500)
Proceeds from bonds payable $97000
Proceeds from common stock $67000
Cash from financing activities $132500
Net cash provided by operating
investing and financing activities $47500
Beginning cash balance $73300
Ending cash balance $120800
3. Free cash flows = Cash from operating activities - Capital expenditure
Cash from operating activities = $86600 (as calculated in point (1))
Capital expenditure = Equipment purchase = $153000
Free cash flows = $86600 - $153000 = ($66400)
Joyner Company’s income statement for Year 2 follows: Sales $ 700,000 Cost of goods sold 207,000...
Joyner Company’s income statement for Year 2 follows Sales $ 702,000 Cost of goods sold 219,000 Gross margin 483,000 Selling and administrative expenses 218,000 Net operating income 265,000 Nonoperating items: Gain on sale of equipment 6,000 Income before taxes 271,000 Income taxes 81,300 Net income $ 189,700 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash $ 139,800 $ 69,200 Accounts receivable 263,000 114,000 Inventory 320,000 283,000 Prepaid...
Joyner Company’s income statement for Year 2 follows: Sales $ 718,000 Cost of goods sold 230,000 Gross margin 488,000 Selling and administrative expenses 218,000 Net operating income 270,000 Nonoperating items: Gain on sale of equipment 7,000 Income before taxes 277,000 Income taxes 83,100 Net income $ 193,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 $ 123,100 $ 43,500 Accounts receivable 260,000 148,000 Inventory...
Joyner Company’s income statement for Year 2 follows: Sales $ 718,000 Cost of goods sold 43,000 Gross margin 675,000 Selling and administrative expenses 218,000 Net operating income 457,000 Nonoperating items: Gain on sale of equipment 8,000 Income before taxes 465,000 Income taxes 139,500 Net income $ 325,500 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash and cash equivalents $ 285,100 $ 78,400 Accounts receivable 255,000 124,000 Inventory...
Joyner Company’s income statement for Year 2 follows: Sales $ 715,000 Cost of goods sold 182,000 Gross margin 533,000 Selling and administrative expenses 218,000 Net operating income 315,000 Nonoperating items: Gain on sale of equipment 8,000 Income before taxes 323,000 Income taxes 129,200 Net income $ 193,800 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash and cash equivalents $ 143,500 $ 91,000 Accounts receivable 274,000 123,000 Inventory...
Joyner Company’s income statement for Year 2 follows: Sales $ 708,000 Cost of goods sold 399,000 Gross margin 309,000 Selling and administrative expenses 216,000 Net operating income 93,000 Nonoperating items: Gain on sale of equipment 8,000 Income before taxes 101,000 Income taxes 40,400 Net income $ 60,600 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash and cash equivalents $ 14,900 $ 60,100 Accounts receivable 269,000 147,000 Inventory...
Joyner Company’s income statement for Year 2 follows: Sales $ 701,000 Cost of goods sold 322,000 Gross margin 379,000 Selling and administrative expenses 216,000 Net operating income 163,000 Nonoperating items: Gain on sale of equipment 10,000 Income before taxes 173,000 Income taxes 69,200 Net income $ 103,800 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash and cash equivalents $ 35,000 $ 85,200 Accounts receivable 263,000 127,000 Inventory...
Joyner Company’s income statement for Year 2 follows: Sales $ 712,000 Cost of goods sold 91,000 Gross margin 621,000 Selling and administrative expenses 216,000 Net operating income 405,000 Nonoperating items: Gain on sale of equipment 6,000 Income before taxes 411,000 Income taxes 123,300 Net income $ 287,700 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash $ 242,200 $ 92,500 Accounts receivable 269,000 114,000 Inventory 320,000 271,000 Prepaid...
Joyner Company’s income statement for Year 2 follows: Sales $ 714,000 Cost of goods sold 365,000 Gross margin 349,000 Selling and administrative expenses 217,000 Net operating income 132,000 Nonoperating items: Gain on sale of equipment 9,000 Income before taxes 141,000 Income taxes 56,400 Net income $ 84,600 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash $ 33,400 $ 81,600 Accounts receivable 262,000 110,000 Inventory 319,000 276,000 Prepaid...
Joyner Company’s income statement for Year 2 follows: Sales $ 713,000 Cost of goods sold 287,000 Gross margin 426,000 Selling and administrative expenses 218,000 Net operating income 208,000 Nonoperating items: Gain on sale of equipment 5,000 Income before taxes 213,000 Income taxes 85,200 Net income $ 127,800 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash $ 54,600 $ 45,900 Accounts receivable 276,000 135,000 Inventory 320,000 287,000 Prepaid...
Joyner Company’s income statement for Year 2 follows: Sales $ 714,000 Cost of goods sold 84,000 Gross margin 630,000 Selling and administrative expenses 217,000 Net operating income 413,000 Nonoperating items: Gain on sale of equipment 7,000 Income before taxes 420,000 Income taxes 126,000 Net income $ 294,000 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1 Assets Cash and cash equivalents $ 234,000 $ 69,900 Accounts receivable 250,000 114,000 Inventory...