In: Accounting
Mary Walker, president of Rusco Company, considers $42,000 to be the minimum cash balance for operating purposes. As can be seen from the following statements, only $37,000 in cash was available at the end of this year. Since the company reported a large net income for the year, and also issued both bonds and common stock, the sharp decline in cash is puzzling to Ms. Walker.
Rusco Company Comparative Balance Sheet at July 31 |
|||||
This Year | Last Year | ||||
Assets | |||||
Current assets: | |||||
Cash | $ | 37,000 | $ | 59,400 | |
Accounts Receivable | 250,800 | 238,600 | |||
Inventory | 269,800 | 209,200 | |||
Prepaid expenses | 22,400 | 41,400 | |||
Total current assets | 580,000 | 548,600 | |||
Long-term investments | 156,000 | 230,000 | |||
Plant and equipment | 904,000 | 772,000 | |||
Less accumulated depreciation | 221,000 | 196,600 | |||
Net plant and equipment | 683,000 | 575,400 | |||
Total assets | $ | 1,419,000 | $ | 1,354,000 | |
Liabilities and Stockholders' Equity | |||||
Current liabilities: | |||||
Accounts payable | $ | 179,400 | $ | 254,200 | |
Accrued liabilities | 10,200 | 19,400 | |||
Income taxes payable | 59,600 | 50,000 | |||
Total current liabilities | 249,200 | 323,600 | |||
Bonds Payable | 266,000 | 144,000 | |||
Total liabilities | 515,200 | 467,600 | |||
Stockholders’ equity: | |||||
Common stock | 770,000 | 710,000 | |||
Retained earnings | 133,800 | 176,400 | |||
Total stockholders' equity | 903,800 | 886,400 | |||
Total liabilities and stockholders' equity | $ | 1,419,000 | $ | 1,354,000 | |
Rusco Company Income Statement For This Year Ended July 31 |
||||||
Sales | $ | 1,240,000 | ||||
Cost of goods sold | 775,000 | |||||
Gross margin | 465,000 | |||||
Selling and administrative expenses | 331,700 | |||||
Net operating income | 133,300 | |||||
Nonoperating items: | ||||||
Gain on sale of investments | $ | 31,000 | ||||
Loss on sale of equipment | (10,400 | ) | 20,600 | |||
Income before taxes | 153,900 | |||||
Income taxes | 46,060 | |||||
Net income | $ | 107,840 | ||||
The following additional information is available for this year.
The company declared and paid a cash dividend.
Equipment was sold during the year for $61,600. The equipment originally cost $134,000 and had accumulated depreciation of $62,000.
Long-term investments that cost $74,000 were sold during the year for $105,000.
The company did not retire any bonds payable or repurchase any of its common stock.
Required:
1. Using the indirect method, compute the net cash provided by/used in operating activities for this year.
2. Prepare a statement of cash flows for this year.
3. Compute free cash flow for this year.
Using the indirect method, compute the net cash provided by/used in operating activities for this year. (List any deduction in cash and cash outflows as negative amounts.)
|
Prepare a statement of cash flows for this year. (List any deduction in cash and cash outflows as negative amounts.)
|
Compute free cash flow for this year. (Negative amount should be indicated by a minus sign.)
|
1
Using the indirect method, compute the net cash provided by/used in operating activities for this year.
Net cash for operating activities |
45440 |
Working for the answer
Cash Flow statement |
||
Cash flows from operating activities |
||
Net income |
107840 |
|
Adjustment to reconcile net income |
||
non cash expenses - Depreciation |
86400 |
|
Non operating gains |
-31000 |
|
non operating losses |
10400 |
|
Increase in accounts receivable |
-12200 |
|
Increase in inventory |
-60600 |
|
Decrease in prepaid Expanses |
19000 |
|
Decrease in accounts payable |
-74800 |
|
Decrease in accrued liabilities |
-9200 |
|
Increase in income taxes payable |
9600 |
-62400 |
Net cash for operating activities |
45440 |
2
Cash Flow statement |
||
Cash flows from operating activities |
||
Net income |
107840 |
|
Adjustment to reconcile net income |
||
non cash expenses - Depreciation |
86400 |
|
Non operating gains |
-31000 |
|
non operating losses |
10400 |
|
Increase in accounts receivable |
-12200 |
|
Increase in inventory |
-60600 |
|
Decrease in prepaid Expases |
19000 |
|
Decrease in accounts payable |
-74800 |
|
Decrease in accrued liabilities |
-9200 |
|
Increase in income taxes payable |
9600 |
-62400 |
Net cash for operating activities |
45440 |
|
2) Investing activites |
||
Addittions to equipment |
-266000 |
|
proceeds from sale of equipment |
61600 |
|
proceeds from sale of investment |
105000 |
|
Cash flow from Investing activity |
-99400 |
|
3) financing acivities |
||
increase in bonds payable |
122000 |
|
Common stock decrease |
60000 |
|
Cash dividend paid |
-150440 |
|
Decrease in cash from financing activities |
31560 |
|
Net decrease in cash and cash eqivalents |
-22400 |
|
Cash at the beginning of the yr |
59400 |
|
cash at the end of the yr |
37000 |
3
Net cash provided by operating activities |
45440 |
|
Capital expenditures |
-266000 |
|
Dividends |
-150440 |
-416440 |
Free cash flow |
-371000 |
Free cash flow |
-371000 |