Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone please show me how to do this questions with steps? thank you so muchhhh, its aready my third time posting this question so

can someone please show me how to do this questions with steps? thank you so muchhhh, its aready my third time posting this question so i really need a good ans. thanks :)
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
D E F G The Statement of Cash Flows Using Excel to prepare the statement of cash flows, Indirect method 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. 6 7 8 JAMES ISLAND CLOTHING COMPANY Adjusted Trial Balance 12/31/18 9 10 11 Account Titie Balance 12 Debit Credit 13 Cash $ 14 95,700 12,000 4,400 15 26 17 26.000 18,000 18 $ 19 6,000 5,500 20 10,000 21 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 33,000 100,000 22 23 24 1,000 25 15,000 26 3,600 27 2,000 28 29 800 6,000 169,500 $ 30 $ 169.500 31 32 33 Transaction data for 2018 34 $ 6,000 35 Cash paid for purchase of office equipment Cash paid for purchase of truck Acquisition of plant assets with a long-term notes payable 5,000 33,000 36 B D 1,000 Retained Earnings Dividends Sales Revenue Cost of Goods Sold Rent Expense Advertising Expense Depreciation Expense 15,000 3,600 2,000 800 6,000 169,500 $ $ 169,500 $ 6,000 5,000 33,000 Transaction data for 2018 Cash paid for purchase of office equipment Cash paid for purchase of truck Acquisition of plant assets with a long-term notes payable Cash payment of dividends 1,000 Cash receipt from issuance of common stock + Use the blue 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 Instruction tab you will be marked wrong. Use a mi outflows or amounts to be subtracted. 100,000 Requirements: 1 Complete the worksheet for the James Island Clothing Company, filling in the Transaction Analysis columns 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. Note: Some of the input cells marked in blue may not require entries. Excel Skills: 1 Use cell references in formulas. 2 Format cells with comma format, dollar format, and underlines as appropriate. 23 24 Common Stock 25 Retained Eamings 26 Total abilities and Stockholders'Equity 0 0 27 $ 0 28 Panel B - Statement of Cash Flows 29 Cash Flows from Operating Activities: 30 Net Income 31 Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities 32 Depreciation Expense - Plant Assets 33 Increase in Accounts Receivable 34 Increase in Inventory 35 Increase in Accounts Payable 36 Increase in Notes Payable-Short-term 37 Net Cash Provided by Operating Activities 38 Cash Flows from Investing Activities: 39 Cash Paid for Acquisition of Plant Assets 40 Net Cash Used for investing Activities 41 Cash Flows from Financing Activities: 42 Cash Receipt from Issuance of Common Stock 43 Cash Payment of Dividends 44 Net Cash Provided by Financing Activities 45 Net increase (Decrease in Cash: 46 Total 48 49 50 + HINTS 51 C11:26 Use cell references to appropriate values on Instructions and ENTERASWERSi worksheets for calculations. S2 E16 Note that accumulated depreciation of plant assets should be a negative value for total assets calculation 53 07:017, 22:022 Do not calculate total assets and liabilities for debit and credit columns Leave these cells blank, 54 C26:0261 Use the function SUM) to calculate total debit and credit transactions C30:04 Use an equalsign (-) and the appropriate cells from the spreadsheet for statement of cash flows. Place cash outflows in column Cand cash inflows in column D. 56 C32 Deprecation Expense should be entered as a positive value in this cell 57 D39 Use cell references to the Transaction Data table in Instructions worksheet to calculate cash paid for acquisition of plant assets. C45:04S Calculate the net change in cosh 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 column D. 55 59 60 61 62 3 (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) 4 Note: Some of the input cells marked in blue may not require entries 7 8 10 11 12 13 24 16 18 19 20 21 assuuuunanna 23 24 25 26 27 28 29 30 31 32 33 34 35 36 38 Statement of Cash Flows in ENTERANSWERS1 worksheet HINTS 37 1. Forced references, use an equalsign () 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 sections, enter the amounts in the order of Panel - 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 only.1.2018 42 43

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Energy Audits

Authors: Albert Thumann, William J. Younger

6th Edition

0824709985, 978-0824709983

Students also viewed these Accounting questions