Question

In: Accounting

Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1 [The following information...

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.)

Solutions

Expert Solution

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


Related Solutions

Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1 [The following information...
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 $ 103,300 $ 51,000 Accounts receivable, net 75,500 58,000 Inventory 70,800 97,000 Prepaid expenses 5,100 6,800 Total current assets 254,700 212,800 Equipment 131,000 122,000 Accum. depreciation—Equipment (30,500 ) (12,500 ) Total assets $ 355,200 $...
Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1 [The following information...
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 $ 96,100 $ 63,000 Accounts receivable, net 93,500 70,000 Inventory 82,800 115,000 Prepaid expenses 6,300 9,200 Total current assets 278,700 257,200 Equipment 143,000 134,000 Accum. depreciation—Equipment (36,500 ) (18,500 ) Total assets $ 385,200 $...
Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1 [The following information...
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 $ 87,500 $ 44,000 Accounts receivable, net 65,000 51,000 Inventory 63,800 86,500 Prepaid expenses 4,400 5,400 Total current assets 220,700 186,900 Equipment 124,000 115,000 Accum. depreciation—Equipment (27,000 ) (9,000 ) Total assets $ 317,700 $...
Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1
Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1   The following financial statements and additional information are reported. IKIBAN INC.Comparative Balance SheetsJune 30, 2017 and 2016   2017     2016     Assets                 Cash $ 106,300     $ 46,000     Accounts receivable, net   68,000       53,000     Inventory   65,800       89,500     Prepaid expenses   4,600...
Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1
Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1   The following financial statements and additional information are reported. IKIBAN INC.Comparative Balance SheetsJune 30, 2017 and 2016   2017     2016     Assets                 Cash $ 87,500     $ 44,000     Accounts receivable, net   65,000       51,000     Inventory   63,800       86,500     Prepaid expenses   4,400...
Required information Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1 The...
Required information Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1 The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 105,100 $ 48,000 Accounts receivable, net 71,000 55,000 Inventory 67,800 92,500 Prepaid expenses 4,800 6,200 Total current assets 248,700 201,700 Equipment 128,000 119,000 Accum. depreciation—Equipment (29,000 ) (11,000 ) Total assets $ 347,700 $ 309,700 Liabilities and Equity Accounts payable $...
Exercise 16-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1 [The following information...
Exercise 16-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 $ 86,300 $ 46,000 Accounts receivable, net 68,000 53,000 Inventory 65,800 89,500 Prepaid expenses 4,600 5,800 Total current assets 224,700 194,300 Equipment 126,000 117,000 Accum. depreciation—Equipment (28,000 ) (10,000 ) Total assets $ 322,700 $...
Required information Exercise 16-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1 [The...
Required information Exercise 16-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 $ 100,300 $ 56,000 Accounts receivable, net 83,000 63,000 Inventory 75,800 104,500 Prepaid expenses 5,600 7,800 Total current assets 264,700 231,300 Equipment 136,000 127,000 Accum. depreciation—Equipment (33,000 ) (15,000 ) Total assets $...
Exercise 12-12 Indirect: Preparing statement of cash flows LO P2, P3 MONTGOMERY INC. Comparative Balance Sheets...
Exercise 12-12 Indirect: Preparing statement of cash flows LO P2, P3 MONTGOMERY INC. Comparative Balance Sheets December 31 Current Year Prior Year Assets Cash $ 30,400 $ 30,550 Accounts receivable, net 10,050 12,150 Inventory 90,100 70,150 Total current assets 130,550 112,850 Equipment 49,900 41,500 Accum. depreciation—Equipment (22,500 ) (15,300 ) Total assets $ 157,950 $ 139,050 Liabilities and Equity Accounts payable $ 23,900 $ 25,400 Salaries payable 500 600 Total current liabilities 24,400 26,000 Equity Common stock, no par value...
QS 12-19 Indirect: Preparing statement of cash flows LO P1, P2, P3 MONTGOMERY INC. Comparative Balance...
QS 12-19 Indirect: Preparing statement of cash flows LO P1, P2, P3 MONTGOMERY INC. Comparative Balance Sheets December 31, 2018 and 2017 2018 2017 Assets Cash $ 78,500 $ 78,600 Accounts receivable, net 16,700 20,400 Inventory 149,700 117,900 Total current assets 244,900 216,900 Equipment 82,900 69,800 Accum. depreciation—Equipment (37,500 ) (25,700 ) Total assets $ 290,300 $ 261,000 Liabilities and Equity Accounts payable $ 39,900 $ 42,700 Salaries payable 700 1,000 Total current liabilities 40,600 43,700 Equity Common stock, no...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT