please advise how each was solved aswell
FED Calibri (Body) 11 abe Wrap Text General XS4vTWI Pasta Clear B Marge ES Conditional Formatting Good L43 Xfx B D F H The James Idand 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 Credit $ Balance Debit 95,700 12,000 4,400 26,000 18,000 $ 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 Dividends Sales Revenue Cost of Goods Sold Rent Expense Advertising Expense Depreciation Expense 6,000 5,500 10,000 33,000 100,000 + 1,000 15.000 3,600 2,000 800 6,000 169,500 $ $ 169,500 Transaction data for 2018 Cash paid for purchase of office equipment $ 6,000 Cash paid for purchase of truck 5,000 Acquisition of plant assets with a long-term notes payable 33.000 Cash payment of dividends 1,000 Cash receipt from issuance of common stock 100,000 Use the blue shaded areas on the ENTER ANSWERS tob for inputs. ALWAYS use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. Use a minus sign or parentheses for any cash outflows or amounts to be subtracted. 2. A D Prepare the James Island Clothing Company statement of cash flows for the year months ended December 31, 2016. Use the Indirect method. Format cash flows from operating activities by the Indirect method. Lave cells Wank not used (Always use cel references and formulas where appropriate to receive full credit. If you copy/paste from the instruktion tab you will be marked wrong) Note: Some of the input cells marked in blue may not require entries. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 HINTS 37 1. For cell references, use an equal sign () and the appropriate cells from the Panel B - Statement of Cash Flows in ENTERANSWERS1 worksheet. 2. In Cash Flows from Operating Activities through Cash Flows from Financing Activities se ns, enter the amounts in the order of Panel B - 38 Statement of Cash Flows in ENTERANSWERS1 worksheet. 39 3. Use a minus sign in front of the formula to enter appropriate amounts as negative values 40 4. Use appropriate cells in ENTERANSWERS2 worksheet to calculate totals and subtotals. 41 5. Refer to the appropriate cell in Spreadsheet for Statement of Cash Flows in ENTERANSWERS1 worksheet for the cash balance on July 1, 2018 42 43
