Question

In: Accounting

[The following information applies to the questions displayed below.] The following financial statements and additional 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 $ 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 $ 322,300 Liabilities and Equity Accounts payable $ 32,000 $ 40,500 Wages payable 6,700 16,400 Income taxes payable 4,100 5,200 Total current liabilities 42,800 62,100 Notes payable (long term) 37,000 67,000 Total liabilities 79,800 129,100 Equity Common stock, $5 par value 234,000 167,000 Retained earnings 41,400 26,200 Total liabilities and equity $ 355,200 $ 322,300 IKIBAN INC. Income Statement For Year Ended June 30, 2017 Sales $ 713,000 Cost of goods sold 418,000 Gross profit 295,000 Operating expenses Depreciation expense $ 65,600 Other expenses 74,000 Total operating expenses 139,600 155,400 Other gains (losses) Gain on sale of equipment 2,700 Income before taxes 158,100 Income taxes expense 44,590 Net income $ 113,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 $64,600 cash. Received cash for the sale of equipment that had cost $55,600, yielding a $2,700 gain. Prepaid Expenses and Wages Payable relate to Other Expenses on the income statement. All purchases and sales of inventory are on credit. rev: 12_05_2017_QC_CS-111198 Using the direct method, prepare the statement of cash flows for the year ended June 30, 2017. (Amounts to be deducted should be indicated with a minus sign.)

Solutions

Expert Solution

Ans- IKIBAN, INC.

Statement of Cash Flows (Direct Method)

For Year Ended June 31,2017

Cash flows from operating activities:-
Net Income $113,510
Adjustment to reconcile net income to net cash flow from operating activities
Depreciation expenses 65,600
Gain on sale of equipment -2,700
Increase in accounts receivable (58,000-75,500) -17,500
Decrease in inventory (97,000-70,800) 26,200
Decrease in prepaid expense (6,800-5,100) 1,700
Decrease in accounts payable (32,000-40,500) -8,500
Decrease in wages payable (16,400-6,700) -9,700
Decrease in income tax payable (5,200-4,100) -1,100
54,000
Net cash flow from operating activities 167,510
Cash flow from investing activities:
Sale of equipment 10,700
Purchase equipment -64,600
Net cash used in investing activities -53,900
Cash flow from financing activities:
Repaid long term notes payable -30,000
Issue Common stock 67,000
Dividend paid -98,310
Net cash used in financing activities -61,310
Net Cash Increase/ (Decrease) 52,300
Add: Beginning cash balance 51,000
Cash balance at the end of year $103,300

Working Note:

Accumulated depreciation on equipment sold:

Accumulated Depreciation beginning balance $12,500
Add: Depreciation of current year $65,600
Subtotal $78,100
Ending balance of Accumulated Depreciation $30,500
Depreciation on asset sold $47,600

Cash received on sale of equipment:-

Cost of equipment sold $55,600
Less: Accumulated Depreciation $47,600
Book value of asset sold $8,000
Profit on sale $2,700
Cash received on sale of equipment $10,700

Calculation of dividend paid:-

Beginning balance of retained earnings $26,200
Add: Net income $113,510
$139,710
Less: Ending balance of Retained Earnings $41,400
Dividend paid in cash 98,310

Related Solutions

[The following information applies to the questions displayed below.] The following financial statements and additional 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 $ 94,300 $ 66,000 Accounts receivable, net 98,000 73,000 Inventory 85,800 119,500 Prepaid expenses 6,600 9,800 Total current assets 284,700 268,300 Equipment 146,000 137,000 Accum. depreciation—Equipment (38,000 ) (20,000 ) Total assets $ 392,700 $ 385,300 Liabilities and Equity Accounts payable $ 47,000 $ 63,000 Wages payable 8,200...
[The following information applies to the questions displayed below.] The following financial statements and additional 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 $ 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 $ 322,300 Liabilities and Equity Accounts payable $ 32,000 $ 40,500 Wages payable 6,700...
[The following information applies to the questions displayed below.] The following financial statements and additional 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, 2015 and 2014 2015 2014 Assets Cash $ 115,400 $ 62,700 Accounts receivable, net 69,400 51,300 Inventory 66,100 96,700 Prepaid expenses 4,800 5,600 Total current assets 255,700 216,300 Equipment 127,500 117,000 Accum. depreciation—Equipment (28,200 ) (10,100 ) Total assets $ 355,000 $ 323,200 Liabilities and Equity Accounts payable $ 26,200 $ 32,500 Wages payable 7,900...
The following information applies to the questions displayed below.] The following financial statements and additional 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 $ 94,300 $ 66,000 Accounts receivable, net 98,000 73,000 Inventory 85,800 119,500 Prepaid expenses 6,600 9,800 Total current assets 284,700 268,300 Equipment 146,000 137,000 Accum. depreciation—Equipment (38,000 ) (20,000 ) Total assets $ 392,700 $ 385,300 Liabilities and Equity Accounts payable $ 47,000 $ 63,000 Wages payable 8,200...
Required information [The following information applies to the questions displayed below.] The following financial statements and...
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...
Required information [The following information applies to the questions displayed below.] The following financial statements and...
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 $ 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 $ 29,000 $ 36,000 Wages...
Required information [The following information applies to the questions displayed below.] The following financial statements and...
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 $ 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 $ 29,000 $ 36,000 Wages...
Required information [The following information applies to the questions displayed below.] The following financial statements and...
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 $ 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 $ 372,700 Liabilities and Equity Accounts payable $ 44,000 $ 58,500 Wages...
Required information [The following information applies to the questions displayed below.] The following financial statements and...
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 $ 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 $ 292,900 Liabilities and Equity Accounts payable $ 25,000 $ 30,000 Wages...
Required information [The following information applies to the questions displayed below.] The following financial statements and...
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, 2019 and 2018 2019 2018 Assets Cash $ 96,700 $ 62,000 Accounts receivable, net 92,000 69,000 Inventory 81,800 113,500 Prepaid expenses 6,200 9,000 Total current assets 276,700 253,500 Equipment 142,000 133,000 Accum. depreciation—Equipment (36,000 ) (18,000 ) Total assets $ 382,700 $ 368,500 Liabilities and Equity Accounts payable $ 43,000 $ 57,000 Wages...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT