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, 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 56,000 83,000 Notes payable (long term) 48,000 78,000 Total liabilities 104,000 161,000 Equity Common stock, $5 par value 256,000 178,000 Retained earnings 22,700 29,500 Total liabilities and equity $ 382,700 $ 368,500 IKIBAN INC. Income Statement For Year Ended June 30, 2019 Sales $ 768,000 Cost of goods sold 429,000 Gross profit 339,000 Operating expenses Depreciation expense $ 76,600 Other expenses 85,000 Total operating expenses 161,600 177,400 Other gains (losses) Gain on sale of equipment 3,800 Income before taxes 181,200 Income taxes expense 45,690 Net income $ 135,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 $75,600 cash. Received cash for the sale of equipment that had cost $66,600, yielding a $3,800 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 using the indirect method for the year ended June 30, 2019. (Amounts to be deducted should be indicated with a minus sign.)

Solutions

Expert Solution

IKIBAN, INC.
Statement of Cash Flows (Indirect Method)
For the Year Ended June 30, 2019
Cash flow from operating activities:
Net income $135510
Adjustments to reconcile net income to net cash provided by operating activities
Income statement items not affecting cash
Depreciation expense 76600
Gain on sale of plant assets -3800
Changes in current operating assets and liabilities
Decrease in inventory (113500-81800) 31700
Decrease in prepaid expenses (9000-6200) 2800
Increase in accounts receivable (92000-69000) -23000
Decrease in accounts payable (57000-43000) -14000
Decrease in wages payable (18600-7800) -10800
Decrease in income taxes payable (7400-5200) -2200
Net cash provided by operating activities 192810
Cash flows from investing activities:
Sale of equipment 11800
Purchase of equipment -75600
Net cash used in investing activities -63800
Cash flows from financing activities:
Issuance of common stock (256000-178000) 78000
Cash paid to retire notes -30000
Dividends paid -142310
Net cash used in financing activities -94310
Net increase (decrease) in cash (192810-63800-94310) $34700
Cash balance at prior year end 62000
Cash balance at current year end $96700

Depreciation on the sold equipment= Accumulated depreciation at the beginning of the year+Depreciation expense-Accumulated depreciation at the end of the year

= $18000+76600-36000= $58600

Book value of the equipment at the time of sales= Cost of the sales equipment-Depreciation on the sold equipment

= $66600-58600= $8000

Sales price of the equipment= Book value of the equipment at the time of sales+Gain on sale of equipment

= $8000+3800= $11800

Dividend paid= Retained earnings at the beginning of the year+Net income-Retained earning at the end of the year

= $29500+135510-22700= $142310


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 $ 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, 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