Question

Prepare statement of cash flows (indirect method) using balance sheet data Following are comparative I#lance sheets for Millco, Inc., at January 31 and February 28, 2020: MILLCO, INC. Balance Sheets January 31 and February 28, 2020 Assets: Cash Accounts receivable Merchandise inventory Total current assets Plant and Equipment: Production equipment Less: Accumulated depreciation Total assets Feb. 28 $126,000 192,000 243,000 $561,000 Jan. 31 $111,000 159,000 282,000 $552,000 $498,000 (72,000) $987,000 $456,000 (63,000) $945,000 Liabilities: Accounts payable Short-term debt Other accrued liabilities Total current liabilities Long-term debt Total liabilities $111,000 132,000 63,000 $306,000 99,000 $405,000 $123,000 132,000 72,000 $327,000 138,000 $465,000 $312,000 $288,000 Stockholders' Equity: Common stock, no par value, 80,000 shares authorized, 60,000 and 56,000 shares issued, respectively Retained earnings: Beginning balance Net income for the month Dividends Ending balance Total stockholders' equity Total liabilities and stockholders' equity $192,000 108,000 (30,000) $ 270,000 $ 582,000 $ 987.000 $129,000 87,000 (24,000) $192,000 $480,000 $945.000 Required: Prepare a statement of cash flows that explains the change that occurred in cash during the month. You may assume that the change in each balance sheet amount is due to a single event (for example, the change in the amount of production equipment is not the result of both a purchase and sale of equipment). (Hints: What is the purpose of the statement of cash flows? How is this purpose accomplished?) Use the space to the right of the January 31 data to enter the difference between the February 28 and January 31 amounts of each balance sheet item; these are the amounts that will be in your solution.

Answer 1

Cash Flow Statement (Indirect Method)
Particulars	Amount	Amount
Net Income		$    108,000.00
Adjustments to reconcile net income to:
Net cash provided by operating activities
Depreciation	$        9,000.00
Increase in Accounts Receivable	$    (33,000.00)
Decrease in Inventory	$      39,000.00
Decrease in Accounts Payable	$    (12,000.00)
Decrease in Other accrued liabilities	$       (9,000.00)
Net Cash Generated		$       (6,000.00)
Net cash provided by operating activities	(A)	$    102,000.00
Cash Flows from Investing Activities
Purchase of Plant and Equipment	$    (42,000.00)
Net cash provided by investing activities	(B)	$    (42,000.00)
Cash Flows from Financing Activities
Reduction in Long term debt	$    (39,000.00)
Dividend paid	$    (30,000.00)
Increase in common stock	$      24,000.00
Net cash provided by Financing activities	(C')	$    (45,000.00)
Net increase/decrease in cash	(A+B+C')	$      15,000.00
Add:Opening cash balance		$    111,000.00
Closing cash balance		$    126,000.00