can i get some help on how to put the answer to the problem into this spreadsheet

D F 12/11/2016 679,400 5,980,000 2,452.000 3,526.000 64400 506100 1,011.000 520,000 380,000 (244, 4001 3.376,800 Cash Flow Worksheet, 2015 12/012075 4 Assets | Th. 6. Accounts receivable (net) 547,400 7 Inventores 982,100 8. Investments 240,000 9 Land 10 Equipment 680,000 11 Accumulated Depreciation 200,400 12 Total Assets 2.329,200 13 14 Uabilities 15 Accounts payable 748,400 16 Accrued expenses payable 90,800 17 Dividends payable 6.4400 16 Total Liabilities 825,600 19 20 Stockholder's Equity 21 Common Stock (SiO par 22,000 22 Paid in capital in excess of par 192,000 23 Retained earnings 1,879,600 Sheet1 Sheet2 Sheets Income Statement, FYE 2016 Sales Cost of goods sold Gross profit Operating Expenses Depreciation expense 44,000 Other operating expense 3,100,000 Total operating expenses Incore from operations Other income and expenses Loss on sale of investments Income before income taxes Income tax expense Net Income 3,144.000 384.000 164,000) 320,000 102.00 217200 771.100 63,400 8.800 844.000 Canace Products, Inc Cash Flow Worksheet 2016 2015 Dr. 2 56,000 400,000 2,068,800 Asset Cash Accounts receivable (net) 529400 547,400 643,400 566,800 TH 643400 B C D G H 2015 Dr. K 2016 Cr 32,000 192,000 1,879,600 2,103,600 56,000 408,000 2,058,800 2,532,800 Assets Cash Accounts receivable (net) Inventories Investments 679,400 547 400 982,800 240,000 543.400 566,800 1,011,000 2,929 200 3,376,800 Land Stockholder's Equity . Common Stock (510 parl 2 Paid in capital in excess of par Retained earnings Total Stockholder's Equtiy 5 6 Total Liabilities & Stihidr. 7 8 Cash Flows: 9 From Operating Activities: 0 31 12 33 36 35 36 + Equipment Accumulated Depreciation Total Assets 680,000 200,400 2,929,200 520,000 880,000 1244 400) 2.375,00 Liabilities: Accounts payable Accrued expenses payable Dividends payable Total Labities 748 400 70 ROO 6400 825,600 771,800 17.400 8.800 844,000 38 From Investing Activities: 39 40 41 Sheet1 Sheet2 Stockholder's Equity Common Stock 510 pari Paid in capital in excess of par Retained earnings Total Stockholder's Equtly 32,000 192,000 1,879,600 2,103,000 56,000 408,000 2,068,800 2,532,300 Sheet Chile ding 643400 B D F Cash Flows: From Operating Activities: G Accumulated Depreciation Total Assets H (200/4000 2,929,200 1244 4001 3,376,800 Liabilities: Accounts payable Accrued expenses payable Dividends payable Total Liabilities 748,400 70,800 6,400 825,000 771 800 63,400 3,800 846,000 -> From Investing Activities: Stockholder's Equity Common Stock (S10 par) Paid in capital in excess of par Retained earnings Total Stockholder's Equtly 12.000 192,000 1,879,600 2,103,600 56,000 408.000 2008 800 2.532 800 Total Liabilities & Stahlde. Eq. 2,929 200 3.376 900 0 1 2 3 4 From Financing Activities: 5 16 37 18 29 From Operating Activities: PR 16-4A Statement of cash flows-direct method OBJ. 3 The comparative balance sheet of Canace Products Inc. for December 31, 2016 and 2045, is as follows: Dec. 31, 20Y6 Dec 31, 2015 Assets Cash $ 643,400 $ 679,400 Accounts receivable (net) 566,800 547,400 Inventories 1,011,000 982,800 Investments 0 240,000 Land 520,000 0 Equipment. 880,000 680,000 Accumulated depreciation (244,400) (200,400) Total assets $3,376,800 $2,929,200 Liabilities and Stockholders' Equity Accounts payable... $ 771,800 $ 748,400 Accrued expenses payable. 63,400 70,800 Dividends payable... 8,800 6,400 Common stock, $2 par.. 56,000 32,000 Paid-in capital: Excess of issue price over par-common stock 408,000 192,000 Retained earnings... 2,068,800 1,879,600 Total liabilities and stockholders' equity. $3,376,800 $2,929,200 The income statement for the year ended December 31, 20Y6, is as follows: $5,980,000 2,452,000 $3,528,000 Sales .. Cost of merchandise sold Gross profit.... Operating expenses: Depreciation expense Other operating expenses Total operating expenses $ 44,000 3,100,000 3,144,000 (Continued) 6 Statement of Cash Flows $ 384,000 .... Operating income......... Other expense: Loss on sale of investments .. (64,000) $ 320,000 Income before income tax Income tax expense 102,800 Net income $ 217,200 Additional data obtained from an examination of the accounts in the ledger for 20Y6 are as follows: a. Equipment and land were acquired for cash. b. There were no disposals of equipment during the year. c. The investments were sold for $176,000 cash. d. The common stock was issued for cash. e. There was a $28,000 debit to Retained Earnings for cash dividends declared. Instructions Prepare a statement of cash flows, using the direct method of presenting cash flows from operating activities