Question

In: Accounting

Comparative balance sheets for 2018 and 2017, a statement of income for 2018, and additional information...

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 $ 44 $ 152
Accounts receivable 198 152
Prepaid insurance 12 5
Inventory 325 195
Buildings and equipment 440 370
Less: Accumulated depreciation (139 ) (260 )
$ 880 $ 614
Liabilities
Accounts payable $ 107 $ 140
Accrued expenses payable 11 16
Notes payable 70 0
Bonds payable 181 0
ShareholdersEquity
Common stock 420 420
Retained earnings 91 38
$ 880 $ 614
RED, INC.
Statement of Income
For Year Ended December 31, 2018
($ in millions)
Revenues
Sales revenue $ 2,200
Expenses
Cost of goods sold $ 1,482
Depreciation expense 50
Operating expenses 545 2,077
Net income $ 123


Additional information from the accounting records:

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

In order to maintain the usual policy of paying cash dividends of $70 million, it was necessary for Red to borrow $70 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.)

RED, INC.Statement of Cash FlowsFor year ended December 31, 2018

($ in millions)

Cash flows from operating activities:

Cash inflows:

Cash outflows:

Net cash flows from operating activities

Cash flows from investing activities:

Net cash flows from investing activities

Cash flows from financing activities:

Net cash flows from financing activities

Net increase (decrease) in cash

Cash balance, January 1

Cash balance, December 31

Solutions

Expert Solution

RED, INC.
Statement of Cash flows
For the Year Ended December 31, 2018
Amount in million
Cash flows from operating activities
Cash inflows:
Cash received from customers $   2,154 2200+152-198
Cash outflows:
Cash paid to suppliers $ (1,645) 1482+140-107+325-195
Cash paid for operating expenses $     (557) 545+16-11+12-5
Net cash provided by operating activities $   (48)
Cash flows from investing activities
Cash paid for purchase of equipment $     (250)
Cash received from sale of equipment $            9 180*5%
Net cash used by investing activities $ (241)
Cash flows from financing activities
Payment of cash dividend $       (70)
Cash received from issuance of note $         70
Cash received from issuance of bonds $       181
Net cash provided by financing activities $   181
Net Decrease in cash and cash equivalents $ (108)
Cash and cash equivalents at beginning of period $   152
Cash and cash equivalents at end of period $      44

You can reach me over comment box if you have any doubts. Please rate this answer


Related Solutions

Comparative balance sheets for 2018 and 2017, a statement of income for 2018, and additional information...
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 $ 44 $ 152 Accounts receivable 198 152 Prepaid insurance 12 5 Inventory 325 195 Buildings and equipment 440 370 Less: Accumulated depreciation (139 ) (260 ) $ 880 $ 614 Liabilities Accounts payable $ 107 $...
Comparative balance sheets for 2018 and 2017, a statement of income for 2018, and additional information...
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 $ 25 $ 112 Accounts receivable 180 133 Prepaid insurance 8 4 Inventory 287 176 Buildings and equipment 402 351 Less: Accumulated depreciation (120 ) (241 ) $ 782 $ 535 Liabilities Accounts payable $ 88 $...
Comparative balance sheets for 2018 and 2017, a statement of income for 2018, and additional information...
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 $ 24 $ 110 Accounts receivable 178 132 Prepaid insurance 7 3 Inventory 285 175 Buildings and equipment 400 350 Less: Accumulated depreciation (119 ) (240 ) $ 775 $ 530 Liabilities Accounts payable $ 87 $...
Comparative balance sheets for 2018 and 2017, a statement of income for 2018, and additional information...
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 $ 43 $ 138 Accounts receivable 196 151 Prepaid insurance 9 4 Inventory 302 194 Buildings and equipment 438 369 Less: Accumulated depreciation (138 ) (259 ) $ 850 $ 597 Liabilities Accounts payable $ 106 $...
Comparative balance sheets for 2018 and 2017, a statement of income for 2018, and additional information...
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 $...
Required information The comparative balance sheets for 2018 and 2017 and the statement of income for...
Required information The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 66 $ 38 Accounts receivable 49 76 Less: Allowance for uncollectible accounts (4 ) (3 ) Dividends receivable 4 3 Inventory 85 80 Long-term investment 51 44 Land 85 70...
Required information The comparative balance sheets for 2018 and 2017 and the statement of income for...
Required information The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 66 $ 38 Accounts receivable 49 76 Less: Allowance for uncollectible accounts (4 ) (3 ) Dividends receivable 4 3 Inventory 85 80 Long-term investment 51 44 Land 85 70...
Required information The comparative balance sheets for 2018 and 2017 and the statement of income for...
Required information The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 66 $ 38 Accounts receivable 49 76 Less: Allowance for uncollectible accounts (4 ) (3 ) Dividends receivable 4 3 Inventory 85 80 Long-term investment 51 44 Land 85 70...
Required information The comparative balance sheets for 2018 and 2017 and the statement of income for...
Required information The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 66 $ 38 Accounts receivable 49 76 Less: Allowance for uncollectible accounts (4 ) (3 ) Dividends receivable 4 3 Inventory 85 80 Long-term investment 51 44 Land 85 70...
Required information The comparative balance sheets for 2018 and 2017 and the statement of income for...
Required information The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 36 $ 28 Accounts receivable 47 58 Less: Allowance for uncollectible accounts (4 ) (3 ) Dividends receivable 7 6 Inventory 40 35 Long-term investment 28 26 Land 105 80...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT