IKIBAN INC Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets $ 94,900 96,500 84,800 6,500 282,700 Cash $65,000 Accounts receivable, net Inventory Prepaid expenses 72,000 118,000 9,600 264,600 136,000 Total current assets Equipment Accum. depreciation-Equipment 145,000 (37,500) (19,500) $390,200 $381,100 Total assets Liabilities and Equity Accounts payable Wages payable Income taxes payable $ 46,000 8,100 61,500 19,200 8,000 88,700 81,000 5,500 Total current liabilities 59,600 Notes payable (long term) 51,000 110,600 Total liabilities 169,700 Equity Common stock, $5 par value Retained earnings 262,000 17,600 181,000 30,400 Total liabilities and equity $390,200 $381,100 IKIBAN INC. Income Statement For Year Ended June 30, 2017 $783,000 Sales Cost of goods sold Gross profit Operating expenses Depreciation expense 432,000 351,000 $79,600 Other expenses 88,000 Total operating expenses 167,600 183,400 Other gains (losses) Gain on sale of equipment 4,100 Income before taxes 187,500 Income taxes expense 45,990 $141,510 Net income Additional Information a. A $30,000 note payable is retired at its $30,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 $78,600 cash. d. Received cash for the sale of equipment that had cost $69,600, yielding a $4,100o gain Prepaid Expenses and Wages Payable relate to Other Expenses on the income statement. f. All purchases and sales of inventory are on credit. e. Statement of Cash Flows (Indirect Method) For Year Ended June 30, 2017 Cash flows from operating activities Net income 141,510 Adjustments to reconcile net income to net cash provided by operating activities Income statement items not affecting cash Depreciation expense 79,600 Gain on sale of plant assets (4,100) Changes in current operating assets and liabilities Increase in accounts receivable (24,500) Decrease in inventory 33,200 Decrease in prepaid expenses 3,100 Decrease in accounts payable (15,500) Decrease in wages payable (11,100) Decrease in income taxes payable (2,500) Net cash provided by operating activities 199,710 Cash flows from investing activities Cash received from sale of equipment Cash paid for equipment (78,600) Increase in accounts payable Net cash used in investing activities (78,600) Cash flows from financing activities Cash received from stock issuance 81,000 (30,000) Cash paid to retire notes Cash paid for dividends Net cash used in financing activities 51,000 Net increase (decrease) in cash 172,110 Cash balance at prior year-end Cash balance at current year-end 172.110 Exercise 12-11 Part 2 (2) Compute the company's cash flow on total assets ratio for its fiscal year 2017. Cash Flow on Total Assets Ratio Choose Denominator: =Cash Flow on Total Assets Ratio Choose Numerator: Cash flow on total assets ratio Using the direct method, prepare the statement of cash flows for the year ended June 30, 2017. (Amounts to be deducted should be indicated with a minus sign.) IKIBAN, INC. Statement of Cash Flows (Direct Method) For Year Ended June 30, 2017 Cash flows from operating activities 0 Cash flows from investing activities Cash flows from financing activities Net increase (decrease) in cash 0 Cash balance at prior year-end Cash balance at current year-end 0
