i need the cash flow worksheet completed along with the statement of cash flow - please show all of your work and formulas

Brady Goat Farm Inc Cash Flow Worksheet 31-Dec-17 12/31/2017 12/31/2016 Change Operating Investing Financing NonCash Cash 225,000.00 400,000.00 Accounts Receivable 375,000.00 250,000.00 Change in AR Change in Allowance for Doubtful Accounts Inventory 17,000.00 24,000.00 Buildings Equipment Vehicles 800,000.00 500,000.00 85,000.00 1,000,000.00 400,000.00 70,000.00 Accumulated Depreciation (750,000.00) (700,000.00) Customer List 90,000.00 100,000.00 Total Assets 1,342,000.00 1,544,000.00 Accounts Payable Accrued Expenses Line of Credit 425,000.00 45,000.00 190,000.00 415,000.00 200,000.00 100,000.00 Notes Payable Deferred Taxes 600,000.00 14,000.00 575,000.00 10,000.00 Common Stock Retained Earnings 1,000.00 67,000.00 1,000.00 243,000.00 Net Income Dividends Total Liabilities & Equity 1,342,000.00 1,544,000.00 Check Change in Cash: $ $ $ $ Net Operating Activity Net Investing Activity Net Financing Activity Net Non-Cash Facts: Tom Brady Goat Farm had the following transactions in 2017: Change in Cash: $ Inventory 17,000.00 24,000.00 Buildings Equipment Vehicles 800,000.00 500,000.00 85,000.00 1,000,000.00 400,000.00 70,000.00 Accumulated Depreciation (750,000.00) (700,000.00) Customer List 90,000.00 100,000.00 Total Assets 1,342,000.00 1,544,000.00 Accounts Payable Accrued Expenses Line of Credit 425,000.00 45,000.00 190,000.00 415,000.00 200,000.00 100,000.00 Notes Payable Deferred Taxes 600,000.00 14,000.00 575,000.00 10,000.00 Common Stock Retained Earnings 1,000.00 67,000.00 1,000.00 243,000.00 Net Income Dividends Total Liabilities & Equity 1,342,000.00 1,544,000.00 Check Change in Cash: $ $ $ $ $ Net Operating Activity Net Investing Activity Net Financing Activity Net Non-Cash $ $ $ Facts: Tom Brady Goat Farm had the following transactions in 2017: Change in Cash: Change in O, IF Net Income of $15,600 Paid out Dividends of $191,600 Check: Purchased $100,000 of new equipment through 100% financing Purchased $15,000 new vehicle with cash Had depreciation of $250,000 Had amortizatoin of $10,000 (customer list) Sold a building originally purchased for $200,000 with a book value of $0 for $45,000 Increased it's allowance for doubtful accounts by $25,000 Increased it's allowance for doubtful accounts by $25,000 Brady Goat Farm Inc Statement of Cash Flows Year Ending December 31, 2017 Cash Flows From Operating Activities Net Income Adjustments to reconcile net income to net cash used by operating activities: Depreciation Amortization Gain on Sale of Property Plant and Equipment Allowance for Doubtful Accounts (Increase) Decrease in Current Assets: Accounts Receivable Inventory Increase (Decrease) in current liabilities Accounts Payable Deferred Taxes Accrued Expenses Net Cash Used or Provided by Operating Activities: Cash Flows From Investing Activities Proceeds from Sale of Property Plant and Equipment Purchase of Property Plant and Equipment Net Cash Used or Provided by Investing Activities Cash Flows From Financing Activities Proceeds from Line of Credit Repayments of Notes Payable Dividends Paid Net Cash Used or Provided by Financing Activities Net Increase or Decrease in Cash Beginning Cash Balance 400,000 Ending Cash Balance $ 400,000 Noncash Investing and Financing Activities Purchase of Property Plant and Equipment with Financing Disposition of Fully Depreciated Property and Equipment