please complete the worksheet provided in the pictures. complete in excel like shown above.

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