requierment 2 C D E H The James Idand clothing Company began operations only 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 Dividends Sales Revenue Cost of Goods Sold Rent Expense Advertising Expense Depreciation Expense Balance Debit Crede 95,700 12 000 4 400 25,000 18,000 $ 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 suance of common stock 100 000 Use the Nue shaded areas on the ENTER ANSWERS tab for inputs ALWAYS use cell references and formulas where appropriate to receive full credit If you copy paste from the retruction tab you will be marked wrong We a minus in or parentheses for any cash outflows or amounts to be subtracted Requirements Possible Points 1 Complete the worlatet for the James Island Clothing Company, filling in the Transaction Analysis columns Noter Some of the input cells marked in blue may not require entre 2 Prepare the lames Island 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 Conditional Formatting Qurrency G H C13 X fx ENTERANSWERS 11C32 Prepare the lames Island Clothing Company statement of cash flows for the year months ended December 31, 2018 Use the indirect method Format cash flows from operating activities by the Indirect method Leave cells blank if not used Always use cel references and formulas where appropriate to receive full credit 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 THE LAMES ISLAND CLOTHING COMPANY Statement of Cash Flows Year Ended December 31, 2018 2,600 $ 6,000 5,500 10,000 Cash Flows from Operating Activities Net Income Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities 3 Depredation Expense Plant Assets Increase in Accounts Receivable 5 Increase in Inwentory 6 Increase in Accounts Payable 7 Increase in Notes Payable Short term 8 Net Cash Provided by Operating Activities 19 Cash Flows from investing Activities 20 Cash Paid for Acquisition of Plant Assets 21 Net Cash Used for investing Activities 22 Cash Flows from Financing Activities 23 Cash Receipt from Issuance of Common Stock 24 Cash Payment of Dividends 25 Net Cash Provided by Financing Activities 26 Net Increase (Decrease in Cash 27 Cash Balance, December 31, 2018 5,100 29 30 31 NonCash Investing and Financing Activities 32 Total Non cash resting and Financing Activities 33 36 HINTS 37 1 for cell references, use an equals() and the appropriate cells from the Panel Statement of Cash Flows in ENTERANSWERSI worksheet 2 In Caflows 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 mission in front of the formula to enter appropriate amounts as negative values 40 4 Use appropriate cells in INTERANSWERSZ worksheet to calculate totals and subtotal 41 5 Refer to the appropriate call in Sprendihet for Matement of Cash Flows in ENTERANSWERS worksheet for the cash balance on July 1, 2018 DGD EWO 344 Marge Conditional 0655 GIME Formatting fx Complete the worksheet for the James Island Clothing Company, filling in the Transaction Analysis columns H K B M LAMES ISLAND CLOTHING COMPANY Musted Trial Balance 12 31 18 Account Tide $ Cash Accounts Receivable Inventory Office Equipment Truck Accumulated Depreciation Plant Assets Accounts Payable Note Payable Short Term Note Payable Long Term Common Stock Retained faming Dividends Sales Revenue cost of Goods Sold Rent Expense Advertising Expense Depreciation Expense Balance Debit Credit 95,700 12,000 4,400 26 000 18,000 $ 6,000 5,500 10 000 33 000 100,000 1,000 15 000 3,600 2,000 800 6,000 199,500$ $ 169,500 Transaction data for 2018 Cash paid for purchase of office equipment $ 5,000 Cath paid for purchase of trutk 5,000 Acquisition of plant assets with a long term ots payable 23,000 Cash payment of dividends 1 000 Cath recept from issuance of common stock 100,000 Use the shaded areas on the ENTER ANSWERS tab for inputs ALWAYS cell references and formulas where appropriate to receive full creat, you coaste from the instruction to you will be marked wrong, Uteminus signor Parentheses for any cash outflows or amounts to be tracted Possible Pets Requirements implete the worksheet for the lames Island Cloning Company, fling in the Traction Analysis column Nere some of the rout cells marked in the may not require rires Prepare the names sland Clothing Company statement of cash flows for the year ended December 31, 2018 Die the direct method Note me the collared in blue may not require antres 1 Uiece references in formular tamamlade Instructions INTRANSMIAST ENTIRANIWERS Circular BE cncibina D655 GM H BES Cles B Pasta Merge ) Conditional Formatting D46 ef 145 D 1 Complete the worlesheet for the lames and Clothing Company, filling in the transaction analysis columns 2 (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) 3 Note Some of the input cells marked in blue may not require entries Leave the input cells blank that do not require an entry 4 5 THE NAMES ISLAND CLOTHING COMPANY 6 Spreadsheet for Statement of Cash Flows 7 Year Ended December 31, 2018 8 Balance Balance 9 Panel A Balance Sheet 7 1 18 Transaction Analysis 12 11 18 10 Debit Credit 11 Carch $ 0 $ 95,700 00 $ 95,700 00 12 Accounts Receivable OS 12 000 00 $ 12,000 00 13 Inventory 0 $ 4,400 00 $ 4,400 00 14 Office Equipment 0 $ 25,000 00 $ 26,000 00 15 Truck ols 18,000 00 $ 18,000 00 16 Accumulated Depreciation Plant Assets O $ 6,000 00 $ 6,000 00 17 Total Assets 0 $ 150,100 00 18 19 Accounts Payable 0 $ 5,500 00 5,500 00 20 Note Payable Short Term 0 $ 10,000 00 10,000 00 21 Note Payable Long Term 0 $ 33,000 00 5 33,000 00 22 Total Liabilities 0 $ 48,500 00 23 24 Common Stock 0 $ 100,000 00 $ 100,000 00 25 Retained Earnings OS 1,000 00 $ 2,600 00 $ 1 500 00 26 Total Liabilities and Stockholders' Equity 0 $ 157,100 00 $ 139,900 00 27 28 Panel B Statement of Cash Flows 29 Cash Flows from Operating Activities 30 Net Income $ 2,600 00 31 Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities 32 Depreciation Expense Plant Assets 5 6,000 00 33 Increase in Accounts Receivable $ 12,000 00 34 Increase in inventory 5 4,400 00 35 Increase in Accounts Payable ES 5 500 00 36 Increase in Notes Payable Short term S 10,000 00 37 Net Cash Provided by Operating Activities $ 5,100 00 38 Cash Flows from Investing Activities 39 Cash Paid for Acquisition of Plant Assets 5 1,000 00 40 Net Cash Used for investing Activities S 41 Cash Flows from Financing Activities 42 Cash Recepttrominance of Common Stock $100,000 00 43 Cash Payment of Dividends 15 1 000 00 44 Net Cash Provided by Financing Activities 9,000 00 45 Net Increase (Decrease in Cash 3 104 100 00 531041000 Instructions INTERANSWAASI ENTERANSWERS Total 3104,100 00 HINTS C11 26 Use cell references to appropriate values on Instructions and ENTERASWER51 worksheets for calculations E16 Note that accumulated depreciation of plant assets should be a negative value for total assets calculation C17 017, 22 022 Do not calculate total assets and liabilities for debit and credit columns Leave these cells blank Q26 026 Use the function SUM() to calculate total debit and credit transactions C30 043 Use an equal sign ( ) and the appropriate cells from the spreadsheet for statement of cash flows Place cash outflows in column Cand cash inflows in column D 6 C32 Depreciation Expense should be entered as a positive value in this cell 52 039 Use cell references to the Transaction Data table in Instructions worksheet to calculate cash paid for acquisition of plant assets CAS D45 Calculate the net change in cash using values in Panel B If there is a decrease in cash, enter it as a negative value in column C If there is an increase in cash, 58 enter it as a positive value in columnD 59 50 61 62 63 64 65 66 67 68 69 70 71 22 73 74 76 77 79 BO ENTERANSWERS INTERANSWERS H 1 C13 X ENTERANSWERS11C32 C Prepare the James Island Clothing Company statement of cash flows for the year months ended December 31, 2018 Use the Indirect method Format cash flows from operating activities by the Indirect method Leave cells blank Y not used (Always use cel references and formulas where appropriate to receive full credit 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 N 5 THE LAMES ISLAND CLOTHING COMPANY Statement of Cash Flows Year Ended December 31, 2018 2 600 S 6,000 S 500 10,000 5,100 0 Cash Flows from Operating Activities 1 Net Income 2 Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities 3 Depreciation Expense Plant Assets 4 Increase in Accounts Receivable 5 Increase in Inventory 6 Increase in Accounts Payable 7 Increase in Notes Payable Short term 8 Net Cash Provided by Operating Activities 9 Cash Flows from investing Activities O Cash Paid for Acquisition of Plant Assets 1 Net Cash Used for investing Activities 2 Cash Flows from Financing Activities 3 Cash Receipt from Issuance of Common Stock 4 Cash Payment of Dividends 5 Net Cash Provided by Financing Activities 6 Net Increase (Decrease in Cash 7 Cash Balance, December 31, 2018 9 1 Non cash Investing and Financing Activities 2 Total Non cash investing and Financing Activities 3 4 5 6 HINTS 27 1 For cell references, use an equals() and the appropriate cells from the Panel Statement of Cash Flows in INTERANSWERSI worksheet 2 in Cash Flows from Operating Activities through Cash Flows from Financing Activities sections, enter the amounts in the order of Panel Statement of Cash Flows in ENTERANSWERS1 worksheet 19 3 Use a minus sign in front of the formula to enter appropriate amounts as negative values 10 4 Use appropriate cells in INTERANSWERS2 worksheet to calculate totals and subtotals 11 5 Refer to the appropriate cell in Spreadsheet for Statement of Cath flows in ENTERANSWERSI worksheet for the cash balance on July 1, 2018 2 5 Instructions ENTERANSWERS ENTERANSWERS

