Please answer A & B & Do Statement of Cash Flows

& if you can do any of the math with explanations on excel.

Thanks :)

4. Investments that cost $35,200 were sold during the year. 5. There were no write-offs of uncollectible accounts during the year. Sarasota's 2017 Income statement is as follows. Sales revenue $948,400 fgoods sold 603.600 Less: Cost Gross profit 344,800 Less: Operating expenses (includes depreciation expense and bad debt expense) 247,900 Income from operations 96,900 Other revenues and expenses sale of investments $15,000 Gain o Loss on sale of equipment (3,000 12,000 Income before taxes 108,900 Income taxes 45,300 $63,600 Net income (a) Compute net cash provided by operating activities under the direct method. (Enter negative amounts using elther a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) Net cash flow from operating activities (b) Prepare a statement of cash flows using the indirect method. (Show amounts that decrease cash flow with eithera - sign e.g. -15,000 or in parenthesis e.g. (15,000).) SARASOTA COMPANY Statement Cash Flows Adjustments to reconale net income to Adjustments to reconcile net income to 4 Comparative balance sheet accounts of Sarasota Company are presented below SARASOTA COMPANY COMPARATIVE BALANCE SHEET ACCOUNTS AS OF DECEMBER 31 Debit Balances 2017 2016 Cash $69,400 $51,400 Accounts Receivable 153,600 129,600 Inventory 74,500 61,600 Debt investments (available-for-sale) 55,500 85,100 Equipment 70,500 47,800 Buildings 146,400 146,400 39.600 Land 24,800 $609,500 $546,700 Totals Credit Balances $10,000 $7,900 Allowance for Doubtful Accounts Accumulated Depreciation-Equipment 20,900 14,000 Accumulated Depreciation-Buildings 37,200 27,900 Accounts Payable 66,200 59,500 Income Taxes Payable 12,000 10,000 Long-Term Notes Payable 62,000 70,000 Common Stock 310,000 260,000 97,400 Retained Earnings 91,200 $546,700 $609,500 Totals Additional data 1. Equipment that cost $10,000 and was 60% depreciated was sold in 2017 2. Cash dividends were declared and paid during the year 3. Common stock was issued in exchange for land