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 $ 100,200 Expenses Cost of goods sold 43,000 Depreciation expense 12,500 Salaries expense 19,000 Rent expense 9,100 Insurance expense 3,900 Interest expense 3,700 Utilities expense 2,900 Net income $ 6,100 LANSING COMPANY Selected Balance Sheet Accounts At December 31 2017 2016 Accounts receivable $ 5,700 $ 6,000 Inventory 2,080 1,590 Accounts payable 4,500 4,800 Salaries payable 900 710 Utilities payable 240 170 Prepaid insurance 270 300 Prepaid rent 240 190
Required: Prepare the cash flows from operating activities section only of the company’s 2017 statement of cash flows using the direct method. (Amounts to be deducted should be indicated with a minus sign.)
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.)
Solution: | ||||
Income statement of Lansing Company for the Year December 31, 2017 : | ||||
Sales Revenue (A) | $ | 100200 | ||
Less: Expenses: | ||||
Cost of Goods sold | $ | 43000 | ||
Depreciation Expense | $ | 12500 | ||
Salaries | $ | 19000 | ||
Rent expense | $ | 9100 | ||
Insurance expense | $ | 3900 | ||
Interest expense | $ | 3700 | ||
Utilities expense | $ | 2900 | ||
Total Expenses (B) | $ | 94100 | ||
Net Income | $ | 6100 | ||
Balance sheet of Lansing Company : | ||||
2017 | 2016 | |||
Account Receivable | 5700 | 6000 | ||
Inventory | 2080 | 1590 | ||
Accounts Payable | 4500 | 4800 | ||
Salaries Payable | 900 | 710 | ||
Utilities Payable | 240 | 170 | ||
Prepaid insurance | 270 | 300 | ||
Prepaid Rent | 240 | 190 | ||
Lansing Company | ||||
Cash Flows from Operating Activities- Indirect Method For the Year ended December 31, 2017 | ||||
Cash Flow From Operating Activities: | Working: | |||
Net Income | $ | 6100 | ||
Adjustment to reconcile net income to net Cash provided by operations: | ||||
Depreciation Expense | $ | 12500 | ||
Decrease In Accounts Receivable | $ | 300 | (6000-5700) | |
Increase In Inventory | $ | -490 | (1590-2080) | |
Decrease In Accounts Payable | $ | -300 | (4800-4500) | |
Increase In Salary Payable | $ | 190 | (710-900) | |
Increase In Utilities Payable | $ | 70 | (170-240) | |
Decrease In Prepaid insurance | $ | 30 | (300-270) | |
Increase In Prepaid Rent | $ | -50 | 12250 | (190-240) |
Net Cash provided by Operating Activities | $ | 18350 | ||
Net Cash provided by Operating Activities = $18350 | ||||