Question

In: Accounting

Problem 13-13 Prepare and Interpret a Statement of Cash Flows; Free Cash Flow [LO13-1, LO13-2, LO13-3]...

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.

  1. The company declared and paid a cash dividend.
  2. Equipment was sold during the year for $53,600. The equipment originally cost $114,000 and had accumulated depreciation of $52,000.
  3. Long-term investments that cost $54,000 were sold during the year for $80,000.
  4. 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.

Solutions

Expert Solution

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


Related Solutions

Problem 13-13 Prepare and Interpret a Statement of Cash Flows; Free Cash Flow [LO13-1, LO13-2, LO13-3]...
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 $40,000 to be the minimum cash balance for operating purposes. As can be seen from the following statements, only $35,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...
Problem 13-10 Prepare a Statement of Cash Flows; Free Cash Flow [LO13-1, LO13-2, LO13-3] Joyner Company’s...
Problem 13-10 Prepare a Statement of Cash Flows; Free Cash Flow [LO13-1, LO13-2, LO13-3] Joyner Company’s income statement for Year 2 follows: Sales $ 705,000 Cost of goods sold 208,000 Gross margin 497,000 Selling and administrative expenses 217,000 Net operating income 280,000 Nonoperating items: Gain on sale of equipment 7,000 Income before taxes 287,000 Income taxes 114,800 Net income $ 172,200 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1...
Problem 13-10 Prepare a Statement of Cash Flows; Free Cash Flow [LO13-1, LO13-2, LO13-3] Joyner Company’s...
Problem 13-10 Prepare a Statement of Cash Flows; Free Cash Flow [LO13-1, LO13-2, LO13-3] Joyner Company’s income statement for Year 2 follows: Sales $ 711,000 Cost of goods sold 227,000 Gross margin 484,000 Selling and administrative expenses 218,000 Net operating income 266,000 Nonoperating items: Gain on sale of equipment 8,000 Income before taxes 274,000 Income taxes 109,600 Net income $ 164,400 Its balance sheet amounts at the end of Years 1 and 2 are as follows: Year 2 Year 1...
Exercise 13-6 Prepare a Statement of Cash Flows; Free Cash Flow [LO13-1, LO13-2, LO13-3] Comparative financial...
Exercise 13-6 Prepare a Statement of Cash Flows; Free Cash Flow [LO13-1, LO13-2, LO13-3] Comparative financial statement data for Carmono Company follow: This Year Last Year Assets Cash and cash equivalents $ 3 $ 6 Accounts receivable 22 24 Inventory 50 40 Total current assets 75 70 Property, plant, and equipment 240 200 Less accumulated depreciation 65 50 Net property, plant, and equipment 175 150 Total assets $ 250 $ 220 Liabilities and Stockholders’ Equity Accounts payable $ 40 $...
Problem 12-13A Prepare and Interpret a Statement of Cash Flows; Free Cash Flow [LO12-1, LO12-2, LO12-3]...
Problem 12-13A Prepare and Interpret a Statement of Cash Flows; Free Cash Flow [LO12-1, LO12-2, LO12-3] Mary Walker, president of Rusco Company, considers $36,000 to be the minimum cash balance for operating purposes. As can be seen from the following statements, only $31,000 in cash was available at the end of 2015. 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....
Problem 13-7 Prepare a Statement of Cash Flows [LO13-1, LO13-2] [The following information applies to the...
Problem 13-7 Prepare a Statement of Cash Flows [LO13-1, LO13-2] [The following information applies to the questions displayed below.] Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash and cash equivalents $ 22 $ 11 Accounts receivable 292 230 Inventory 156 194 Prepaid expenses 8 5 Total current assets 478 440 Property, plant, and equipment 513 434 Less accumulated depreciation (81 ) (71 ) Net property, plant, and...
Problem 13-7 Prepare a Statement of Cash Flows [LO13-1, LO13-2] [The following information applies to the...
Problem 13-7 Prepare a Statement of Cash Flows [LO13-1, LO13-2] [The following information applies to the questions displayed below.] Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash and cash equivalents $ 20 $ 13 Accounts receivable 291 230 Inventory 159 196 Prepaid expenses 9 6 Total current assets 479 445 Property, plant, and equipment 507 428 Less accumulated depreciation (82 ) (70 ) Net property, plant, and...
Exercise 13-4 Prepare a Statement of Cash Flows [LO13-1, LO13-2] The following changes took place last...
Exercise 13-4 Prepare a Statement of Cash Flows [LO13-1, LO13-2] The following changes took place last year in Pavolik Company’s balance sheet accounts: Asset and Contra-Asset Accounts Liabilities and Stockholders' Equity Accounts Cash and cash equivalents $ 5 D Accounts payable $ 35 I Accounts receivable $ 110 I Accrued liabilities $ 4 D Inventory $ 70 D Income taxes payable $ 8 I Prepaid expenses $ 9 I Bonds payable $ 150 I Long-term investments $ 6 D Common...
Exercise 12-6 Prepare a Statement of Cash Flows; Free Cash Flow [LO12-1, LO12-2, LO12-3] Comparative financial...
Exercise 12-6 Prepare a Statement of Cash Flows; Free Cash Flow [LO12-1, LO12-2, LO12-3] Comparative financial statement data for Carmono Company follow: This Year Last Year   Assets   Cash $ 7.50      $ 14.00        Accounts receivable 50.00      43.00        Inventory 92.50      79.20        Total current assets 150.00      136.20        Property, plant, and equipment 231.00      194.00           Less accumulated depreciation 45.60      34.20        Net property, plant, and equipment 185.40      159.80        Total assets $ 335.40...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage...
Problem 13-23 Comprehensive Problem [LO13-1, LO13-2, LO13-3, LO13-5, LO13-6] Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 23% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT