In: Accounting
Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2016 and 2017, follow.
| LANSING COMPANY Income Statement For Year Ended December 31, 2017  | 
||||||
| Sales revenue | $ | 148,200 | ||||
| Expenses | ||||||
| Cost of goods sold | 59,000 | |||||
| Depreciation expense | 20,500 | |||||
| Salaries expense | 35,000 | |||||
| Rent expense | 10,700 | |||||
| Insurance expense | 5,500 | |||||
| Interest expense | 5,300 | |||||
| Utilities expense | 4,500 | |||||
| Net income | $ | 7,700 | ||||
| LANSING COMPANY Selected Balance Sheet Accounts  | 
||||||
| At December 31 | 2017 | 2016 | ||||
| Accounts receivable | $ | 7,300 | $ | 9,200 | ||
| Inventory | 3,680 | 2,390 | ||||
| Accounts payable | 6,100 | 8,000 | ||||
| Salaries payable | 1,220 | 870 | ||||
| Utilities payable | 560 | 330 | ||||
| Prepaid insurance | 430 | 620 | ||||
| Prepaid rent | 560 | 350 | ||||
Required:
Prepare the cash flows from operating activities section only of the company’s 2017 statement of cash flows using the indirect method. (Amounts to be deducted should be indicated with a minus sign.)
  | 
|||||||||||||||||||||||||||||||||||||||||||||||||
| Operating Activities of the Cash Flow Statement of Lansing Ltd for the year ended Dec 31, 2017 | |
| Particulars | Amount | 
| CASH FLOWS FROM OPERATING ACTIVITIES | |
| Profit before tax | $7,700 | 
| Adjustments to reconcile profit before tax to cash provided by operating activities | |
| Depreciation and amortisation expense | $20,500 | 
| OPERATING PROFIT BEFORE WORKING CAPITAL CHANGES | $28,200 | 
| (Increase) / Decrease in current assets | |
| Accounts Receivables Decrease | $1,900 | 
| Inventories (Increase) | -$1,290 | 
| Prepaid Rent (Increase) | -$210 | 
| Prepaid Insurance Decrease | $190 | 
| Increase / (Decrease) in current liabilities | |
| Accounts Payable (Decrease) | -$1,900 | 
| Salaries Payable Increase | $350 | 
| Utilities Payable Increase | $230 | 
| NET CASH GENERATED /(USED) BY OPERATING ACTIVITIES | $27,470 |