can somone explain to me how to fill in the blue parts plz thx:)

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.

The adjusted trial balance as of December 31, 2018, appears below, along with transaction data for

	JAMES ISLAND CLOTHING COMPANY
	Adjusted Trial Balance
	12/31/18
	Account Title	Balance
		Debit	Credit
	Cash	$ 95,700
	Accounts Receivable	12,000
	Inventory	4,400
	Office Equipment	26,000
	Truck	18,000
	Accumulated DepreciationPlant Assets		$ 6,000
	Accounts Payable		5,500
	Note PayableShort Term		10,000
	Note PayableLong Term		33,000
	Common Stock		100,000
	Retained Earnings
	Dividends	1,000
	Sales Revenue		15,000
	Cost of Goods Sold	3,600
	Rent Expense	2,000
	Advertising Expense	800
	Depreciation Expense	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

A B C The lames Island Cothing 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 Balance Debit Credit $ 95,700 12.000 4,400 26,000 18,000 $ 6,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 5,500 10,000 33,000 100.000 1.000 15,000 3,600 2,000 800 6,000 169,500 5 169,500 recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? B C D $ $ Accumulated Deprecation-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 1,000 3,600 2,000 800 6,000 169,500 $ $ Transaction data for 2018 $ 6,000 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 Cash receipt from issuance of common stock Slue shaded areas on the ENTER-ANSWERS tab for inputs. 5,000 33,000 1,000 100,000 Complete the worksheet for themes Island Clothing Company, the transactionary.com Caused references and forms where appropriate to receive full credit. If you copy/paste from the instruktkantah you wobe marked wrong Note: Some of the hour ces marked in the may not require entries. Leave the input ces blank that do not require an entry THE NAMES ISLAND CLOTHING COMPANY Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Panel A-Balance Sheet Balance 7/1/18 Transaction Art Debat Credit Balance 12/31/18 $ 0 0 0 Cash 2 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 abilities 0 0 0 Common Stock Retained Earnings Total Liabilities and Stockholders' Equity 0 0 $ 0 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 inventory 5 Increase in Accounts Payable Increase in Notes Payable-Short-term NetCash Provided by Operating Activities E: Accumulated Depreciation Plant Assets Total Assets 0 0 Accounts Payable Note Payable Short Term Note Payable - Long Term Total Labies Dlololo 1 Common Stock Retained Earnings Total abilities and Stockholders' Equity ololol $ Panel - 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 Cash Flows from Investing Activities: Cash Paid for Acquisition of Plant Assets Net Cash Used for Investing Activities Cash Flows from Financing Activities: Cash Receipt from Issuance of Common Stock Cash Payment of Dividends Net Cash Provided by Financing Activities Net Increase Decrease in Cash: Total b Prepare the limes Island Cothing Company statement of ash flows for the year manthe ended December 31, 2018. Use the best method. Format cash flows from operate activities by the Indirect method. Leave cells banknoted Always use cell references and formules where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong) Note: Some of the Input celsmerked in blue may notre entre THE LAMES ISLAND CLOTHING COMPANY Statement of Cash Flows Year Ended December 31, 2018 3 10 Cash Flows from Operating Activities 11 Net Income 12 Adustments to Reconcile Net Income to Net Cash Provided by Operating Activities 13 Depreciation Expense: Plant Assets 14 Increase in Accounts Receivable 15 Increase in Inventory 16 Increase in Accounts Payable 17 Increase in Notes Payable-Short-term 28 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, July 1, 2018 28 Cash Balance, December 31, 2018 29 30 Non-cash investing and Financing Activities: 31 Acquisition of Plant Assets with Long-Term Notes Payable 32 Total Non-cash investing and Financing Activities 33 34 G THE JAMES ISLAND CLOTHING COMPANY Spreadsheet for Statement of Cash Flows Year Ended December 21, 2018 . Balance 7/1/18 Transaction Analysis Credit Balance 12/31/18 Debit $ 0 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 0 0 0 $ 0 18 0 0 0 19 Accounts Payable 20 Note Payable-Short Term 21 Note Payable - Long Term 22 Total Ulabilities 23 24 Common Stock 25 Retained Eamings 26 Total Liabilities and Stockholders' Equity 0 0 g 0 $ 27 28 Panel B - Statement of Cash Flows 29 Cash Flows from Operating Activities: 30 Net Income 31 Adjustments to Reconcile et 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 inwesting 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 47 B D 1 Prepare the James Island Clothing Company statement of cash flows for the year months ended December 31, 2018. Use the indirect method. 2 Format cash flows from operating activities by the indirect method. Leave cells blank if not used. 3 Always use cell references and formulas where appropriate to recelve 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. 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 + 24 25 26 27 28 29 30 31 32 33