Preparing a Statement of Cash Flows using a Worksheet
Not what you're looking for?
Smith Resort: Completing a Cash Flow Worksheet.
Please see the attachment for full details. The Problem Data can be found on the 3rd tab. The Cash Flow Worksheet is on the 2nd tab.
To complete a Cash Flow Statement you must have comparative Balance sheets, the Income Statement, and some additional information to assist in the analysis.
The Income Statement and additional information are on the Problem Data tab.
The Balance Sheet amounts are on the Cash Flow Worksheet.
To complete the worksheet:
*Enter analysis entries in Column D and F.
*Label each analysis entry with a letter (a, b, c, d, ...). Put the letter labeling each analysis entry in columns C and E.
*(You are to enter formulas in the 12/31/14 balance column (Column G). For the formula you must take the beginning 12/31/13 balance and add or subtract the analysis entries in columns D and F.
The correct 12/31/14 balance is shown in the Column labeled Check Figure (Column H). After entering all of the analysis entries (in Columns D and F) the balance in the 12/31/14 Balance column (where you entered the formulas) should equal the number in Check Figure column if the entries in the analysis columns are correct. If the 12/31/14 Balance column does not equal the Check Figure, either an analysis entry is missing or the amount is incorrect.
Sum each of the analysis columns. The balances should agree.
Part II: Provide a short written analysis.
Purchase this Solution
Solution Summary
This solution illustrates how to prepare a statement of cash flows using a cash flows worksheet and how to explain why net income differs from cash flows from operating activities.
Purchase this Solution
Free BrainMass Quizzes
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.