In: Accounting
The following financial statements and additional information are reported.
| IKIBAN INC. Comparative Balance Sheets June 30, 2018 and 2017  | 
||||||||
| 2018 | 2017 | |||||||
| Assets | ||||||||
| Cash | $ | 83,900 | $ | 50,000 | ||||
| Accounts receivable, net | 74,000 | 57,000 | ||||||
| Inventory | 69,800 | 95,500 | ||||||
| Prepaid expenses | 5,000 | 6,600 | ||||||
| Total current assets | 232,700 | 209,100 | ||||||
| Equipment | 130,000 | 121,000 | ||||||
| Accum. depreciation—Equipment | (30,000 | ) | (12,000 | ) | ||||
| Total assets | $ | 332,700 | $ | 318,100 | ||||
| Liabilities and Equity | ||||||||
| Accounts payable | $ | 31,000 | $ | 39,000 | ||||
| Wages payable | 6,600 | 16,200 | ||||||
| Income taxes payable | 4,000 | 5,000 | ||||||
| Total current liabilities | 41,600 | 60,200 | ||||||
| Notes payable (long term) | 36,000 | 66,000 | ||||||
| Total liabilities | 77,600 | 126,200 | ||||||
| Equity | ||||||||
| Common stock, $5 par value | 232,000 | 166,000 | ||||||
| Retained earnings | 23,100 | 25,900 | ||||||
| Total liabilities and equity | $ | 332,700 | $ | 318,100 | ||||
| IKIBAN INC. Income Statement For Year Ended June 30, 2018  | 
||||||
| Sales | $ | 708,000 | ||||
| Cost of goods sold | 417,000 | |||||
| Gross profit | 291,000 | |||||
| Operating expenses | ||||||
| Depreciation expense | $ | 64,600 | ||||
| Other expenses | 73,000 | |||||
| Total operating expenses | 137,600 | |||||
| 153,400 | ||||||
| Other gains (losses) | ||||||
| Gain on sale of equipment | 2,600 | |||||
| Income before taxes | 156,000 | |||||
| Income taxes expense | 44,490 | |||||
| Net income | $ | 111,510 | ||||
Additional Information
Required:
(1) Prepare a statement of cash flows for the year ended June 30, 2018, using the indirect method. (Amounts to be deducted should be indicated with a minus sign.)
| Statement of cash Flows | ||
| Cash flow from operating activities | ||
| Net income for the year | 111,510 | |
| Adjustments to reconcile net income to net cash | ||
| provided by operating activities | ||
| Depreciation expense | 64,600 | |
| Gain on sale of Equipment | -2,600 | |
| Changes in current operating assets and | ||
| liabilities | ||
| increase in accounts receivable | -17000 | |
| Decrease in inventory | 25700 | |
| Decrease in prepaid expense | 1600 | |
| Decrease in accounts payable | -8000 | |
| Decrease in wages payable | -9600 | |
| Decrease in income taxes payable | -1000 | |
| net cash provided by operating activities | 165,210 | |
| Cash flow from investing activities | ||
| purchase of Equipment | -63,600 | |
| Cash received from sale of Equipment | 10,600 | |
| net cash used by investing activities | -53,000 | |
| Cash flow from financing activities | ||
| cash paid for notes payable | -30,000 | |
| Cash from stock issue | 66000 | |
| cash dividend | -114,310 | |
| Net cash used by investing activities | -78310 | |
| net increase in cash | 33,900 | |
| Cash at the beginning of the year | 50,000 | |
| cash at year end | 83,900 | |
| Working notes: | ||
| cash received from sale of equipment | ||
| cost of Equipment | 54,600 | |
| Accumulated dep | 46,600 | |
| Book value | 8,000 | |
| Add:Gain on sale | 2,600 | |
| cash received from sale of equipment | 10,600 | |
| Accumulated depreciation on sold Equipment | ||
| opening bal | 12,000 | |
| add depreciation expense for year | 64,600 | |
| total | 76,600 | |
| less closing balance | 30,000 | |
| Accumulated depreciation on sold Equipment | 46,600 | |
| Dividend paid | ||
| opening retained earnings | 25,900 | |
| Add : net income | 111,510 | |
| 137,410 | ||
| less closing retained earnings | -23100 | |
| Dividends paid | 114,310 |