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 appear s below, along with transaction data for 2018 AMES ISLAND CLOTHING COMPANY Adjusted Trial Balance 12/31/18 Account Title Balance Debit Credit $95,700 12,000 4,400 26,000 18,000 Cash Accounts Receivable nventory 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 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 Cash paid for purchase of truck Acquisition of plant assets with a longterm notes payable Cash payment of dividends Cash receipt from issuance of common stock 6,000 5,000 33,000 1,000 100,000
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 if not used.