BC ABC @ 000 Module 05 Practice Problem Cash Flows Draw Page Layout Formulas Data Review...

Transcribed Image Text:

BC ABC @ 000 Module 05 Practice Problem Cash Flows Draw Page Layout Formulas Data Review View Automate Tell me Calibri (Body) 11 V ab V Wrap Text v General B I U v V V A V H Merge & Center V $ % 9 orkbooks? Your recent changes were saved. Do you want to continue working where you left off? fx C D E F G H J K .00 <10 .00-0 L V v Cell Conditional Format Formatting as Table Styles M N Using the indirect method, prepare the statement of cash flows for Cash Flow Practice Problem for the year ended 20XX. Numbers go in shaded areas. Use Excel formulas for all math operations. Cash Flow Practice Problem Statement of Cash Flows-Indirect Method For the Year Ended 20XX Cash Flows from Operating Activities: Net Income Reconciliation of net income to net cash flows: Depreciation Amortization Gain on sale of investments Changes in Current Assets and Current Liabilities: Decrease in A/R Increase in Inventory Increase in PPD Expenses Decrease in A/P Increase in Accrued Expenses Decrease in Taxes Payable Net Cash Flows from Operating Activities Cash Flows from Investing Activities: Cash received from sale of: Investments Land Less: Cash Paid for construction on building Net Cash Flows from Investing Activities Cash Flows from Financing Activities: Cash received from issuing mortgage note payable Less: Cash paid for dividends Net Cash Flow Used for Financing Activities Increases in cash Cash at the Beginning of the Year Cash at the End of the Year Schedule of Non-Cash Investing and Financing Activities: Issued common stock to retire bonds payable Co Depreciation De Amortization the Gain Gai The net total operating Net Inv Lan Cas net total investing Cas Cas Cas Net total financing Cas Incr Cas Com Com you Exar Flow Practice ssibility: Investigate + BC ABC @ 000 Module 05 Practice Problem Cash Flows Draw Page Layout Formulas Data Review View Automate Tell me Calibri (Body) 11 V ab V Wrap Text v General B I U v V V A V H Merge & Center V $ % 9 orkbooks? Your recent changes were saved. Do you want to continue working where you left off? fx C D E F G H J K .00 <10 .00-0 L V v Cell Conditional Format Formatting as Table Styles M N Using the indirect method, prepare the statement of cash flows for Cash Flow Practice Problem for the year ended 20XX. Numbers go in shaded areas. Use Excel formulas for all math operations. Cash Flow Practice Problem Statement of Cash Flows-Indirect Method For the Year Ended 20XX Cash Flows from Operating Activities: Net Income Reconciliation of net income to net cash flows: Depreciation Amortization Gain on sale of investments Changes in Current Assets and Current Liabilities: Decrease in A/R Increase in Inventory Increase in PPD Expenses Decrease in A/P Increase in Accrued Expenses Decrease in Taxes Payable Net Cash Flows from Operating Activities Cash Flows from Investing Activities: Cash received from sale of: Investments Land Less: Cash Paid for construction on building Net Cash Flows from Investing Activities Cash Flows from Financing Activities: Cash received from issuing mortgage note payable Less: Cash paid for dividends Net Cash Flow Used for Financing Activities Increases in cash Cash at the Beginning of the Year Cash at the End of the Year Schedule of Non-Cash Investing and Financing Activities: Issued common stock to retire bonds payable Co Depreciation De Amortization the Gain Gai The net total operating Net Inv Lan Cas net total investing Cas Cas Cas Net total financing Cas Incr Cas Com Com you Exar Flow Practice ssibility: Investigate +