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 $ 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 payable 8,500 20,000 Income taxes payable 5,900 8,800 Total current liabilities 64,400 96,300 Notes payable (long term) 55,000 85,000 Total liabilities 119,400 181,300 Equity Common stock, $5 par value 270,000 185,000 Retained earnings 10,800 31,600 Total liabilities and equity $ 400,200 $ 397,900 IKIBAN INC. Income Statement For Year Ended June 30, 2017 Sales $ 803,000 Cost of goods sold 436,000 Gross profit 367,000 Operating expenses Depreciation expense $ 83,600 Other expenses 92,000 Total operating expenses 175,600 191,400 Other gains (losses) Gain on sale of equipment 4,500 Income before taxes 195,900 Income taxes expense 46,390 Net income $ 149,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 $82,600 cash. Received cash for the sale of equipment that had cost $73,600, yielding a $4,500 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 (2) Compute the company's cash flow on total assets ratio for its fiscal year 2017.

Solutions

Expert Solution

Please give positive ratings so I can keep answering. Thanks!

Balance Sheet 2017 2016 Income statement 2017
Assets   Sales 803,000.00
Cash      92,500.00      69,000.00 Cost of Goods sold 436,000.00
Accounts receivable 102,500.00      76,000.00 Gross Profit 367,000.00
Inventory      88,800.00    124,000.00 Operating expenses
Prepaid Expense        6,900.00      10,400.00 Depreciation expense      83,600.00
Total Current Assets   290,700.00    279,400.00 Other expense      92,000.00
Equipment 149,000.00    140,000.00 Total Operating expenses 175,600.00
Accumulated depreciation    (39,500.00)     (21,500.00) Operating income 191,400.00
Total assets 400,200.00    397,900.00 Other gains (losses)
Gain on sale of equipment        4,500.00
Liabilities & Equity Income before taxes 195,900.00
Accounts payable      50,000.00      67,500.00 Income taxes expense      46,390.00
Wages payable        8,500.00      20,000.00 Net income 149,510.00
Income tax payable        5,900.00        8,800.00
Total Current Liabilities     64,400.00      96,300.00 A $30,000 note payable is retired at its $30,000 carrying (book) value in exchange for cash.
Notes Payable (long term)      55,000.00      85,000.00 The only changes affecting retained earnings are net income and cash dividends paid.
Total liabilities 119,400.00    181,300.00 New equipment is acquired for $82,600 cash. Received cash for the sale of equipment that had cost $73,600, yielding a $4,500 gain.
Equity Common stock, $5 par value 270,000.00    185,000.00 Prepaid Expenses and Wages Payable relate to Other Expenses on the income statement.
Retained earnings      10,800.00      31,600.00 All purchases and sales of inventory are on credit
Total liabilities and equity 400,200.00    397,900.00
Net Cash flow from operating activities
Particulars Amount $
Net income 149,510.00
Add: Depreciation Expense      83,600.00
Less: Gain on sale of equipment        4,500.00
Cash flow from Operations 228,610.00
Changes in working capital
Decrease in Inventory      35,200.00
Increase in Accounts Receivable    (26,500.00)
Decrease in Prepaid Expense        3,500.00
Decrease in Accounts Payable    (17,500.00)
Decrease in Wages Payable    (11,500.00)
Decrease in Income Taxes Payable      (2,900.00)
Net Cash flow from operating activities 208,910.00 A
Average Total Assets 399,050.00 B
cash flow on total assets ratio for its fiscal year 2017=                0.52 C=A/B

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, 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.] 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