Need to create a statement of CFs (indirect method). Need to use change in balances (YoY), Additional info (page 2) and figure out the dividend paid to do so

Below is the income Statement and Comparative Balance Sheet for ABC Company for the year ended December 31, 2017. In addition, use the additional information below and prepare a Statement of Cash Flows using the indirect method for the year ended December 31, 2017 using Spredsheet given ABC Company Income Statement For Year Ended December 31, 2017 (in U.S. Dollars) Sales COGS Gross profit Depreciation expense Other expenses Total operating expenses Other gains Loss on sale of equipment Income before taxes Income taxes expense Net income 582,500 285,000 297,500 20,750 132,400 153,150 (5,125) 139,225 24,250 114,975 Page 2 of 2 ABC Company Comparative Balance Sheet For Year Ended December 31, 2013 (In U.S. Dollars) 2017 2016 Assets Cash Accounts receivable Merchandise inventory Prepaid expenses Equipment Accum. Depreciation-Equipment Total assets 49,800 65,810 275,656 1,250 157,500 (36,625) 513,391 73,500 50,625 251,800 1,875 108,000 (46,000) 439,800 Liabilities and Equity Accounts payable Short-term notes payable Long-term notes payable Common stock, $5 par value Paid-in capital in excess of par, common stock Retained earnings Total liabilities and equity 53,141 10,000 65,000 162,750 37,500 185,000 513,391 114,675 6,000 48,750 150,250 120,125 439,800 Additional Information: a) 2,500 shares of common stock was issued at $20 par value; b) A dividend was paid during the year and debited to retained earnings: c) Long term notes payable of $50,125 matured and was paid; d) New equipment that cost $96,375 was purchased for $30,000 cash and the balance with a long term note; e) Cash proceeds from the sale of equipment was $11,625 Forten Company Statement of Cash Flows (Indirect) For Year Ended December 31, 2013 Operating activities Net Income Loss on sale of equipment Depreciation expense Change in accounts receivable Change in merchandise inventory Change in prepaid expenses Change in accounts payable Cash flow provided/used from operating activites 114,975 0 0 0 0 0 0 114,975 Show as positive Show as positive Increase in receivables Increase in Merchandise Decrease in prepaids Cash used to pay accouts payable Investing activities Proceeds from sale of equipment Cash used to purchase equipment Cash flow provided/used from investing activities Given - See note e Given - see noted Financing activities Proceeds from short-term notes payable Principal reduction of long-term notes payable Issued 2,500 shares of common stock $20 Payment of dividends Cash flow provided/used from financing activities Accounts payable increased Given - See note Given - See note a Need to calculate 0 Needs to equal the change in cash Net cash increase/decrease Beg. Cash End. Cash 201 Change 114.975 73,500 49,800 -23,700 Should equal 23,700