Question

In: Accounting

The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...

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 16,300 Income taxes payable 2,600 3,900 Total current liabilities 36,700 52,700 Notes payable (long term) 53,000 76,000 Total liabilities 89,700 128,700 Equity Common stock, $5 par value 240,000 187,000 Retained earnings 25,300 7,500 Total liabilities and equity $ 355,000 $ 323,200 IKIBAN INC. Income Statement For Year Ended June 30, 2015 Sales $ 675,000 Cost of goods sold 409,000 Gross profit 266,000 Operating expenses Depreciation expense $ 57,900 Other expenses 66,400 Total operating expenses 124,300 141,700 Other gains (losses) Gain on sale of equipment 2,700 Income before taxes 144,400 Income taxes expense 57,760 Net income $ 86,640 Additional Information a. A $23,000 note payable is retired at its $23,000 carrying (book) value in exchange for cash. b. The only changes affecting retained earnings are net income and cash dividends paid. c. New equipment is acquired for $59,700 cash. d. Received cash for the sale of equipment that had cost $49,200, yielding a $2,700 gain. e. Prepaid Expenses and Wages Payable relate to Other Expenses on the income statement. f. All purchases and sales of inventory are on credit.

Required:

(1)

Prepare a statement of cash flows for the year ended June 30, 2015, using the indirect method. (Amounts to be deducted should be indicated with a minus sign.)

(2)

Compute the company's cash flow on total assets ratio for its fiscal year 2015.

Solutions

Expert Solution

Statement of Cash Flow
Particulars Amount Amount
Cash Flow from Operating Activities
Net Income $86,640
Adjustments for:
Depreciation $57,900
Gain on sale of property, plant and equipment ($2,700)
$55,200
Increase in Accounts receivable ($18,100)
Decrease in Inventory $30,600
Decrease in Prepaid expenses $800
Decrease in Accounts payable ($6,300)
Decrease in Income tax payable ($1,300)
Decrease in Wages Payable ($8,400)
($2,700)
Net cash flow generated from Operating Activities $139,140
Cash Flow from Investing Activities
Purchase of new equipment ($59,700)
Sold property, plant and equipment $12,100
Net cash flow from Investing Activities ($47,600)
Cash Flow from Financing Activities
Payment on long-term note payable ($23,000)
Issued Common Stock $53,000
Dividends paid (7500+86640-25300) ($68,840)
Net cash flow from Financing Activities ($38,840)
Net Cash Flow $52,700
Cash and Cash Equivalent as on 30th Jun. 2014 $62,700
Cash and Cash Equivalent as on 30th Jun. 2015 $115,400
Accumulated depreciation account
account amount account amount
Balance c/f $10,100
equipment -sold $39,800 depreciation $57,900
Balance c/d $28,200
$68,000 $68,000
cost of the equpment sold 49200
Less: accumulated depreciation ($39,800)
Book Value of equipment sold $9,400
Add Profit on sale 2700
Cash received on sale

$12,100

Cash Flow from Total Assets Ratio = Cash From Operations / Total Assets
= $139140 / [($355000 + $323,200) / 2]
= $139140 / $339100= 41.03%

Related Solutions

The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
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...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 103,900 $ 50,000 Accounts receivable, net 74,000 57,000 Inventory 69,800 95,500 Prepaid expenses 5,000 6,600 Total current assets 252,700 209,100 Equipment 130,000 121,000 Accum. depreciation—Equipment (30,000 ) (12,000 ) Total assets $ 352,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...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 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 payable 6,000 15,000 Income taxes payable 3,400 3,800 Total current liabilities...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
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 payable 7,800 18,600 Income taxes payable 5,200 7,400 Total current liabilities...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2018 and 2017 2018 2017 Assets Cash $ 77,300 $ 61,000 Accounts receivable, net 90,500 68,000 Inventory 80,800 112,000 Prepaid expenses 6,100 8,800 Total current assets 254,700 249,800 Equipment 141,000 132,000 Accum. depreciation—Equipment (35,500 ) (17,500 ) Total assets $ 360,200 $ 364,300 Liabilities and Equity Accounts payable $ 42,000 $ 55,500 Wages payable 7,700 18,400 Income taxes payable 5,100 7,200 Total current liabilities...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 Assets Cash $ 105,700 $ 47,000 Accounts receivable, net 69,500 54,000 Inventory 66,800 91,000 Prepaid expenses 4,700 6,000 Total current assets 246,700 198,000 Equipment 127,000 118,000 Accum. depreciation—Equipment (28,500 ) (10,500 ) Total assets $ 345,200 $ 305,500 Liabilities and Equity Accounts payable $ 28,000 $ 34,500 Wages payable 6,300 15,600 Income taxes payable 3,700 4,400 Total current liabilities...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
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...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2015 and 2014 2015 2014   Assets   Cash $ 114,400 $ 66,300   Accounts receivable, net 70,000 51,900   Inventory 65,900 96,600   Prepaid expenses 4,700 6,100   Total current assets 255,000 220,900   Equipment 124,700 114,000   Accum. depreciation—Equipment (28,800 ) (10,400 )   Total assets $ 350,900 $ 324,500   Liabilities and Equity   Accounts payable $ 26,300 $ 32,700   Wages payable 7,900 16,300   Income taxes payable 2,700 4,400   Total current liabilities...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2015 and 2014 2015 2014   Assets   Cash $ 114,400 $ 66,300   Accounts receivable, net 70,000 51,900   Inventory 65,900 96,600   Prepaid expenses 4,700 6,100   Total current assets 255,000 220,900   Equipment 124,700 114,000   Accum. depreciation—Equipment (28,800 ) (10,400 )   Total assets $ 350,900 $ 324,500   Liabilities and Equity   Accounts payable $ 26,300 $ 32,700   Wages payable 7,900 16,300   Income taxes payable 2,700 4,400   Total current liabilities...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 97,300 $ 61,000 Accounts receivable, net 90,500 68,000 Inventory 80,800 112,000 Prepaid expenses 6,100 8,800 Total current assets 274,700 249,800 Equipment 141,000 132,000 Accum. depreciation—Equipment (35,500 ) (17,500 ) Total assets $ 380,200 $ 364,300 Liabilities and Equity Accounts payable $ 42,000 $ 55,500 Wages payable 7,700 18,400 Income taxes payable 5,100 7,200 Total current liabilities...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT