In: Accounting
Problem 23-08
Comparative balance sheet accounts of Coronado Company are presented below.
|
CORONADO COMPANY |
||||
|
Debit Balances |
2020 |
2019 |
||
| Cash |
$69,600 |
$51,100 |
||
| Accounts Receivable |
156,500 |
130,000 |
||
| Inventory |
75,700 |
60,800 |
||
| Debt investments (available-for-sale) |
55,000 |
85,300 |
||
| Equipment |
69,600 |
47,800 |
||
| Buildings |
144,900 |
144,900 |
||
| Land |
39,600 |
25,200 |
||
| Totals |
$610,900 |
$545,100 |
||
|
Credit Balances |
||||
| Allowance for Doubtful Accounts |
$10,000 |
$8,000 |
||
| Accumulated Depreciation—Equipment |
20,800 |
14,100 |
||
| Accumulated Depreciation—Buildings |
37,000 |
27,900 |
||
| Accounts Payable |
66,500 |
59,800 |
||
| Income Taxes Payable |
11,900 |
10,000 |
||
| Long-Term Notes Payable |
62,000 |
70,000 |
||
| Common Stock |
310,000 |
260,000 |
||
| Retained Earnings |
92,700 |
95,300 |
||
| Totals |
$610,900 |
$545,100 |
||
Additional data:
| 1. | Equipment that cost $10,000 and was 60% depreciated was sold in 2020. | |
| 2. | Cash dividends were declared and paid during the year. | |
| 3. | Common stock was issued in exchange for land. | |
| 4. | Investments that cost $34,800 were sold during the year. | |
| 5. | There were no write-offs of uncollectible accounts during the year. |
Coronado’s 2020 income statement is as follows.
| Sales revenue |
$955,000 |
||||
| Less: Cost of goods sold |
601,700 |
||||
| Gross profit |
353,300 |
||||
| Less: Operating expenses (includes depreciation expense and bad debt expense) |
252,500 |
||||
| Income from operations |
100,800 |
||||
| Other revenues and expenses | |||||
| Gain on sale of investments |
$15,000 |
||||
| Loss on sale of equipment |
(2,900 |
) |
12,100 |
||
| Income before taxes |
112,900 |
||||
| Income taxes |
45,300 |
||||
| Net income |
$67,600 |
(a) Compute net cash provided by operating
activities under the direct method. (Enter negative
amounts using either a negative sign preceding the number e.g. -45
or parentheses e.g. (45).)
| Net cash flow from operating activities | $ |
(b) Prepare a statement of cash flows using the
indirect method. (Show amounts that decrease cash flow
with either a - sign e.g. -15,000 or in parenthesis e.g.
(15,000).)
| $ | ||
| $ | ||
| $ | ||
| $ |
Requirement:A
| Net cash flow from operating activities | $ 46,500 |
Requirement:B
| CORONADO COMPANY | ||
| Statement of Cash Flows [Indirect Method] | ||
| For the Year Ended December 31, 2020 | ||
| Cash flows from operating activities: | ||
| Net Income | $ 67,600 | |
| Adjustments to reconcile net income to net cash provided by operating activities | ||
| Income statement items not affecting cash | ||
| Depreciation expense | $ 21,800 | |
| Loss on sale of equipment | $ 2,900 | |
| Gain on sale of investments | $ (15,000) | |
| Changes in current operating assets and liabilities | ||
| Increase in Account Receivables | $ (24,500) | |
| Increase in Inventory | $ (14,900) | |
| Increase in accounts payable | $ 6,700 | |
| Increase in income taxes payable | $ 1,900 | |
| Net cash provided by operating activities[A] | $ 46,500 | |
| Cash flow from investing activities: | ||
| Purchase of Equipment | $ (31,800) | |
| Sale of Equipment | $ 1,100 | |
| Purchase of investments | $ (4,500) | |
| Sale of Investments | $ 49,800 | |
| Net cash used by investing activities[B] | $ 14,600 | |
| Cash flow from financing activities: | ||
| Payment of Notes Payable | $ (8,000) | |
| Issue on Common Stock | $ 35,600 | |
| Payment of Dividend | $ (70,200) | |
| Net Cash used by financing activities (C ) | $ (42,600) | |
| Net increase(decrease) in cash | $ 18,500 | |
| Cash balance at prior year-end | $ 51,100 | |
| Cash balance at current year-end | $ 69,600 | |
Working:
| Investments | |||
| Beg Balance | $ 85,300 | Sale of investments | $ 34,800 |
| Purchase of investments | $ 4,500 | ||
| End Balance | $ 55,000 | ||
| Property, plant, and equipment | |||
| Beg Balance | $ 47,800 | Asset Sold | $ 10,000 |
| Asset Purchased | $ 31,800 | ||
| End Balance | $ 69,600 | ||
| Retained Earnings | |||
| Dividends Paid | $ 70,200 | Beg Balance | $ 95,300 |
| Net Income | $ 67,600 | ||
| End Balance | $ 92,700 | ||
| Accumulated Depreciation | |||
| Depreciation [Of Sold Asset] | $ 6,000 | Beg Balance | $ 42,000 |
| Depreciation Expense | $ 21,800 | ||
| End Balance | $ 57,800 | ||