requierment 1 & 2 (using hints)

L43 B The James Idard 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 D H JAMES ISLAND CLOTHING COMPANY Adjusted Trial Balance 12/31/18 12.000 7 8 1 Account Title Balance Debit Credit Cash $ 95,700 Accounts Receivable Inventory 4,400 Office Equipment 26,000 Truck 18,000 Accumulated Depreciation-Plant Assets $ 6,000 9 Accounts Payable 5,500 Note Payable-Short Term 10,000 Note Payable-Long Term 33,000 2 Common Stock 100,000 Retained Earnings 4 Dividends 1,000 5 Sales Revenue 15,000 6 Cost of Goods Sold 3.600 Rent Expense 2,000 28 Advertising Expense 800 Depreciation Expense 6,000 30 $ 169,500 5 169,500 31 32 Transaction data for 2018 Cash paid for purchase of office equipment $ 6.000 35 Cash paid for purchase of truck 5.000 36 Acquisition of plant assets with a long-term notes payable 33,000 Cash payment of dividends 38 Cash receipt from Issuance of common stock 100,000 39 Use the Blue shaded areas on the INTER ANSWERS tab for inputs 40 ALWAYS we cell references and formulas where appropriate to receive full credit. If you copy/paste from the instruction als you will be marked wrong. Urea minus silp or parentheses for 41 any cash outflows or amounts to be subtracted 42 43 Requirements Possible Points Complete the worksheet for the lames Island Clothing Company, filing in the Transaction Analysis columns 62 Note: Some of the input cells marked in blue may not require entries 46 2 Prepare the lames and Clothing Company statement of cash flows for the year ended December 31, 2018 Use the indirect method 44 Note Some of the input cells marked in blue may not require entries 48 49 1,000 E H A B D Complete the worlesheet for the lames Island Clothing Company, Aling in the transaction analysis columns (Always use cel references and formulas where appropriate to receive full cred. If you copy/paste from the instruction tab you will be marked wrong) Note: Some of the input cells marked in blue may not require entries. Leave the input cells blank that do not require an entry Spreadsheet for Statement of Cash Flows Panel A-Balance Sheet Balance 7/1/18 Transaction Analysis Debit Credik Balance 12/31/18 $ 0 0 Cash Accounts Receivable Inventory Office Equipment Truck Accumulated Depreciation Plant Assets Total Assets 0 0 0 0 $ Accounts Payable Note Payable-Short Term Note Payable - Long Term Total Liabilities 0 0 0 0 Common Stock Retained Earrings Total Liabilities and Stockholders' Equity 0 0 0 S Panel B-Statement of Cash Flows Cash Flows from Operating Activities Net Income Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities Depreciation Expense Plant Assets Increase in Accounts Receivable Increase in Inventory Increase in Accounts Payable Increase in Notes Payable-Short-term Net Cash Provided by Operating Activities 8 Cash Flows from Investing Activities Cash Paid for Acquisition of Plant Assets Net Cash Used for investing Activities Cash Flows from Financing Activities: Cash Recept from Issuance of Common Stock Cash Payment of Dividends Net Cash Provided by Financing Activities Net Increase (Decrease in Cash: Total Instructions ENTERANSWERS1 INTERANSWERS 50 HINTS 51 C1:26 Use cell references to appropriate values on Instructions and ENTERASWERS1 worksheets for calculations 52 E16 Note that accumulated depreciation of plant assets should be a negative value for total assets calculation 53 7.017, 22:022 Do not calculate total assets and liabilities for debit and credit columns. Leave these cells blank. 54 26-026 | Use the function SUMD to calculate total debit and credit transactions 30.043 Use an equal sign (e) and the appropriate cells from the spreadsheet for statement of cash flows. Place cash outflows in column and 55 cash inflows in column D. 56 62 Depreciation Expense should be entered as a positive value in this cell 57039 | Use cel references to the Transaction Data table in Instructions worksheet to calculate cash paid for acquisition of plant assets. CAS.DASI Calculate the net change in cash using values in Panel Bf there is a decrease in cash, enter it as a negative value in column C there is an increase in cash, 58 enter it as a positive value in column 59 60 61 62 63 64 GS 66 67 68 69 70 71 72 73 Instructions ENTERANNWERS1 ENTERANSWERS Normal View Ready Circular Sumo A6 Formatting bolsvalg... A B Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instruction tab you wil be marked wrong) Note: Some of the input cells marked in blue may not require entries. G H 1 2 3 14 5 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 HINTS 37 1. For cel references, use an equalsign () and the appropriate cells from the Panel - Statement of Cash Flows in ENTERANSWERS1 worksheet 2. In Cashflows from Operating Activities through Cash Flows from Financing Activities sections, enter the amounts in the order of Panel Statement of Cash Flows in ENTERANSWERS worksheet 39 3. Use a miun in front of the formula to enter appropriate amounts as negative values 40 4. Use appropriate cells in INTERANSWERS worksheet to calculate totals and total 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 43 A Instructions INTERANSWERS ENTERANSWERS Ccular