I am preparing a statement of cash flows

below are the income statement, balance sheets for the current and previous year, and given info.

I have completed most of it but I am missing information somewhere. I have also included what I have so far.

nancial Reporting Step 2 Template_20151111 (1) - Ex... Search Formulas Data Review View Help AA == A. 2 Wrap Text Merge & Center - Accounting $ -% -98 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Alignment Number Cells 5000 2 Given Information: 3 Scenic had no noncash investing and financing transactions for 2013. During the year, Scenic sold equipment for $15.100 which 4 had orginally cost $12,700 and had a book value of $10.700. 5 Scenic did not issue any notes payable during the year. Scenic did issue common stock for $30,000. ANSWER: A = = Number Wrap Text E Merge & Center - E E $ % 8 Conditional Forma Formatting Table Alignment Number Styles 5 Scenic did not issue any notes payable during the year. Scenic did issue common stock fou $347.000 78,000 $269,000 Scenic Industries, Inc. Income Statement December 31, 2013 10 Sales revenue 11 Cost of goods sold 12 Gross profit 13 Operating expenses: 14 Salaries expense 15 Depreciation expense 16 Other operating expenses 17 Operating Income 18 Other incomes and expenses: 19 Gain on Sale of equipment 20 Interest expense 21 Income before taxes 22 Income tax expense 23 Net Income $26,500 4,900 12,500 43,900 $225,100 $4,400 9.900 5,500 $219,600 (36.600) $183,000 Given Income Statement Balance Sheet Statement of Cash Flows hp a law hp Pra Puc 2012 Casi Pring Proc Scenic Industries, Inc. Balance Sheets For Years ended December 31, 2012 and 2013 Assets 2013 31 Current Assets: 32 Cash and cash equivalents $50,000 33 Accounts receivable 32,100 34 Inventory 86,000 35 Prepaid insurance 3,300 36 Total current assets: $171,400 37 Property, plant & equipment 153,000 38 Less: Accumulated depreciation (30,000) 39 Investments 113,000 40 Total Assets $407 400 Liabilities 42 Current Liabilities 43 Accounts payable (Inventory purchases) $33 200 44 Salaries payable 2,900 45 Interest payable 2,400 46 Taxes payable 5,300 47 Other accrued operating expenses 18,800 48 Total current liabilities 62,600 Close Given income Statement Balance Sheet $23,500 29,100 93,300 2,800 $148.700 136,000 (27,100) Cash $257,600 536,500 7,400 22,100 66,000 Statement of Cash Flows 46 Taxes payable 47 Other accrued operating expenses 48 Total current liabilities 49 Bonds Payable 50 Total Liabilities 51 Stockholders' Equity 52 Common stock 53 Retained earnings 54 Total stockholders' equity 55 Total liabilites and equity 2,400 5,300 18,800 62,600 78,000 140,600 22,100 66,000 113,000 179,000 107,000 159,800 266,800 $407,400 77,000 1,600 78,600 $257,600 Close Given Income Statement Balance Sheet Statement of Cash Flows TUMMY Tule Style Alignment Number Styles Cells Enter the appropriate accountsames and numbers in the yellow boxes- INDIRECT METHOD Scenic Industries, Inc. Statement of Cash Flows For the Year Ended December 31, 2013 A A Cash flows from operating activities: Net income $ 183 000.00 Adjustments to reconcile net income to net cash provided by operating activities: Add back depreciation expense 4,900.00 Increase in interest payable 2.400.00 Deduct gain on sale of equipment (4.400 00) Decrease in salaries payable (4 500 00) Increase in accounts recievable (3.000.00) Decrease in inventory 7.300.00 Increase in prepaid insurance (500.00) Decrease in accounts payable (3.300.00) Increase in taxes payable 5.300.00 Decrease in accured operating expenses (3 300 00) Net cash provided by operating activities S 183 900.00 A A A Cash flows from investing activities Proceeds from sale of equipment 15 10000 Cash flows from investing activities: Proceeds from sale of equipment Puchase of long-term investments 15,100.00 (113,000.00 $ Net cash used for investing activities $ (97,900.00) Cash flows from financing activities: Principal payment on bonds Proceeds from issuance of common stock (35,000.00) 30,000.00 Net cash used for financing activities $ (5,000.00) Cash balance, December 31, 2013 Given Income Statement Balance Sheet Statement of Cash Flows