Question

In: Accounting

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

Solutions

Expert Solution

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

Related Solutions

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...
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 $ 92,500 $ 69,000 Accounts receivable, net 102,500 76,000 Inventory 88,800 124,000 Prepaid expenses 6,900 10,400 Total current assets 290,700 279,400 Equipment 149,000 140,000 Accum. depreciation—Equipment (39,500 ) (21,500 ) Total assets $ 400,200 $ 397,900 Liabilities and Equity Accounts payable $ 50,000 $ 67,500 Wages...
Required information [The following information applies to the questions displayed below.] Portions of the financial statements...
Required information [The following information applies to the questions displayed below.] Portions of the financial statements for Parnell Company are provided below. PARNELL COMPANY Income Statement For the Year Ended December 31, 2021 ($ in thousands) Revenues and gains: Sales $ 790 Gain on sale of building 10 $ 800 Expenses and loss: Cost of goods sold $ 295 Salaries 119 Insurance 39 Depreciation 122 Interest expense 49 Loss on sale of equipment 12 636 Income before tax 164 Income...
Required information [The following information applies to the questions displayed below.] The comparative financial statements for...
Required information [The following information applies to the questions displayed below.] The comparative financial statements for Prince Company are below:      Year 2 Year 1 Income statement: Sales revenue $ 212,000 $ 172,500 Cost of goods sold 117,500 102,200 Gross profit 94,500 70,300 Operating expenses and interest expense 58,200 54,100 Pretax income 36,300 16,200 Income tax 10,200 5,100 Net income $ 26,100 $ 11,100 Balance sheet: Cash $ 6,200 $ 8,100 Accounts receivable (net) 15,100 19,100 Inventory 42,200 38,400 Property...
Required information [The following information applies to the questions displayed below.] The financial statements for Limited...
Required information [The following information applies to the questions displayed below.] The financial statements for Limited Brands, Inc. follow (fiscal years ending January): Limited Brands, Inc. Balance Sheets ($ Millions) 2007 2006 2005 Total Assets 7,093.000 6,346.000 6,089.000 Liabilities Long-Term Debt Due In One Year 8.000 7.000 0.000 Payables and Accrued Expenses 1,701.000 1,568.000 1,451.000 Total Current Liabilities 1,709.000 1,575.000 1,451.000 Long-Term Debt 1,665.000 1,669.000 1,646.000 Deferred Taxes 173.000 146.000 177.000 Minority Interest 71.000 33.000 33.000 Other Liabilities 520.000 452.000...
Required information [The following information applies to the questions displayed below.] Comparative financial statements for Weaver...
Required information [The following information applies to the questions displayed below.] Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash $ 3 $ 12 Accounts receivable 307 231 Inventory 157 196 Prepaid expenses 9 6 Total current assets 476 445 Property, plant, and equipment 504 425 Less accumulated depreciation (85 ) (72 ) Net property, plant, and equipment 419 353 Long-term investments 29 35 Total assets $ 924...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT