Please help with CF from customers and acquired equipment

Thanks!

The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for National Intercable Company. Additional information from NIC's accounting records is provided also NATIONAL INTERCABLE COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in millions) 2018 2017 Assets Cash Accounts receivable 61 60 170 175 Less: Allowance for uncollectible accounts (11) Prepaid insurance Inventory Long-term investment Land Buildings and equipment (5) 10 150 40 160 200 156 160 220 (55) (50) Less: Accumulated depreciation Trademark 19 20 $754 $755 Liabilities Accounts payable Salaries payable Deferred income tax liability Lease liability Bonds payable 28 40 12 35 150 10 250 Less: Discount on bonds Shareholders' Equity Common stock Paid-in capital-excess of par Preferred stock Retained earnings (18) (20) 210 70 20 244 200 50 221 754 755 NATIONAL INTERCABLE COMPANY Income Statement For Year Ended December 31, 2018 ($in millions) Revenues $250 Sales revenue Investment revenue Gain on sale of investments 5 $266 Expenses 100 50 10 Cost of goods sold Salaries expense Depreciation expense Trademark amortization expense Bad debt expense Insurance expense Bond interest expense 10 20 Loss on building fire Income before tax Income tax expense 13 208 58 25 $ 33 Net income Additional information from the accounting records: a. Investment revenue includes National Intercable Company's $2 million share of the net income of Central Fiber Optics Corporation, an equity method investee. b. A long-term investment in bonds, originally purchased for $20 million, was sold for $25 million. c. Pretax accounting income exceeded taxable income causing the deferred income tax liability to increase by $2 million fire. Some undamaged parts were sold for $2 million. payments, $40 million. Annual lease payments of $5 million are paid at Jan. 1 of each year starting d. A building that originally cost $20 million, and which was one-fourth depreciated, was destroyed by e. The right to use a building was acquired with a seven-year lease agreement present value of lease f. $100 million of bonds were retired at maturity. in 2018. g. $10 million par value of common stock was sold for $30 million, and $20 million of preferred stock was sold at par. h. Shareholders were paid cash dividends of $10 million. Required 2. Prepare the statement of cash flows. Present cash flows from operating activities by the direct method. Enter your answers in millions (i.e., 10,000,000 should be entered as 10). Amounts to be deducted should be indicated with a minus sign.) NATIONAL INTERCABLE COMPANY Statement of Cash Flows For year ended December 31, 2018 ($ in millions) Cash flows from operating activities Cash inflows. $ 245 From customers From investment revenue Cash outflows: (118) (51) (18) To suppliers of goods To employees For bond interest For insurance For income taxes (23) Net cash flows from operating activities Cash flows from investing activities 37 Sale of long-term investment Sale of building parts 25 Net cash flows from investing activities 27 Net cash flows from investing activities Cash flows from financing activities 27 Retirement of bonds payable Sale of common stock Sale of preferred stock Payment of cash dividends Payment on lease liability 100) 30 20 (10) Net cash flows from financing activities (65) Net increase in cash Cash balance, January 1 Cash balance, December 31 Noncash investing and financing activities: 0 Acquired equipment