In: Accounting
P23-8.
(SCF—Direct and Indirect Methods)
(LO 2, 4) Comparative balance sheet accounts of Sharpe Company are presented below.
|
SHARPE COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 |
||
|---|---|---|
|
Debit Balances |
2017 |
2016 |
|
Cash |
$?70,000 |
$?51,000 |
|
Accounts Receivable |
155,000 |
130,000 |
|
Inventory |
75,000 |
61,000 |
|
Debt investments (available-for-sale) |
55,000 |
85,000 |
|
Equipment |
70,000 |
48,000 |
|
Buildings |
145,000 |
145,000 |
|
Land |
??40,000 |
??25,000 |
|
Totals |
$610,000 |
$545,000 |
|
Credit Balances |
||
|
Allowance for Doubtful Accounts |
$?10,000 |
$??8,000 |
|
Accumulated Depreciation—Equipment |
21,000 |
14,000 |
|
Accumulated Depreciation—Buildings |
37,000 |
28,000 |
|
Accounts Payable |
66,000 |
60,000 |
|
Income Taxes Payable |
12,000 |
10,000 |
|
Long-Term Notes Payable |
62,000 |
70,000 |
|
Common Stock |
310,000 |
260,000 |
|
Retained Earnings |
??92,000 |
??95,000 |
|
Totals |
$610,000 |
$545,000 |
Additional data:
1.Equipment that cost $10,000 and was 60% depreciated was sold in 2017.
2.Cash dividends were declared and paid during the year.
3.Common stock was issued in exchange for land.
4.Debt investments that cost $35,000 were sold during the year.
5.There were no write-offs of uncollectible accounts during the year.
Sharpe's 2017 income statement is as follows.
|
Sales revenue |
$950,000 |
|
|
Less: Cost of goods sold |
?600,000 |
|
|
Gross profit |
?350,000 |
|
|
Less: Operating expenses (includes depreciation expense and bad debt expense) |
?250,000 |
|
|
Income from operations |
?100,000 |
|
|
Other revenues and expenses |
||
|
Gain on sale of investments |
$15,000? |
|
|
Loss on sale of equipment |
?(3,000) |
??12,000 |
|
Income before taxes |
?112,000 |
|
|
Income taxes |
??45,000 |
|
|
Net income |
$?67,000 |
Instructions
(a)
Compute net cash provided by operating activities under the direct method.
(b)
Prepare a statement of cash flows using the indirect method.
(a) cash provided by operating activities under the direct method
| Cash Flow Statement Direct Method | ||
| PARTICULARS | Amount | Amount |
| Operating Activities: | ||
| Cash receipt: | ||
| Collection from debtors | $ 950,000.00 | |
| Net Sales | $ 122,000.00 | |
| Add: Beginning accounts receivable net of doubtful debts | ||
| (130000 - 8000) | $ 145,000.00 | |
| Less: Ending accounts receivables net of doubtful debts | $ 927,000.00 | |
| (155000 - 10000) | ||
| Cash Payment: | ||
| Payment to suppliers | $ 600,000.00 | |
| Cost of goods sold | $ 75,000.00 | |
| Add: Closing inventory | $ 61,000.00 | |
| Less: Opening inventory | $ 60,000.00 | |
| Add: Beginning accounts payable | $ 66,000.00 | $ 608,000.00 |
| Less: Closing accounts payables | ||
| Cash paid for operating expenses | ||
| Operating Expenses | $ 250,000.00 | |
| Less: Depreciation - Equipment | $ 13,000.00 | |
| (21000 - 14000) + 60% of 10000 | ||
| less: Depreciation Building | $ 9,000.00 | |
| (37000 -28000) | $ 228,000.00 | |
| Income tax paid | ||
| Income tax expense | $ 45,000.00 | |
| Add: Beginning tax payable | $ 10,000.00 | |
| Less: Closing tax payable | $ 12,000.00 | $ 43,000.00 |
| Cash flows from (Used in) Operating Activities | $ 48,000.00 | |
(b) statement of cash flows using the indirect method
| Sharpe Co. | |
| Statement of Cash Flows | |
| For the Year Ended December 31, 2017 | |
| Cash Flow From Operating Activities: | |
| Net Income | $67,000 |
| Add: Depreciation Expense | 22,000 |
| Subtract: Gain on Sale of Investments | (15,000) |
| Add: Loss on Sale of Equipment | 3,000 |
| Subtract: Increase in Accts Receivable (Net) | (23,000) |
| Subtract: Increase in Inventory | (14,000) |
| Add: Increase in Accounts Payable | 6,000 |
| Add: Increase in Taxes Payables | 2,000 |
| Total Cash From Operating Activities | 48,000 |
| Cash Flow From Investing Activities: | |
| Purchase of Investments | (5,000) |
| Proceeds from Sale of Investments | 50,000 |
| Purchase of Equipment | (32,000) |
| Proceeds from Sale of Equipment | 1,000 |
| Total Cash From Investing Activities | 14,000 |
| Cash Flow From Financing Activities: | |
| Payment on Notes Payable | (8,000) |
| Proceeds from Issued Common Stock | 35,000 |
| Cash Dividends Paid to Stockholders | (70,000) |
| Total Cash From Financing Activities | (43,000) |
| Net Increase in Cash for the Year | 19,000 |
| Beginning of Year Cash Balance | 51,000 |
| End of Year Cash Balance | $70,000 |
| Noncash Investing and Financing Activities: | |
| Issued Common Stock for Land | $15,000 |
| Analysis of Accounts | ||||||
| Investments | ||||||
| Beg Bal | 85,000 | |||||
| 35,000 | Sold | |||||
| Purchased | 5,000 | |||||
| End Bal | 55,000 | |||||
| Equipment | ||||||
| Beg Bal | 48,000 | |||||
| 10,000 | Sold | |||||
| Purchased | 32,000 | |||||
| End Bal | 70,000 | |||||
| Land | ||||||
| Beg Bal | 25,000 | |||||
| Land Exch For Stock | 15,000 | |||||
| End Bal | 40,000 | |||||
| Common Stock | ||||||
| 260,000 | Beg Bal | |||||
| 15,000 | Issued Stock For Land | |||||
| 35,000 | Issued Stock For Cash | |||||
| 310,000 | End Bal | |||||
| Retained Earnings | ||||||
| 95,000 | Beg Bal | |||||
| Dividends | 70,000 | 67,000 | Net Inc | |||
| 92,000 | End Bal | |||||
| Investments | ||||||
| FV | 50,000 | Proceeds from sale of Investments | ||||
| (BV) | (35,000) | |||||
| G/L | 15,000 | |||||
| Equipment | ||||||
| FV | 1,000 | Proceeds from sale of Equipment | ||||
| (BV) | (4,000) | [10,000-6,000] | ||||
| G/L | (3,000) | |||||