
Spreadsheet for Statement of Cash Flows Balance 7/1/18 Balance 12/31/18 Panel A Balance Sheet 0 Cash...
1 The Statement of Cash Flows 2 Using Excel to prepare the statement of cash flows, indirect method 4 5 The James Island Clothing Company began operations on July 1, 2018. The adjusted trial balance as of December 31, 2018, appears below, along with transaction data for 2018. JAMES ISLAND CLOTHING COMPANY Adjusted Trial Balance 12/31/18 Account Title Cash Accounts Receivable Inventory Office Equipment Truck Accumulated Depreciation-Plant Assets Accounts Payable Note Payable-Short Term Note Payable-Long Term Common Stock Retained Earnings...
Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Transaction Analysis Balance Balance 12/31/2017 Panel A Balance Sheet: DEBIT CREDIT 12/31/2018 Cash Accounts Receivable 15,300 4,330 14,600 (500) 33,730 19,800 5,330 16,300 (700) Plant Assets 1,700 Accumulated Depreciation 40,730 Total Assets Accounts Payable 6,700 5,400 Common Stock, no par 5,300 28,130 22,830 4,200 33,730 5,500 Retained Earnings 7,200 40,730 Total Liabilities and Stockholders' Equity Panel B_Statement of Cash Flows: 200 Cash Flows from Operating Activities: Net Income Adjustments...
9. Michael, Inc.'s accountant has partially completed the spreadsheet for the statement of cash flows. Fill in the remaining missing information. (lf a bax is not used in the statement, leave the box emply do not select a label or enter a zero, Dot check your answer until bath Panel A and Panel B have been completed) (Click the icon to view the information) Balance 12/31/2018 Michael, Inc. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Balance...
Statement of Cash Flows Your supervisor has provided you with the following statement of cash flows, prepared using the indirect method. Recall that the statement of cash flows consists of three sections: cash flows from operating activities, cash flows from investing activities, and cash flows from financing activities. Review the statement, and then proceed to the next panel. Championship Boxing, Inc. Statement of Cash Flows For the Year Ended December 31, 20Y8 Cash flows from (used for) operating activities: Net...
Statement of Cash Flows-Indirect Method The comparative balance sheet of Harris Industries Inc. at December 31, 2014 and 2043, is as follows: Dec. 31, Dec. 31, 2014 2013 Assets Cash Accounts receivable (net) Inventories Prepaid expenses $443,240 665,280 887,880 $360,920 592,200 1,022,560 31,640 25,200 Land 302,400 302,400 Buildings 1,713,600 (466,200) 1,134,000 (414,540) Accumulated depreciation-buildings Machinery and equipment Accumulated depreciation-machinery and equipment 781,200 (214,200) 106,960 $4,251,800 781,200 (191,520) 112,000 $3,724,420 Patents Total assets $837,480 32,760 Liabilities and Stockholders' Equity Accounts payable...
Statement of Cash Flows—Indirect Method The comparative balance sheet of Livers Inc. for December 31, 20Y3 and 20Y2, is shown as follows: Dec. 31, 20Y3 Dec. 31, 20Y2 Assets Cash $253,630 $237,840 Accounts receivable (net) 91,880 85,420 Inventories 259,370 252,910 Investments 0 97,980 Land 133,030 0 Equipment 286,170 223,600 Accumulated depreciation—equipment (67,000) (60,300) Total assets $957,080 $837,450 Liabilities and Stockholders' Equity Accounts payable (merchandise creditors) $173,230 $164,980 Accrued expenses payable (operating expenses) 17,230 21,770 Dividends payable 9,570 7,540 Common stock,...
Championship Boxing, Inc.
Statement of Cash Flows
For the Year Ended December 31, 20Y8
Cash flows from (used for) operating activities:
Net income
$186,540
Adjustments to reconcile net income to net cash
flow from operating activities:
Depreciation
18,400
Gain on sale of investments
(50,000)
Changes in current operating assets and liabilities:
Increase in accounts receivable
(25,410)
Increase in inventories
(33,450)
Increase in accounts payable
41,130
Decrease in accrued expenses payable
(12,470)
Net cash flow from
operating activities
$124,740
Cash flows...
Statement of Cash Flows—Indirect Method The comparative balance sheet of Olson-Jones Industries Inc. for December 31, 20Y2 and 20Y1, is as follows: Dec. 31, 20Y2 Dec. 31, 20Y1 Assets Cash $183 $14 Accounts receivable (net) 55 49 Inventories 117 99 Land 250 330 Equipment 205 175 Accumulated depreciation—equipment (68) (42) Total assets $742 $625 Liabilities and Stockholders' Equity Accounts payable (merchandise creditors) $51 $37 Dividends payable 5 - Common stock, $1 par 125 80 Paid-in capital in excess of par—common...
FUN Clipboard PRODUCT NOTICE Most of the features of Excel have been disabled because it hasn't been activated. Activate 554 1 The Statement of Cash Flows 2 Using Excel to prepare the statement of cash flows, indirect method 4 The James Island Clothing Company began operations on July 1, 2018 5 The adjusted trial balance as of December 31, 2018, appears below, along with transaction data for 2018. JAMES ISLAND CLOTHING COMPANY Adjusted Trial Balance 12/31/18 Account Title Cash Accounts...
Statement of Cash Flows-Indirect Method The comparative balance sheet of Olson-Jones Industries Inc. for December 31, 2012 and 2041, is as follows: Dec. 31, 2012 Dec. 31, 2011 Assets Cash $183 o Accounts receivable (net) Inventories o Land 250 o on (68) $742 (42) $625 Equipment Accumulated depreciation equipment Total assets Liabilities and Stockholders' Equity Accounts payable (merchandise creditors) Dividends payable Common stock, $1 par Paid-in capital: Excess of issue price over par- common stock Retained earnings u un u...