In: Accounting
Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1
[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 | $ | 99,700 | $ | 57,000 | ||||
Accounts receivable, net | 84,500 | 64,000 | ||||||
Inventory | 76,800 | 106,000 | ||||||
Prepaid expenses | 5,700 | 8,000 | ||||||
Total current assets | 266,700 | 235,000 | ||||||
Equipment | 137,000 | 128,000 | ||||||
Accum. depreciation—Equipment | (33,500 | ) | (15,500 | ) | ||||
Total assets | $ | 370,200 | $ | 347,500 | ||||
Liabilities and Equity | ||||||||
Accounts payable | $ | 38,000 | $ | 49,500 | ||||
Wages payable | 7,300 | 17,600 | ||||||
Income taxes payable | 4,700 | 6,400 | ||||||
Total current liabilities | 50,000 | 73,500 | ||||||
Notes payable (long term) | 43,000 | 73,000 | ||||||
Total liabilities | 93,000 | 146,500 | ||||||
Equity | ||||||||
Common stock, $5 par value | 246,000 | 173,000 | ||||||
Retained earnings | 31,200 | 28,000 | ||||||
Total liabilities and equity | $ | 370,200 | $ | 347,500 | ||||
IKIBAN INC. Income Statement For Year Ended June 30, 2017 |
||||||
Sales | $ | 743,000 | ||||
Cost of goods sold | 424,000 | |||||
Gross profit | 319,000 | |||||
Operating expenses | ||||||
Depreciation expense | $ | 71,600 | ||||
Other expenses | 80,000 | |||||
Total operating expenses | 151,600 | |||||
167,400 | ||||||
Other gains (losses) | ||||||
Gain on sale of equipment | 3,300 | |||||
Income before taxes | 170,700 | |||||
Income taxes expense | 45,190 | |||||
Net income | $ | 125,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 $70,600 cash.
Received cash for the sale of equipment that had cost $61,600, yielding a $3,300 gain.
Prepaid Expenses and Wages Payable relate to Other Expenses on the income statement.
All purchases and sales of inventory are on credit.
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.)
Cash Flow from Operating Activity:- |
Amount |
Amount |
Net Income |
125510 |
|
Gain on Equipment sold |
(3300) |
|
Depreciation |
71600 |
|
Increase A/c Receivable |
(20500) |
|
Decrease Inventory |
29200 |
|
Decrease Prepaid Exp |
2300 |
|
Decrease A/c Payable |
(11500) |
|
Decrease Wage Payable |
(10300) |
|
Imcome Tax Exp |
45190 |
|
Paid Income Tax (45190+6400-4700) |
(46890) |
|
Cash Flow from Operating Activity (A) |
181310 |
181310 |
Cash Flow from Investing Activity:- |
||
Equipment Purchase |
(70600) |
|
Equipment Sold (61600-50300) |
11300 |
|
Cash Flow from Investing Activity (B) |
(59300) |
(59300) |
Cash Flow from Financing Activity:- |
||
Notes Paid |
(30000) |
|
Dividend Paid |
(122310) |
|
Common stock issue |
73000 |
|
(79310) |
(79310) |
|
TOTAL CASH FLOW (a+b+c) |
42700 |
|
Add opening cash |
57000 |
|
Closing cash |
99700 |