In: Accounting
Required information
[The following information applies to the questions
displayed below.]
The following financial statements and additional information
are reported.
|
IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 |
||||||||
| 2017 | 2016 | |||||||
| Assets | ||||||||
| Cash | $ | 93,700 | $ | 67,000 | ||||
| Accounts receivable, net | 99,500 | 74,000 | ||||||
| Inventory | 86,800 | 121,000 | ||||||
| Prepaid expenses | 6,700 | 10,000 | ||||||
| Total current assets | 286,700 | 272,000 | ||||||
| Equipment | 147,000 | 138,000 | ||||||
| Accum. depreciation—Equipment | (38,500 | ) | (20,500 | ) | ||||
| Total assets | $ | 395,200 | $ | 389,500 | ||||
| Liabilities and Equity | ||||||||
| Accounts payable | $ | 48,000 | $ | 64,500 | ||||
| Wages payable | 8,300 | 19,600 | ||||||
| Income taxes payable | 5,700 | 8,400 | ||||||
| Total current liabilities | 62,000 | 92,500 | ||||||
| Notes payable (long term) | 53,000 | 83,000 | ||||||
| Total liabilities | 115,000 | 175,500 | ||||||
| Equity | ||||||||
| Common stock, $5 par value | 266,000 | 183,000 | ||||||
| Retained earnings | 14,200 | 31,000 | ||||||
| Total liabilities and equity | $ | 395,200 | $ | 389,500 | ||||
|
IKIBAN INC. Income Statement For Year Ended June 30, 2017 |
||||||
| Sales | $ | 793,000 | ||||
| Cost of goods sold | 434,000 | |||||
| Gross profit | 359,000 | |||||
| Operating expenses | ||||||
| Depreciation expense | $ | 81,600 | ||||
| Other expenses | 90,000 | |||||
| Total operating expenses | 171,600 | |||||
| 187,400 | ||||||
| Other gains (losses) | ||||||
| Gain on sale of equipment | 4,300 | |||||
| Income before taxes | 191,700 | |||||
| Income taxes expense | 46,190 | |||||
| Net income | $ | 145,510 | ||||
Additional Information
A $30,000 note payable is retired at its $30,000 carrying (book) value in exchange for cash.
The only changes affecting retained earnings are net income and cash dividends paid.
New equipment is acquired for $80,600 cash.
Received cash for the sale of equipment that had cost $71,600, yielding a $4,300 gain.
Prepaid Expenses and Wages Payable relate to Other Expenses on the income statement.
All purchases and sales of inventory are on credit.
rev: 06_20_2017_QC_CS-91585, 12_05_2017_QC_CS-111198
Required:
(1) Prepare a statement of cash flows for the
year ended June 30, 2017, using the indirect method.
(Amounts to be deducted should be indicated with a minus
sign.)
| 1) Statement of cash flows | ||||||
| for the year ended June 30, 2017 | ||||||
| Cash from operating activities: | ||||||
| Amount $ | ||||||
| Net Income | 145510 | |||||
| add: depreciation | 81600 | |||||
| less:Gain on sale of equipment | -4300 | |||||
| less: AR increases | -25500 | |||||
| add:Inve decreases | 34200 | |||||
| add:Prepaid exp decreases | 3300 | |||||
| less:AP decreases | -16500 | |||||
| Less:WP decreases | -11300 | |||||
| less:IT pay decreases | -2700 | |||||
| Net cash inflow of operating activities | 204310 | |||||
| Cash flow of Investing Activity: | ||||||
| Acc Dep -Eq | ||||||
| add: sale of eq. | 12300 | Sold Eq | 63600 | 20500 | OB | |
| less: purch of eq. | -80600 | CB | 38500 | 81600 | dep exp | |
| Net cash outflow of Investing activity | -68300 | Total | 102100 | 102100 | Total | |
| Cash flow of Financing Activity: | Cash of sale of Eq: | |||||
| 71600 - 63600 + 4300 | ||||||
| less: NP retired | -30000 | $12,300 | ||||
| add:CS issued | 83000 | |||||
| Less: cash dividend paid | -162310 | Cash dividend= | ||||
| Net cash outflow of financing activity: | -109310 | 31000+145510-14200 | ||||
| 162310 | ||||||
| Net cash inflow of all activities: | 26700 | |||||
| Add: Opening cash | 67000 | |||||
| Closing Cash | 93700 | |||||