Question

Comparative balance sheets for 2018 and 2017, a statement of income for 2018, and additional information from the accounting records of Red, Inc., are provided below.

RED, INC. Comparative Balance Sheets December 31, 2018 and 2017 ($ in millions)
	2018				2017
Assets
Cash	$	42			$	138
Accounts receivable		194				150
Prepaid insurance		14				8
Inventory		300				193
Buildings and equipment		436				368
Less: Accumulated depreciation		(137	)			(258	)
	$	849			$	599
Liabilities
Accounts payable	$	105			$	136
Accrued expenses payable		13				21
Notes payable		68				0
Bonds payable		144				0
Shareholders’ Equity
Common stock		418				418
Retained earnings		101				24
	$	849			$	599

RED, INC. Statement of Income For Year Ended December 31, 2018
($ in millions)
Revenues
Sales revenue				$	2,180
Expenses
Cost of goods sold	$	1,468
Depreciation expense		41
Operating expenses		526			2,035
Net income				$	145

Additional information from the accounting records:

During 2018, $248 million of equipment was purchased to replace $180 million of equipment (90% depreciated) sold at book value.

In order to maintain the usual policy of paying cash dividends of $68 million, it was necessary for Red to borrow $68 million from its bank.

Required:
Prepare the statement of cash flows of Red, Inc., using the direct method to report operating activities. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10). Amounts to be deducted should be indicated with a minus sign.)

Answer 1

Solution :

Computation of cash received from customers
Particulars	Amount (In Million)
Beginning accounts receivables	$150.00
Add: Sales	$2,180.00
Less: Ending accounts receivables	$194.00
Cash received from customers	$2,136.00

Computation of cash paid for inventory
Particulars	Amount (In Million)
Cost of Goods Sold	$1,468.00
Add: Ending inventory	$300.00
Less: Beginning inventory	$193.00
Purchases made during the year	$1,575.00
Add: Opening accounts payable	$136.00
Less: Ending accounts payable	$105.00
Cash paid to supplier for inventory	$1,606.00

Computation of cash paid for Operating Expenses
Particulars	Amount (In Million)
Operating Expenses	$526.00
Add: Ending Prepaid Insurance	$14.00
Less: Beginning prepaid insurance	$8.00
Add: Beginning accrued expenses payable	$21.00
Less: Ending accrued expenses payable	$13.00
Cash paid for operating expenses	$540.00

Red Inc.
Statement of Cash Flows
For Year Ended December 31, 2018
Particulars	Details	Amount (In Million)
Cash Flows from operating activities:
Cash received from customers	$2,136.00
Cash paid to supplier for inventory	-$1,606.00
Cash paid for operating expenses	-$540.00
Net Cash provided by operating activities		-$10.00
Cash flow from investing activities:
Cash received from sale of equipment ($180*10%)	$18.00
Cash paid for purchase of equipment	-$248.00
Net Cash used in investing activities		-$230.00
Cash flow from financing activities:
Proceed from bank loan	$68.00
Proceed from issue of bond	$144.00
Cash paid for dividends	-$68.00
Net Cash used in financing activities		$144.00
Net Increase (Decrease) in Cash		-$96.00
Cash balance at beginning of year		$138.00
Cash balance at end of year		$42.00