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

Numbers and questions on word document provided.

Excel template provided.

Complete "Problem 14-10 Prepare a Statement of Cash Flows; Free Cash Flow" in chapter 14 of Managerial Accounting. Present your responses in an Excel spreadsheet. 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 - + $ - + $ - 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 - $ - $ - $ - 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 $ - $ $ - 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 $ $ $ $ $ $ $ $ - Prepare a statement of Cash Flows... Before doing this, you must figure the following activities first... 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 $ - $ $ - $ - $ - 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 $ $ $ - Financing Activities: Issuance of Bonds Payable Issuance of Common Stock Cash Dividends Net Cash provided by Financing Activities $ $ $ $ - - Joyner Company Statement of Cash Flows For Year 2 Description Operating Activities: Net Income - + - - + $ - $ - + $ - - Net decrease in cash Cash balance, beginning of year Cash balance,end of year $ $ $ - $ - $ $ - ** 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... $ $ - 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 $ 120,000.00 $ 30,000.00 + Credits = $ 132,000.00 Credits = $ 132,000.00 Credits = $ 42,000.00 1 - Step 2 - + $ 120,000.00 + $ 30,000.00 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 $ 80,000.00 Inventory $ 50,000.00 Prepaid Expenses $ 7,000.00 Current Liabilities Accounts Payable Accrued Liabilities Income Taxes Payable 1 - Step 3 - $ 60,000.00 $ 3,000.00 $ 10,000.00 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 $ $ $ $ $ $ $ $ 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 Prepare a statement of Cash Flows... Before doing this, you must figure the following activities first... 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 $ $ (150,000.00) (40,000.00) Liabilities and Stockholder's Equity Bonds Payable Common Stock $ $ 120,000.00 30,000.00 Property, Plant, and Equipment: Formula = Beginning balance + Debits - Credits = Ending balance Beginning Balance + Debits Credits $ 400,000.00 + Debits $ 40,000.00 Debits Debits = = = = $ $ $ Ending Balance 510,000.00 510,000.00 150,000.00 Retained Earnings: Formula = Beginning balance - Debits + Credits = Ending balance Beginning Balance Debits + Credits $ 83,000.00 Debits + 56000 Debits Debits = = = = $ $ $ Ending Balance 124,000.00 124,000.00 15,000.00 Joyner Company Statement of Cash Flows For Year 2 Description Operating Activities: 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 $ $ $ $ $ $ $ $ Investing Activities: Proceeds from sale of equipment Loan to Hymans Company Additions to Plant and Equipment Net Cash used in Investing Activities $ $ $ Financing Activities: Issuance of Bonds Payable Issuance of Common Stock Cash Dividends Net Cash provided by Financing 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 18,000.00 (40,000.00) (150,000.00) $ (172,000.00) $ 135,000.00 120,000.00 30,000.00 (15,000.00) - + $ 400,000.00 - + $ 40,000.00 + $ 83,000.00 - $ 56,000.00 Net decrease in cash Cash balance, beginning of year Cash balance,end of year $ $ $ (17,000.00) 21,000.00 4,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 $ $ $ 150,000.00 15,000.00 $ $ 20,000.00 165,000.00 (145,000.00) Company has purchased equipments and free cash flow is negative and also has given loan to Hymans company and has not isuued sufficient common stock and bonds payable resulting in to onsumption cash from beginning cash balance