In: Accounting
[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 $ 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 42,800 62,100 Notes payable (long term) 37,000 67,000 Total liabilities 79,800 129,100 Equity Common stock, $5 par value 234,000 167,000 Retained earnings 41,400 26,200 Total liabilities and equity $ 355,200 $ 322,300 IKIBAN INC. Income Statement For Year Ended June 30, 2017 Sales $ 713,000 Cost of goods sold 418,000 Gross profit 295,000 Operating expenses Depreciation expense $ 65,600 Other expenses 74,000 Total operating expenses 139,600 155,400 Other gains (losses) Gain on sale of equipment 2,700 Income before taxes 158,100 Income taxes expense 44,590 Net income $ 113,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 $64,600 cash. Received cash for the sale of equipment that had cost $55,600, yielding a $2,700 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 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.)
Ans- IKIBAN, INC.
Statement of Cash Flows (Direct Method)
For Year Ended June 31,2017
Cash flows from operating activities:- | ||
Net Income | $113,510 | |
Adjustment to reconcile net income to net cash flow from operating activities | ||
Depreciation expenses | 65,600 | |
Gain on sale of equipment | -2,700 | |
Increase in accounts receivable (58,000-75,500) | -17,500 | |
Decrease in inventory (97,000-70,800) | 26,200 | |
Decrease in prepaid expense (6,800-5,100) | 1,700 | |
Decrease in accounts payable (32,000-40,500) | -8,500 | |
Decrease in wages payable (16,400-6,700) | -9,700 | |
Decrease in income tax payable (5,200-4,100) | -1,100 | |
54,000 | ||
Net cash flow from operating activities | 167,510 | |
Cash flow from investing activities: | ||
Sale of equipment | 10,700 | |
Purchase equipment | -64,600 | |
Net cash used in investing activities | -53,900 | |
Cash flow from financing activities: | ||
Repaid long term notes payable | -30,000 | |
Issue Common stock | 67,000 | |
Dividend paid | -98,310 | |
Net cash used in financing activities | -61,310 | |
Net Cash Increase/ (Decrease) | 52,300 | |
Add: Beginning cash balance | 51,000 | |
Cash balance at the end of year | $103,300 |
Working Note:
Accumulated depreciation on equipment sold:
Accumulated Depreciation beginning balance | $12,500 |
Add: Depreciation of current year | $65,600 |
Subtotal | $78,100 |
Ending balance of Accumulated Depreciation | $30,500 |
Depreciation on asset sold | $47,600 |
Cash received on sale of equipment:-
Cost of equipment sold | $55,600 |
Less: Accumulated Depreciation | $47,600 |
Book value of asset sold | $8,000 |
Profit on sale | $2,700 |
Cash received on sale of equipment | $10,700 |
Calculation of dividend paid:-
Beginning balance of retained earnings | $26,200 |
Add: Net income | $113,510 |
$139,710 | |
Less: Ending balance of Retained Earnings | $41,400 |
Dividend paid in cash | 98,310 |