Option #2: Consolidated Cash Flow Statement Using the Assignment Option 2 spread

Question

Option #2: Consolidated Cash Flow Statement Using the Assignment Option 2 spreadsheet (linked at the bottom of this page), review the income statement, balance sheet, and retained earnings information to prepare the consolidated cash flow statement. Required: Prepare the consolidated cash flow statement for Push Corporation. Follow instructions from the worksheet carefully. Use formulas to enter amounts and data. Show details of your calculations and processes. Explain each journal entry or why one was omitted. Do not hard code numbers in the Excel worksheet.

Explanation / Answer

Consolidated statement of cashflows Cashflows from operating activities: Consolidated income 300000 Noncash expenses,revenues,losses and gains included in income:   Depreciaton 100000 Gain on sale of land -50000 Changes in operating assets and liabilities Increase in acct receivable -50000 Increase in inventory -25000 Increase in acct payable 25000 0 Net cash provided by operating activities (a) 300000 Cashflows from investing activities: Acquisition of equipment -200000 Sale of land 100000 Net cash used in investing activities (b) -100000 Cashflows from investing activities: Dividend paid To parent shareholder -100000 Net cash used in financing activities © -100000 Net increase in cash (a)+(b)+© 100000 Cash at the beginning of the year 150000 Cash at the end of the year 250000

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.