Complete "Problem 14-10Prepare a Statement of Cash Flows; Free Cash Flow" in chapter 14 of Managerial Accounting. Present your responses in an Excel spreadsheet.

Complete the attached spreadsheet and answer the questions listed on the assignment

Week 4 Assignment Template Name: ALL YELLOW HIGHLIGHTED CELLS REQUIRE DATA INPUT Date: 11/4/2016 DO NOT KEY OVER FORMULAS Class: AMP-415 Financial Decision Mak Professor: Number/Problem 1 - Step 1 Net cash provided by operating activies... The following equation can be applied to the Accumulated Depreciation account to compute the depreciation to add back to net income... Formula = Beginning balance - Debits + Credits = Ending balance Beginning Balance Debits + Credits = Ending Balance $ $ + Credits = $ Credits = $ Credits = $ 1 - Step 2 $ - $ - $ $ - - The net cash provided by operating activities is computed as follows... (note: the gain on sale of equipment is subtracted from net income)... Description Net Income $ 56,000.00 Adjustments to convert net income to cash basis: Depreciation Increase in Accounts Receivable Increase in Inventory Decrease in Prepaid Expenses Increase in Accounts Payable Decrease in Accrued Liabilities Increase in Income Taxes Payable Gain on Sale of Equipment Net Cash provided by Operating Activities 2 - + + $ - Follow the guidelines from Exhibit 14-2 to analyze the changes in non-cash balance sheet accounts that impact net income... Show as positive or negative as applicable to the results. Description Increase in Account Balance Decrease in Account Balance Current Assets Accounts Receivable $ Inventory $ Prepaid Expenses $ Current Liabilities Accounts Payable Accrued Liabilities Income Taxes Payable 1 - Step 3 - $ $ $ $ $ $ $ $ Prepare a statement of Cash Flows... Before doing this, you must figure the following activities first... 42,000.00 (80,000.00) (50,000.00) 7,000.00 60,000.00 (10,000.00) 3,000.00 (8,000.00) $ $ (36,000.00) 20,000.00 Investing and Financing Activites: The guidelines from Exhibit 14-3 can be used to analyze the changes in non-cash balance sheet that impact investing and financing cash flows...Show as positive or negative as applicable to the results. Description Non-Current Assets Property, Plant, and Equipment Loan to Hymans Company Increase in Account Balance Decrease in Account Balance $ $ - Liabilities and Stockholder's Equity Bonds Payable Common Stock $ $ - Property, Plant, and Equipment: Formula = Beginning balance + Debits - Credits = Ending balance Beginning Balance + Debits Credits $ + Debits $ Debits Debits - Retained Earnings: Formula = Beginning balance - Debits + Credits = Ending balance Beginning Balance Debits + Credits $ Debits + 0 Debits Debits = = = = $ $ $ Ending Balance = = = = $ $ $ - Ending Balance $ 56,000.00 Adjustments to convert net income to cash basis: Depreciation Increase in Accounts Receivable Increase in Inventory Decrease in Prepaid Expenses Increase in Accounts Payable Decrease in Accrued Liabilities Increase in Income Taxes Payable Gain on Sale of Equipment Net Cash provided by Operating Activities Investing Activities: Proceeds from sale of equipment Loan to Hymans Company Additions to Plant and Equipment Net Cash used in Investing Activities $ $ $ $ $ $ $ $ $ $ $ 42,000.00 (80,000.00) (50,000.00) 7,000.00 60,000.00 (10,000.00) 3,000.00 (8,000.00) $ $ (36,000.00) 20,000.00 $ $ - - Joyner Company Statement of Cash Flows For Year 2 Description Operating Activities: Net Income - + - - + $ - $ - + $ - - Financing Activities: Issuance of Bonds Payable Issuance of Common Stock Cash Dividends Net Cash provided by Financing Activities $ $ $ $ Net decrease in cash Cash balance, beginning of year Cash balance,end of year - $ $ $ 20,000.00 20,000.00 $ 20,000.00 $ $ 20,000.00 ** be sure in input properly - if negative number, put in as a negative number 3 Free cash flow computation... Description Net Cash provided by Operating Activities Capital expenditures Dividends Free Cash Flow 4 Provide your answer here... $ $