In: Accounting
Cheryl Wilson, president of Rivers Company, considers $48,000 to be a minimum cash balance for operating purposes. As can be seen from the following statements, only $43,000 in cash was available at the end of 2011. Because the company reported a large net income for the year, and also issued bonds and sold some long-term investments, the sharp decline in cash is puzzling to Ms. Feldman.
|
Rivers Company Comparative Balance Sheet December 31, 2011, and 2010 |
||||
| 2011 | 2010 | |||
| Assets | ||||
| Current assets: | ||||
| Cash | $ | 43,000 | $ | 66,600 |
| Accounts Receivable | 233,600 | 246,400 | ||
| Inventory | 275,200 | 212,800 | ||
| Prepaid expenses | 26,600 | 48,600 | ||
| Total current assets | 578,400 | 574,400 | ||
| Long-term investments | 174,000 | 260,000 | ||
| Plant and equipment | 916,000 | 778,000 | ||
| Less accumulated depreciation | 224,000 | 198,400 | ||
| Net plant and equipment | 692,000 | 579,600 | ||
| Total
assets |
$ | 1,444,400 | $ | 1,414,000 |
| Liabilities and Stockholders' equity | ||||
| Current liabilities: | ||||
| Accounts payable | $ | 200,200 | $ | 260,800 |
| Accrued liabilities | 10,800 | 20,600 | ||
| Income taxes payable | 64,400 | 53,000 | ||
| Total current liabilities | 275,400 | 334,400 | ||
| Bonds Payable | 284,000 | 156,000 | ||
| Total liabilities | 559,400 | 490,400 | ||
| Stockholders’ equity: | ||||
| Common stock | 665,000 | 740,000 | ||
| Retained earnings | 220,000 | 183,600 | ||
| Total stockholders' equity | 885,000 | 923,600 | ||
| Total liabilities and stockholders' equity | $ | 1,444,400 | $ | 1,414,000 |
|
Rivers Company Income Statement For the Year Ended December 31, 2011 |
|||
| Sales | $ | 1,360,000 | |
| Cost of goods sold | 850,000 | ||
| Gross margin | 510,000 | ||
| Selling and administrative expenses | 363,800 | ||
| Net operating income | 146,200 | ||
| Non operating items: | |||
| Gain on sale of investments | $34,000 | ||
| Loss on sale of equipment | (11,600) | 22,400 | |
| Income before taxes | 168,600 | ||
| Income taxes | 50,440 | ||
| Net income | $ | 118,160 | |
The following additional information is available for the year 2011:
a. The company sold long-term investments with an original cost of $86,000 for $120,000 during the year.
b. Equipment that had cost $146,000 and on which there was $68,000 in accumulated depreciation was sold during the year for $66,400.
c. The company declared and paid a cash dividend during the year.
d. The stock of a dissident stockholder was repurchased for cash and retired during the year. No issues of stock were made.
e. The company did not retire any bonds during the year.
Required: 1. Using the indirect method, determine the net cash provided by (used in) operating activities for 2011. (Negative amount should be indicated by a minus sign.)
2. Prepare a statement of cash flows for 2011. (Amounts to be deducted and negative amounts should be indicated with a minus sign.)
3. Compute free cash flow for 2011. (Negative amount should be indicated by a minus sign.)
| Cash flows from Operating activities: | |||||
| Net income for the year | 118160 | ||||
| Adjustment required for reconciliation | |||||
| Depreciation | (198400-68000-224000) | 93600 | |||
| Gain on sale of Investment | -34000 | ||||
| Loss on sale of equipment | 11600 | ||||
| Decrease in AR | 12800 | ||||
| Increase in Inventory | -62400 | ||||
| Decraese in Prepaid expense | 22000 | ||||
| Decrease in Accounts Payable | -60600 | ||||
| Decrease in Accrueed liabilities | -9800 | ||||
| Increase in Income tax liability | 11400 | ||||
| Net cash provided from Operating activities | 102760 | ||||
| CASH FLOW STATEMENT | |||||
| Cash flows from Operating activities: | |||||
| Net income for the year | 118160 | ||||
| Adjustment required for reconciliation | |||||
| Depreciation | (198400-68000-224000) | 93600 | |||
| Gain on sale of Investment | -34000 | ||||
| Loss on sale of equipment | 11600 | ||||
| Decrease in AR | 12800 | ||||
| Increase in Inventory | -62400 | ||||
| Decraese in Prepaid expense | 22000 | ||||
| Decrease in Accounts Payable | -60600 | ||||
| Decrease in Accrueed liabilities | -9800 | ||||
| Increase in Income tax liability | 11400 | ||||
| Net cash provided from Operating activities | 102760 | ||||
| Cash flows from Investing activities | |||||
| Sale of investment | 120000 | ||||
| Sale of Equipmnet | 66400 | ||||
| Purchase of equipment (778000-146000-916000) | -284000 | ||||
| Net cash used in investing activities | -97600 | ||||
| Cash flows from Financing activities: | |||||
| Issue of bonds | 128000 | ||||
| Retirment of common stock | -75000 | ||||
| Dividend paid | (183600+118160-220000) | -81760 | |||
| Net cash used in financing activities | -28760 | ||||
| Net decrease in cash | -23600 | ||||
| Beginning balance of cash | 66600 | ||||
| Ending Balance of cash | 43000 | ||||
| Ffree Cash flows: | |||||
| Net cash provided from operating activities | 102760 | ||||
| Less: Net cash used in investing activities | -97600 | ||||
| Free cash flows | 5160 | ||||