Colorful Cat Company uses the direct method to prepare its statement of cash flows

Question

Refer to the following financial statement information for the year ending December 31, 2017:

Colorful Cat Company
Comparative Balance Sheet
December 31, 2017 and 2016
2017 2016 Increase (Decrease)
Cash $33,000 $13,000 $20,000
Accounts Receivable 29,000 36,000 (7,000 )
Merchandise Inventory 56,000 29,000 27,000
Plant and Equipment, net 126,000 92,000 34,000
Total Assets $244,000 $170,000 $74,000

Accounts Payable $9,000 $13,000 $(4,000 )
Accrued Liabilities 7,000 3,000 4,000
Long-term Notes Payable 70,000 79,000 (9,000 )
Total Liabilities $86,000 $95,000 $(9,000 )

Common Stock $55,000 $3,000 $52,000
Retained Earnings 115,000 78,000 37,000
Treasury Stock (12,000 ) (6,000 ) (6,000 )
Total Stockholders' Equity $158,000 $75,000 $83,000

Total Liabilities and Stockholders' Equity $244,000 $170,000 $74,000

Colorful Cat Company
Income Statement
Year Ended December 31, 2017
Sales Revenue $291,300
Interest Revenue 1,000
Gain on Sale of Plant Assets 6,000
Total Revenues and Gains $298,300
Cost of Goods Sold 145,000
Salaries and Wages Expense 49,000
Depreciation Expense-Plant Assets 16,000
Other Operating Expense 25,000
Interest Expense 3,500
Income Tax Expense 7,800
Total Expenses 246,300
Net Income $52,000

â€Æ'
Colorful Cat Company
Statement of Retained Earnings
Year Ended December 31, 2017
Retained Earnings, January 1, 2017 $78,000
Add: Net income 52,000
Less: Dividends 15,000
Retained Earnings, December 31, 2017 $115,000

Prepare the operating activities section of the statement of cash flows, using the direct method.

What will be an ideal response

Answer 1

Accounts Receivable beginning balance $36,000
Add: Sales Revenue 291,300
Less: Accounts Receivable ending balance (29,000 )
Collections from Customers 298,300

Merchandise Inventory, ending balance 56,000
Add: Cost of Goods Sold 145,000
Less: Merchandise Inventory, beginning balance (29,000 )
Purchases 172,000
Add: Accounts Payable, beginning balance 13,000
Less: Accounts Payable, ending balance (9,000 )
Cash Paid for Merchandise Inventory $176,000

Accrued Liabilities, beginning balance 3,000
Add: Other Operating Expenses 25,000
Less: Accrued Liabilities, ending balance (7,000 )
Cash Paid for Other Operating Expenses $21,000

Total Cash Payments $197,000
â€Æ'
Colorful Cat Company
Statement of Cash Flows (Partial)
Year Ended December 31, 2017
Cash Flows from Operating Activities:
Receipts
Collections from Customers $298,300
Interest Received 1,000
Total Cash Receipts $299,300
Payments
To Suppliers (197,000 )
To Employees (49,000 )
For Interest (3,500 )
For Income tax (7,800 )
Total Cash Payments (257,300 )
Net Cash Provided by Operating Activities $42,000