In: Accounting
Problem 13-13 Prepare and Interpret a Statement of Cash Flows; Free Cash Flow [LO13-1, LO13-2, LO13-3]
Mary Walker, president of Rusco Company, considers $32,000 to be the minimum cash balance for operating purposes. As can be seen from the following statements, only $27,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 and cash equivalents | $ | 27,000 | $ | 47,400 | |
Accounts receivable | 236,800 | 225,600 | |||
Inventory | 260,800 | 203,200 | |||
Prepaid expenses | 15,400 | 29,400 | |||
Total current assets | 540,000 | 505,600 | |||
Long-term investments | 126,000 | 180,000 | |||
Plant and equipment | 884,000 | 762,000 | |||
Less accumulated depreciation | 216,000 | 193,600 | |||
Net plant and equipment | 668,000 | 568,400 | |||
Total assets | $ | 1,334,000 | $ | 1,254,000 | |
Liabilities and Stockholders' Equity | |||||
Current liabilities: | |||||
Accounts payable | $ | 243,200 | $ | 177,400 | |
Accrued liabilities | 9,200 | 17,400 | |||
Income taxes payable | 51,600 | 45,000 | |||
Total current liabilities | 304,000 | 239,800 | |||
Bonds Payable | 236,000 | 124,000 | |||
Total liabilities | 540,000 | 363,800 | |||
Stockholders’ equity: | |||||
Common stock | 695,000 | 660,000 | |||
Retained earnings | 99,000 | 230,200 | |||
Total stockholders' equity | 794,000 | 890,200 | |||
Total liabilities and stockholders' equity | $ | 1,334,000 | $ | 1,254,000 | |
Rusco Company Income Statement For This Year Ended July 31 |
||||||
Sales | $ | 1,040,000 | ||||
Cost of goods sold | 650,000 | |||||
Gross margin | 390,000 | |||||
Selling and administrative expenses | 278,200 | |||||
Net operating income | 111,800 | |||||
Nonoperating items: | ||||||
Gain on sale of investments | $ | 26,000 | ||||
Loss on sale of equipment | (8,400 | ) | 17,600 | |||
Income before taxes | 129,400 | |||||
Income taxes | 38,760 | |||||
Net income | $ | 90,640 | ||||
The following additional information is available for this year.
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.
1.
RUSCO COMPANY | |||
Statement of Cash flows | |||
For the Year Ended July 31 | |||
Cash flows from operating activities | |||
Net Income | $ 90,640 | ||
Adjustments to reconcile net income to ; | |||
Depreciation expense | $ 74,400 | 216000-193600+52000 | |
Gain on sale of investment | $ (26,000) | ||
Loss on sale of equipment | $ 8,400 | ||
Increase in accounts receivable | $ (11,200) | ||
Increase in inventory | $ (57,600) | ||
Decrease in prepaid expenses | $ 14,000 | ||
Increase in accounts payable | $ 65,800 | ||
Decrease in accrued liabilities | $ (8,200) | ||
Increase in income tax payable | $ 6,600 | ||
$ 66,200 | |||
Net cash provided by operating activities | $ 156,840 |
2.
RUSCO COMPANY | |||
Statement of Cash flows | |||
For the Year Ended July 31 | |||
Cash flows from operating activities | |||
Net Income | $ 90,640 | ||
Adjustments to reconcile net income to ; | |||
Depreciation expense | $ 74,400 | 216000-193600+52000 | |
Gain on sale of investment | $ (26,000) | ||
Loss on sale of equipment | $ 8,400 | ||
Increase in accounts receivable | $ (11,200) | ||
Increase in inventory | $ (57,600) | ||
Decrease in prepaid expenses | $ 14,000 | ||
Increase in accounts payable | $ 65,800 | ||
Decrease in accrued liabilities | $ (8,200) | ||
Increase in income tax payable | $ 6,600 | ||
$ 66,200 | |||
Net cash provided by operating activities | $ 156,840 | ||
Cash flows from investing activities | |||
Cash paid for purchase of Equipment | $ (236,000) | 762000-884000-114000 | |
Cash received from sale of equipment | $ 53,600 | ||
Cash received from sale investments | $ 80,000 | ||
Net cash used by investing activities | $ (102,400) | ||
Cash flows from financing activities | |||
Dividend payments | $ (221,840) | 99000-230200-90640 | |
Cash received from issue of bonds | $ 112,000 | ||
Cash received from issue of common stock | $ 35,000 | ||
Net cash used by financing activities | $ (74,840) | ||
Net Decrease in cash and cash equivalents | $ (20,400) | ||
Cash and cash equivalents at beginning of period | $ 47,400 | ||
Cash and cash equivalents at end of period | $ 27,000 |
3.
Net cash provided by operating activities | $ 156,840 |
Less: Capital expenditure | $ (236,000) |
Less: Dividends paid | $ (221,840) |
Free cash flow | $ (301,000) |
You can reach me over comment box, if you have any doubts.
Please rate this answer