Question

Using the information provided, complete the cash flow statement using the indirect method. MAKE USE OF EXCEL CAPABILITIES BY USING AS MANY FORMULAS AND FUNCTIONS AS POSSIBLE.

Reference or given data section. 12/31/2015 Change STATEMENT OF CASH FLOWS (INDIRECT METHOD) The Group, Inc. Consolidated Balance Sheets (in thousands) 3/31/2016 ASSETS Current Assets: Cash and Cash Equivalents $92,069 Accounts Receivables, Net 55,947 Inventories 50,784 Prepaid Expenses 12,112 Total Current Assets 210,912 Equipment 145,444 Less: Accumulated Depreciation -50,515 Total Assets $305,841 $72,634 75,492 53,129 13,057 214,312 134,312 -36,689 $311,935 Answer section is on the second tab titled "Cash Flow" LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities: Accounts Payable Accrued Liabilities Total Current Liabilities Long-Term Debt Stockholders' Equity: Contributed Capital Retained Earnings Total Stockholders' Equity Total Liabilities And Stockholders' $25,466 40,574 66,040 10,422 $34,879 40,722 75,601 10,206 1,662 227,717 229,379 $305,841 1,284 224,844 226,128 $311,935 Consolidated Statement of Income (in thousands) Info cash flow

Answer 1

Statement of Cash Flows Cash Flows Operating Activities Net Income $6,437.00 Add Items to reconcile operating income Depreciation $13,826.00 $13,826.00 Less- Interest Income $239.00 $239.00 Less- Decrease in current liabilities Accounts Payable $9,413.00 Accrued Liabilities $148.00 $9,561.00 Add- Decrease in current assets Accounts Receivables $19,545.00 Inventories $2,345.00 Prepaid Expenses $945.00 $22,835.00 $26,861.00 Cash Flow from operating activities $33,298.00 Cash Flows from Investing Activities Less- Purchase of Equipment $11,132.00 Cash Flows from Investing Activities $11,132.00 Cash Flows from Financing Activities Add- Interest Income $239.00 Borrowed Long-Term Debt $216.00 Issued Capital $378.00 Less- Dividend Declared $3,564.00 Cash Flows from Financing Activities $833.00 $3,564.00 -$2,731.00

А Statement of Cash Flows 2 Cash Flows Operating Activities Net Income 6437 Add Items to reconcile operating income Depreciation 13826 =B5 6 Less- 7 Interest Income 239 =B7 8 Less- 9 Decrease in current liabilities 10 Accounts Payable =34879-25466 11 Accrued Liabilities =40722-40574 !=B11+B10 12 Add- 13 Decrease in current assets 14 Accounts Receivables =75492-55947 15 Inventories =53129-50784 16 Prepaid Expenses =13057-12112 =B14+B15+B16 =C5-C7-C11+C16 17 Cash Flow from operating activities =D16+D3 18 19 Cash Flows from Investing Activities 20 Less- 21 Purchase of Equipment Cash Flows from Investing Activities 11132 2-321 22 23 239 24 Cash Flows from Financing Activities 25 Add- 26 Interest Income 27 Borrowed Long-Term Debt 28 Issued Capital 29 Less- 30 Dividend Declared 31 Cash Flows from Financing Activities =10422-10206 =1662-1284 =SUM(B26:328) =224844-6437-2: =B30 =C28-C30