Question

requierment 2 C D E H The James Idand clothing Company began operations only 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 Dividends Sales Revenue Cost of Goods Sold Rent Expense Advertising Expense Depreciation Expense Balance Debit Crede 95,700 12 000 4 400 25,000 18,000 $ 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 suance of common stock 100 000 Use the Nue shaded areas on the ENTER ANSWERS tab for inputs  ALWAYS use cell references and formulas where appropriate to receive full credit  If you copy paste from the retruction tab you will be marked wrong  We a minus in or parentheses for any cash outflows or amounts to be subtracted  Requirements Possible Points 1 Complete the worlatet for the James Island Clothing Company, filling in the Transaction Analysis columns Noter Some of the input cells marked in blue may not require entre 2 Prepare the lames Island 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 Conditional Formatting Qurrency G H C13 X fx  ENTERANSWERS 11C32 Prepare the lames Island Clothing Company statement of cash flows for the year months ended December 31, 2018  Use the indirect method  Format cash flows from operating activities by the Indirect method  Leave cells blank if not used  Always use cel references and formulas where appropriate to receive full credit  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  THE LAMES ISLAND CLOTHING COMPANY Statement of Cash Flows Year Ended December 31, 2018 2,600 $ 6,000 5,500 10,000 Cash Flows from Operating Activities  Net Income Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities 3 Depredation Expense   Plant Assets Increase in Accounts Receivable 5 Increase in Inwentory 6 Increase in Accounts Payable 7 Increase in Notes Payable Short term 8 Net Cash Provided by Operating Activities 19 Cash Flows from investing Activities  20 Cash Paid for Acquisition of Plant Assets 21 Net Cash Used for investing Activities 22 Cash Flows from Financing Activities  23 Cash Receipt from Issuance of Common Stock 24 Cash Payment of Dividends 25 Net Cash Provided by Financing Activities 26 Net Increase (Decrease in Cash  27 Cash Balance, December 31, 2018 5,100 29 30 31 NonCash Investing and Financing Activities 32 Total Non cash resting and Financing Activities 33 36 HINTS 37 1  for cell references, use an equals() and the appropriate cells from the Panel   Statement of Cash Flows in ENTERANSWERSI worksheet 2  In Caflows 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 mission in front of the formula to enter appropriate amounts as negative values 40 4 Use appropriate cells in INTERANSWERSZ worksheet to calculate totals and subtotal 41 5  Refer to the appropriate call in Sprendihet for Matement of Cash Flows in ENTERANSWERS worksheet for the cash balance on July 1, 2018 DGD    EWO 344   Marge Conditional 0655 GIME Formatting fx Complete the worksheet for the James Island Clothing Company, filling in the Transaction Analysis columns  H K B M LAMES ISLAND CLOTHING COMPANY Musted Trial Balance 12 31 18 Account Tide $ Cash Accounts Receivable Inventory Office Equipment Truck Accumulated Depreciation Plant Assets Accounts Payable Note Payable Short Term Note Payable Long Term Common Stock Retained faming Dividends Sales Revenue cost of Goods Sold Rent Expense Advertising Expense Depreciation Expense Balance Debit Credit 95,700 12,000 4,400 26 000 18,000 $ 6,000 5,500 10 000 33 000 100,000 1,000 15 000 3,600 2,000 800 6,000 199,500$ $ 169,500 Transaction data for 2018 Cash paid for purchase of office equipment $ 5,000 Cath paid for purchase of trutk 5,000 Acquisition of plant assets with a long term ots payable 23,000 Cash payment of dividends 1 000 Cath recept from issuance of common stock 100,000 Use the shaded areas on the ENTER ANSWERS tab for inputs ALWAYS cell references and formulas where appropriate to receive full creat, you coaste from the instruction to you will be marked wrong, Uteminus signor Parentheses for any cash outflows or amounts to be tracted Possible Pets Requirements implete the worksheet for the lames Island Cloning Company, fling in the Traction Analysis column Nere some of the rout cells marked in the may not require rires Prepare the names sland Clothing Company statement of cash flows for the year ended December 31, 2018 Die the direct method Note me the collared in blue may not require antres 1 Uiece references in formular tamamlade Instructions INTRANSMIAST ENTIRANIWERS Circular BE   cncibina D655 GM H BES Cles B Pasta Merge   ) Conditional Formatting D46 ef  145 D 1 Complete the worlesheet for the lames and Clothing Company, filling in the transaction analysis columns 2  (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) 3 Note  Some of the input cells marked in blue may not require entries  Leave the input cells blank that do not require an entry  4 5 THE NAMES ISLAND CLOTHING COMPANY 6 Spreadsheet for Statement of Cash Flows 7 Year Ended December 31, 2018 8 Balance Balance 9 Panel A Balance Sheet 7 1 18 Transaction Analysis 12 11 18 10 Debit Credit 11 Carch $ 0 $ 95,700 00 $ 95,700 00 12 Accounts Receivable OS 12 000 00 $ 12,000 00 13 Inventory 0 $ 4,400 00 $ 4,400 00 14 Office Equipment 0 $ 25,000 00 $ 26,000 00 15 Truck ols 18,000 00 $ 18,000 00 16 Accumulated Depreciation Plant Assets O  $ 6,000 00 $ 6,000 00 17 Total Assets 0 $ 150,100 00 18 19 Accounts Payable 0 $ 5,500 00 5,500 00 20 Note Payable Short Term 0 $ 10,000 00 10,000 00 21 Note Payable   Long Term 0 $ 33,000 00 5 33,000 00 22 Total Liabilities 0 $ 48,500 00 23 24 Common Stock 0 $ 100,000 00 $ 100,000 00 25 Retained Earnings OS 1,000 00 $ 2,600 00 $ 1 500 00 26 Total Liabilities and Stockholders' Equity 0 $ 157,100 00 $ 139,900 00 27 28 Panel B Statement of Cash Flows 29 Cash Flows from Operating Activities  30 Net Income $ 2,600 00 31 Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities 32 Depreciation Expense  Plant Assets 5 6,000 00 33 Increase in Accounts Receivable $ 12,000 00 34 Increase in inventory 5 4,400 00 35 Increase in Accounts Payable ES 5 500 00 36 Increase in Notes Payable Short term S 10,000 00 37 Net Cash Provided by Operating Activities $ 5,100 00 38 Cash Flows from Investing Activities 39 Cash Paid for Acquisition of Plant Assets 5 1,000 00 40 Net Cash Used for investing Activities S 41 Cash Flows from Financing Activities 42 Cash Recepttrominance of Common Stock $100,000 00 43 Cash Payment of Dividends 15 1 000 00 44 Net Cash Provided by Financing Activities 9,000 00 45 Net Increase (Decrease in Cash 3 104 100 00 531041000 Instructions INTERANSWAASI ENTERANSWERS Total 3104,100 00 HINTS C11 26   Use cell references to appropriate values on Instructions and ENTERASWER51 worksheets for calculations  E16 Note that accumulated depreciation of plant assets should be a negative value for total assets calculation C17 017, 22 022 Do not calculate total assets and liabilities for debit and credit columns  Leave these cells blank Q26 026   Use the function SUM() to calculate total debit and credit transactions C30 043   Use an equal sign ( ) and the appropriate cells from the spreadsheet for statement of cash flows  Place cash outflows in column Cand cash inflows in column D  6 C32 Depreciation Expense should be entered as a positive value in this cell  52 039   Use cell references to the Transaction Data table in Instructions worksheet to calculate cash paid for acquisition of plant assets  CAS D45   Calculate the net change in cash using values in Panel B  If there is a decrease in cash, enter it as a negative value in column C  If there is an increase in cash, 58 enter it as a positive value in columnD  59 50 61 62 63 64 65 66 67 68 69 70 71 22 73 74 76 77 79 BO ENTERANSWERS INTERANSWERS H 1 C13 X ENTERANSWERS11C32 C Prepare the James Island Clothing Company statement of cash flows for the year months ended December 31, 2018  Use the Indirect method  Format cash flows from operating activities by the Indirect method  Leave cells blank Y not used  (Always use cel references and formulas where appropriate to receive full credit  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  N 5 THE LAMES ISLAND CLOTHING COMPANY Statement of Cash Flows Year Ended December 31, 2018 2 600 S 6,000 S 500 10,000 5,100 0 Cash Flows from Operating Activities  1 Net Income 2 Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities 3 Depreciation Expense   Plant Assets 4 Increase in Accounts Receivable 5 Increase in Inventory 6 Increase in Accounts Payable 7 Increase in Notes Payable Short term 8 Net Cash Provided by Operating Activities 9 Cash Flows from investing Activities  O Cash Paid for Acquisition of Plant Assets 1 Net Cash Used for investing Activities 2 Cash Flows from Financing Activities  3 Cash Receipt from Issuance of Common Stock 4 Cash Payment of Dividends 5 Net Cash Provided by Financing Activities 6 Net Increase (Decrease in Cash  7 Cash Balance, December 31, 2018 9 1 Non cash Investing and Financing Activities  2 Total Non cash investing and Financing Activities 3 4 5 6 HINTS 27 1  For cell references, use an equals() and the appropriate cells from the Panel   Statement of Cash Flows in INTERANSWERSI worksheet 2  in Cash Flows from Operating Activities through Cash Flows from Financing Activities sections, enter the amounts in the order of Panel   Statement of Cash Flows in ENTERANSWERS1 worksheet  19 3  Use a minus sign in front of the formula to enter appropriate amounts as negative values 10 4 Use appropriate cells in INTERANSWERS2 worksheet to calculate totals and subtotals  11 5  Refer to the appropriate cell in Spreadsheet for Statement of Cath flows in ENTERANSWERSI worksheet for the cash balance on July 1, 2018 2 5 Instructions ENTERANSWERS ENTERANSWERS

Accepted Answer

The Answer is in the image, click to view ...

Question

requierment 2 C D E H The James Idand clothing Company began operations only 1, 2018 The adjusted trial balance as of December 31, 2018,

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Emile Woolf On Audit Exemption

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question