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 $ 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 36,900 53,400
  Notes payable (long term) 55,000 75,000
  Total liabilities 91,900 128,400
  Equity
  Common stock, $5 par value 234,000 188,000
  Retained earnings 25,000 8,100
  Total liabilities and equity $ 350,900 $ 324,500

     

IKIBAN INC.
Income Statement
For Year Ended June 30, 2015
  Sales $ 670,000
  Cost of goods sold 408,000
  Gross profit 262,000
  Operating expenses
       Depreciation expense $ 58,300
       Other expenses 66,600
  Total operating expenses 124,900
        137,100  
  Other gains (losses)
       Gain on sale of equipment 2,700
  Income before taxes 139,800
  Income taxes expense 55,920
  Net income $ 83,880

     

Additional Information
a. A $20,000 note payable is retired at its $20,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,900 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. (1) Compute the company's cash flow on total assets ratio for its fiscal year 2015.

Solutions

Expert Solution

IKIBAN INC
Statement of Cash Flows  
For the Year Ended June 30, 2015
Cash flows from operating activities
Net Income   $    83,880
Adjustments to reconcile net income to :
Depreciation expense $   58,300
Gain on sale of equipment $   (2,700)
Increase in accounts receivable $ (18,100) 51900-70000
Decrease in inventory $   30,700 96600-65900
Decrease in prepaid expenses $      1,400 6100-4700
Decrease in accounts payable $   (6,400) 26300-32700
Decrease in wages payable $   (8,400) 7900-16300
Decrease in income tax payable $   (1,700) 2700-4400
$    53,100
Net cash provided by operating activities $ 136,980
Cash flows from investing activities
Cash received from sale of equipment $   12,000 49200-(10400+58300-28800)+2700
Cash paid for sale of equipment $ (59,900)
Net cash used by investing activities $ (47,900)
Cash flows from financing activities
Cash paid as dividend $ (66,980) 25000-8100-83880
Cash paid for retire notes $ (20,000)
Cash received from issuance of common stock $   46,000 234000-188000
Net cash used by financing activities $ (40,980)
Net Increase in cash and cash equivalents $    48,100
Cash and cash equivalents at beginning of period $    66,300
Cash and cash equivalents at end of period $ 114,400
Cash flow on total assets ratio = Cash flow from operating activities / Average total assets
Cash flow on total assets ratio = $136,980 / (($350,900+$324,500)/2)
Cash flow on total assets ratio = 40.56%

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