In: Accounting
The Murdock Corporation reported the following balance sheet data for 2018 and 2017:
2018 |
2017 |
|
Cash |
$77,375 |
$22,955 |
Available-for-sale debt securities |
||
(not cash equivalents) |
15,500 |
85,000 |
Accounts receivable |
80,000 |
68,250 |
Inventory |
165,000 |
145,000 |
Prepaid insurance |
1,500 |
2,000 |
Land, buildings, and equipment |
1,250,000 |
1,125,000 |
Accumulated depreciation |
(610,000) |
(572,000) |
Total assets |
$979,375 |
$876,205 |
Accounts payable |
$76,340 |
$148,670 |
Salaries payable |
20,000 |
24,500 |
Notes payable (current) |
25,000 |
75,000 |
Bonds payable |
200,000 |
0 |
Common stock |
300,000 |
300,000 |
Retained earnings |
358,035 |
328,035 |
Total liabilities and shareholders' equity |
$979,375 |
$876,205 |
Additional information for 2018:
(1.) Sold available-for-sale debt securities costing $69,500 for
$74,000.
(2.) Equipment costing $20,000 with a book value of $5,000 was sold
for $6,000. (3.) Issued 6% bonds payable at face value,
$200,000.
(4.) Purchased new equipment for $145,000 cash.
(5.) Paid cash dividends of $20,000.
(6.) Net income was $50,000.
Required:
Prepare a cash flow worksheet for 2018 in good form using the indirect method for cash flows from operating activities.
statement of cash flow for the year ended 31 dec2018 |
||
cash flow from operating activity | ||
Net income | 50000 | |
Adjustment to reconcile net income to net cash flow | ||
Depreciation on equipment [610000+ 15000 accumulated dep on equipment sold - 572000beginning accumulated dep] | 53000 | |
gain on sale of equipment [6000-5000] | (1000) | |
Gain on sale of debt securities [74000-69500] | (4500) | |
increase in accounts receivable | (11750) | |
increase in inventory | (20000) | |
decrease in prepaid insurance | 500 | |
decrease in accounts payable | (72330) | |
decrease in salaries payable | (4500) | |
decrease in notes payable | (50000) | (110580) |
net cash flow from operating activity | (60580) | |
cash flow from investing activtiy | ||
sale of equipment | 6000 | |
sale of debt securities | 74000 | |
purchase of new equipment | (145000) | |
net cash flow from investing activity | (65000) | |
cash flow from financing activity | ||
Issue of bond payable | 200000 | |
payment cash dividend | (20000) | |
cash flow from financing activity | 180000 | |
net increase/(decrease) in cash flow | 54420 | |
Beginning cash balance | 22955 | |
Cash at end | 77375 |