Cash Flow Horizontal Analysis Ratio Analysis Exercise 12 The following information is available for Umbrella Corporation for the year ended December 31, 2013 Collection Acquisition Proceeds the Issue of cor Depreciate Redemptior Payment of Profit Purchase of 40,000 15,000 27.000 33,000 25,000 24,000 14,000 30,000 40.000 In addition, the following information is available from the comparative balance sheet for Umbrella the end of 2020 20215 2021 Cash 102.000 Accounts rc 20,000 Prepaid inst 17 000 Total currer 119.000 2020 14.000 15.000 11.00 42.00 Accounts Salaries pas Total carrer 25.000 4.000 29,000 19.000 7000 26.000 Instructions Prepare Umbrella's cash flow statement for the year ended December 31, 2021. ssing the indirect method Solution 12 (1-27 min.) UMBRELLA CORPORATION Cash Flow Statement Year Ended December 31, 2021 Operating Profit Adjustments to reconcile profit to net cash provided (used by operating a Depreciation Increase in accounts receivable Increase in prepaid insurance Increase in accounts payable Decrease in saluries payable Net cash provided by operating activities Investing a Collection of long-term loan Proceeds from the redemption of long-term investment Purchase of equipment Net cash pr Financing Issue of common shares Redemption of bonds Payment of Net cash 0 Net Increas Cash January Cast Dece! 0 Cash Flow Horizontal Analysis Ratio Analysis Exercise 12 The following information is available for Umbrella Corporation for the year ended December 31, 2013 Collection Acquisition Proceeds the Issue of cor Depreciate Redemptior Payment of Profit Purchase of 40,000 15,000 27.000 33,000 25,000 24,000 14,000 30,000 40.000 In addition, the following information is available from the comparative balance sheet for Umbrella the end of 2020 20215 2021 Cash 102.000 Accounts rc 20,000 Prepaid inst 17 000 Total currer 119.000 2020 14.000 15.000 11.00 42.00 Accounts Salaries pas Total carrer 25.000 4.000 29,000 19.000 7000 26.000 Instructions Prepare Umbrella's cash flow statement for the year ended December 31, 2021. ssing the indirect method Solution 12 (1-27 min.) UMBRELLA CORPORATION Cash Flow Statement Year Ended December 31, 2021 Operating Profit Adjustments to reconcile profit to net cash provided (used by operating a Depreciation Increase in accounts receivable Increase in prepaid insurance Increase in accounts payable Decrease in saluries payable Net cash provided by operating activities Investing a Collection of long-term loan Proceeds from the redemption of long-term investment Purchase of equipment Net cash pr Financing Issue of common shares Redemption of bonds Payment of Net cash 0 Net Increas Cash January Cast Dece! 0