80.2K

Verified Solution

Link Copied!

== Sh10Bysvil... - 11 -A BIU -_- .4. T. S ** E ng.%. - Miller Nobles_6e-12e Using Excel Ch14-Ch16 Start nes Island Clothing Company began operations on July 1, 2018 usted 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 Taventory 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 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 $ 169,500 $ 169,500 5,000 Transaction data for 2018 Cash paid for purchase of office equipment 6,000 Cash paid for purchase of truck 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 shaded areas on the ENTER-ANSWERS tab for inputs cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will for any cash outflows or amounts to be subtracted. ats: lete the worksheet for the Tames Island Clothing Coman. falling in the Transaction Analysis.com ructions ENTERANSWERSI ENTERANSWERS 39 Use the blue sheded areas on the ENTER-ANSWERS tab for inputs 40 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 41 parentheses for any cash outflows or amounts to be subtracted 43 Requirements: Possible Points 44 1 Complete the worksheet for the James Island Clothing Company, filling in the Transaction Analysis columns 45 Note: Some of the input cells marked in blue may not require entries. 2 Prepare the James 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 47 50 Excel Skills: Use cell references in formulas. 2 Format cells with comna format, dollar format, and underlines as appropriate 55 Saving & Submitting Solution 1 Save file to desktop a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS b. Save your solution in the folder you just created add solution-date to end of file name 2 Upload and submit your file to be graded a. Navigate back to the activity Window screen where you downloaded the initial spreadsheet b. Click Choose button under step 3: locate the file you just saved and click Open c. Click Upload button under step 3 d. Click Submit button under step 4 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link this will bring up your Score Card 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback * InstructionsENTERANSWERST ENTERANSWERS ,ENTER g 8 Balance 7/1/18 Transaction Analysis Debit Credit Balance 12/31/18 9 Panel A - Balance Sheet 10 11 Cash 12 Accounts Receivable 13 Inventory 14 Office Equipment 15 Truck 16 Accumulated Depreciation Plant Assets 17 Total Assets 0 18 19 Accounts Payable 20 Note Payable -Short Term 21 Note Payable - Long Term 22 Total Liabilities 0 Es Common Stock 0 / 24 Common Stock 25 Retained Earnings 26 Total Liabilities and Stockholders' Equity 7 8 Panel B - Statement of Cash Flows 9 Cash Flows from Operating Activities: 0 Net Income 1 Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities 2 Depreciation Expense - Plant Assets 3 Increase in Accounts Receivable 4 Increase in Inventory 5 Increase in Accounts Payable 6 Increase in Notes Payable - Short-term 7 Net Cash Provided by Operating Activities Cash Flows from Investing Activities: Cash Paid for Acquisition of Plant Assets Net Cash Used for Investing Activities I Cash Flows from Financing Activities: e Cash Receipt from Issuance of Common Stock Cash Payment of Dividends Net Cash Provided by Financing Activities Net Increase (Decrease) in Cash: Total * Instructions ENTERANSWERS! ENTERANSWERS H ER ENTER / ZHANG Miller-Nobles 6e-12e-Using Excel Ch14-Ch16 Start Note: Some of the input cells marked in blue may not require entri 15 17 34 35 36 HINTS 37 ENTERANSWERSI worksheet order of Panel B - 38 Statement of Cash Flows in ENTERANSVERSI worksheet. 39 3. Use a minus sign in front of the formula to enter appropriate amounts as negative values. 104. Use appropriate cells in ENTERANSWERS worksheet to calculate totals and subtotals. 41 5. Refer to the appropriate cell in Spreadsheet for Statement of Cash Flows in ENTERANSWERSI worksheet for the cash balance on July 1, 20 == Sh10Bysvil... - 11 -A BIU -_- .4. T. S ** E ng.%. - Miller Nobles_6e-12e Using Excel Ch14-Ch16 Start nes Island Clothing Company began operations on July 1, 2018 usted 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 Taventory 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 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 $ 169,500 $ 169,500 5,000 Transaction data for 2018 Cash paid for purchase of office equipment 6,000 Cash paid for purchase of truck 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 shaded areas on the ENTER-ANSWERS tab for inputs cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will for any cash outflows or amounts to be subtracted. ats: lete the worksheet for the Tames Island Clothing Coman. falling in the Transaction Analysis.com ructions ENTERANSWERSI ENTERANSWERS 39 Use the blue sheded areas on the ENTER-ANSWERS tab for inputs 40 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 41 parentheses for any cash outflows or amounts to be subtracted 43 Requirements: Possible Points 44 1 Complete the worksheet for the James Island Clothing Company, filling in the Transaction Analysis columns 45 Note: Some of the input cells marked in blue may not require entries. 2 Prepare the James 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 47 50 Excel Skills: Use cell references in formulas. 2 Format cells with comna format, dollar format, and underlines as appropriate 55 Saving & Submitting Solution 1 Save file to desktop a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS b. Save your solution in the folder you just created add solution-date to end of file name 2 Upload and submit your file to be graded a. Navigate back to the activity Window screen where you downloaded the initial spreadsheet b. Click Choose button under step 3: locate the file you just saved and click Open c. Click Upload button under step 3 d. Click Submit button under step 4 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link this will bring up your Score Card 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback * InstructionsENTERANSWERST ENTERANSWERS ,ENTER g 8 Balance 7/1/18 Transaction Analysis Debit Credit Balance 12/31/18 9 Panel A - Balance Sheet 10 11 Cash 12 Accounts Receivable 13 Inventory 14 Office Equipment 15 Truck 16 Accumulated Depreciation Plant Assets 17 Total Assets 0 18 19 Accounts Payable 20 Note Payable -Short Term 21 Note Payable - Long Term 22 Total Liabilities 0 Es Common Stock 0 / 24 Common Stock 25 Retained Earnings 26 Total Liabilities and Stockholders' Equity 7 8 Panel B - Statement of Cash Flows 9 Cash Flows from Operating Activities: 0 Net Income 1 Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities 2 Depreciation Expense - Plant Assets 3 Increase in Accounts Receivable 4 Increase in Inventory 5 Increase in Accounts Payable 6 Increase in Notes Payable - Short-term 7 Net Cash Provided by Operating Activities Cash Flows from Investing Activities: Cash Paid for Acquisition of Plant Assets Net Cash Used for Investing Activities I Cash Flows from Financing Activities: e Cash Receipt from Issuance of Common Stock Cash Payment of Dividends Net Cash Provided by Financing Activities Net Increase (Decrease) in Cash: Total * Instructions ENTERANSWERS! ENTERANSWERS H ER ENTER / ZHANG Miller-Nobles 6e-12e-Using Excel Ch14-Ch16 Start Note: Some of the input cells marked in blue may not require entri 15 17 34 35 36 HINTS 37 ENTERANSWERSI worksheet order of Panel B - 38 Statement of Cash Flows in ENTERANSVERSI worksheet. 39 3. Use a minus sign in front of the formula to enter appropriate amounts as negative values. 104. Use appropriate cells in ENTERANSWERS worksheet to calculate totals and subtotals. 41 5. Refer to the appropriate cell in Spreadsheet for Statement of Cash Flows in ENTERANSWERSI worksheet for the cash balance on July 1, 20

Answer & Explanation Solved by verified expert

See Answer