Cornerstones of Financial Accounting
4th Edition
ISBN: 9781337690881
Author: Jay Rich, Jeff Jones
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 11, Problem 59PSA
Using a Spreadsheet to Prepare a Statement of
Jane Bahr, a controller of Endicott & Thurston, prepared the following
Required:
1. Using a spreadsheet, prepare a statement of cash flows for 2019. Assume Endicott & Thurston use the indirect method.
2. CONCEPTUAL CONNECTEON Discuss whether Endicott & Thurston appear to have matched the timing of inflows and outflows of cash.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
a. Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Try to duplicate the formatting exactly.
b. On another worksheet, create a statement of cash flows for 2020. Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous worksheets.
C. Using Excel's outlining feature, create an outline on the statement of cash flows that, when collapsed, shows only the subtotals for each section.
d. Suppose that sales were $425,000 in 2020 rather than $412,500. What is the 2020 net income and retained earnings?
e. Undo the changes from part d, and change the tax rate to 20%. What is the 2020 net income and retained earnings?
. ABC company had the following transactions during the month of April 2020. They would like you,
their accountant, to prepare a cash flow statement. Before preparing the statement, you first need to
determine whether the items below results in a cash inflow or outflow in the statement of cash flows.
Second, you are required to determine whether the transaction is an operating, investing, or financing
activity by placing an √ in the appropriate columns.
Reconstruct the company’s comparative balance sheet for 2020/2021 using the information in line with your first name initial and compute and show the missing figures to include the appropriate sign as a positive or negative figure.
Prepare a complete statement of cash flows for 2021 using the indirect method using the information in line with your first name initial
Chapter 11 Solutions
Cornerstones of Financial Accounting
Ch. 11 - Prob. 1DQCh. 11 - Prob. 2DQCh. 11 - How is a statement of cash flows different from an...Ch. 11 - Prob. 4DQCh. 11 - What are the three categories into which inflows...Ch. 11 - Prob. 6DQCh. 11 - Why are direct exchanges of long-term debt for...Ch. 11 - Describe the relationship between changes in cash...Ch. 11 - What are two ways to report a companys net cash...Ch. 11 - Why are depreciation, depletion, and amortization...
Ch. 11 - Prob. 11DQCh. 11 - Prob. 12DQCh. 11 - What does an increase in inventory imply? How...Ch. 11 - Prob. 14DQCh. 11 - Prob. 15DQCh. 11 - Prob. 16DQCh. 11 - Prob. 17DQCh. 11 - What balance sheet account changes might you...Ch. 11 - Prob. 19DQCh. 11 - Prob. 20DQCh. 11 - Prob. 21DQCh. 11 - Prob. 22DQCh. 11 - Prob. 23DQCh. 11 - Prob. 24DQCh. 11 - Which of the following is not a use of the...Ch. 11 - Which of the following would be classified as a...Ch. 11 - Prob. 3MCQCh. 11 - Which of the following is an example of a cash...Ch. 11 - Prob. 5MCQCh. 11 - Which of the following statements is true? a. Net...Ch. 11 - Mullinix Inc. reported the following information:...Ch. 11 - Which item is added to net income when computing...Ch. 11 - Refer to the information for Cornett Company...Ch. 11 - Prob. 10MCQCh. 11 - Chasse Building Supply Inc. reported net cash...Ch. 11 - Smoltz Company reported the following information...Ch. 11 - Prob. 13MCQCh. 11 - Classification of Cash Flows Stanfield Inc....Ch. 11 - Classification of Cash Flows Patel Company...Ch. 11 - Prob. 16CECh. 11 - Analyzing Changes in Balance Sheet Accounts Refer...Ch. 11 - Prob. 18CECh. 11 - Prob. 19CECh. 11 - Determining Net Cash Flow from Investing...Ch. 11 - Prob. 21CECh. 11 - Prob. 22CECh. 11 - Cash Receipts from Customers Singleton Inc. had...Ch. 11 - Prob. 24CECh. 11 - Prob. 25CECh. 11 - Prob. 26BECh. 11 - Prob. 27BECh. 11 - Analyzing Balance Sheet Accounts A review of the...Ch. 11 - Prob. 29BECh. 11 - Prob. 30BECh. 11 - Prob. 31BECh. 11 - Prob. 32BECh. 11 - Prob. 33BECh. 11 - Classification of Cash Flows A review of the...Ch. 11 - Classification of Cash Flows The following are...Ch. 11 - Analyzing Changes in Balance Sheet Accounts A...Ch. 11 - Analyzing the Accounts Casey Company uses a...Ch. 11 - Analyzing the Accounts The controller for Summit...Ch. 11 - Reporting Net Cash Flow from Operating Activities...Ch. 11 - Prob. 40ECh. 11 - Determining Cash Flows from Investing Activities...Ch. 11 - Determining Cash Flows 1from Investing Activities...Ch. 11 - Determining Cash Flows from Financing Activities...Ch. 11 - Prob. 44ECh. 11 - Partial Statement of Cash Flows Service Company...Ch. 11 - Prob. 46ECh. 11 - Prob. 47ECh. 11 - Preparing Net Cash Flows from Operating...Ch. 11 - Preparing a Statement of Cash Flows-Direct Method...Ch. 11 - Preparing a Statement of Cash Flows-Direct Method...Ch. 11 - Prob. 51ECh. 11 - Prob. 52PSACh. 11 - Prob. 53PSACh. 11 - Classification of Cash Flows Rolling Meadows...Ch. 11 - Prob. 55PSACh. 11 - Preparing a Statement of Cash Flows Monon Cable...Ch. 11 - Prob. 57PSACh. 11 - Preparing Net Cash Flows from Operating...Ch. 11 - Using a Spreadsheet to Prepare a Statement of Cash...Ch. 11 - Prob. 52PSBCh. 11 - Prob. 53PSBCh. 11 - Prob. 54PSBCh. 11 - Preparing a Statement of Cash Flows Volusia...Ch. 11 - Prob. 56PSBCh. 11 - Prob. 57PSBCh. 11 - Prob. 58PSBCh. 11 - Using a Spreadsheet to Prepare a Statement of Cash...Ch. 11 - Prob. 60.1CCh. 11 - Prob. 60.2CCh. 11 - Prob. 60.3CCh. 11 - Prob. 61.1CCh. 11 - Profitability Declines and the Statement of Cash...Ch. 11 - Prob. 61.3CCh. 11 - Prob. 61.4CCh. 11 - Prob. 62.1CCh. 11 - Prob. 62.2CCh. 11 - Prob. 62.3CCh. 11 - Income, Cash Flow, and Future Losses On January L...Ch. 11 - Income, Cash Flow, and Future Losses On January L...Ch. 11 - Income, Cash Flow, and Future Losses On January L...Ch. 11 - Prob. 63.4CCh. 11 - Researching Accounting Standards: Dissenting Views...Ch. 11 - Prob. 64.2CCh. 11 - Prob. 65.1CCh. 11 - Prob. 65.2CCh. 11 - Prob. 65.3CCh. 11 - Prob. 65.4CCh. 11 - Prob. 65.5CCh. 11 - Prob. 65.6CCh. 11 - Prob. 65.7CCh. 11 - Prob. 65.8CCh. 11 - Prob. 66.1CCh. 11 - Prob. 66.2CCh. 11 - Prob. 66.3CCh. 11 - Prob. 66.4CCh. 11 - Comparative Analysis: Under Armour, Inc., versus...Ch. 11 - Prob. 67.1CCh. 11 - CONTINUING PROBLEM: FRONT ROW ENTERTAINMENT The...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Use a spreadsheet and the following financial information from Mineola Companys financial statements to build a template that automatically calculates the net operating cash flow. It should be suitable for use in preparing the operating section of the statement of cash flows (indirect method) for the year 2018.arrow_forwardUsing a Spreadsheet to Prepare a Statement of Cash Flows Fleet Limousine Service Inc. began operations in late March 2019. At the end of 2019, the following balance sheet was prepared for Fleet. Required: 1. Using a spreadsheet, prepare a statement of cash flows for 2019. Assume Fleet Limousine uses the indirect method. 2. CONCEPTUAL CONNECTION Discuss whether Fleet Limousine appeals to have matched the timing of inflows and outflows of cash.arrow_forwardPreparing a Statement of Cash Flows Volusia Company reported the following comparative balance sheets for 2019: Required: Prepare a statement of cash flows for Volusia using the indirect method to compute net cash flow from operating activities.arrow_forward
- Use the following excerpts from OpenAir Companys financial information to prepare a statement of cash flows (indirect method) for the year 2018.arrow_forwardInstructions: Using the following adjusted trial balance, complete the following for 2019: Use the Jaymie Corporation example in Chapter 3 for guidance. In the absence of other guidance, assume the circumstances for your project are similar to the example shown. 1) Income statement 2) Statement of shareholders' equity 3) Balance sheet 4) In place of completing a full statement of cash flows, review the Statement of Cash Flows within Example 3.9 in the text and advise an error (or at least a questionable treatment) of an item presented by the authors that you have discovered. Create the financial statements using Excel and submit for grading via the assignment in Blackboard. Add your answer to item 4) within the same Excel workbook clearly identified as the response to item 4).…arrow_forwardPlease help me to solve this problemarrow_forward
- Please donot provide solution in image format and provide solution in step by step format and fast solution. You have the following data available for Al Maha Company, which is the income statement at the end of 2022and the statement of financial position (balance sheet) at the end of 2021 and 2022. You are required to:1- Preparing a statement of retained earnings at the end of 20222- A list of cash inflows and outflows at the end of 20223 - A statement of cash flows according to operating, investment and financing activity at the end of 20224 - Free Cash Flow Calculation (from Assets) Free cash flow = operating cash flow - change in net fixed assets - change in net working capital (current assets - current liabilities) Balance sheet at the end of 2021 and 2022 2022 2021 Cash 24000 21000 Receivables 45000 39000 Inventory 30000 27000 Net Fixed Assets = Total - Accumulated Depreciation = (40,000 - 18,000 =) 2021 20000 22000 ( 42000 - 22000 = ) 2022 Total assets…arrow_forwardRequired:(a) Prepare Vanguard low Statement for the year ended 31 December 2019 with the following classifications using the direct method: (i) Cash flows from operations;(ii) Cash flows from investing activities;(iii) Cash flows from financing activities. (b) Discuss the importance of analysing the cash flow statement. (c) Explain why it is possible to have a negative cash flow from operations but a positive net income. Give an example of such a scenario.arrow_forwardBelow are several transactions for Meyers Corporation for 2021.Required: 1. For each transaction, determine the amount of cash flows (indicate inflows with a “+” and outflows with a “−”). If cash is involved in the transaction, indicate whether Meyers should classify it as operating, investing, or financing in a statement of cash flows. Enter N/A if the question is not applicable to the statement. 2. Calculate net cash flows for the year. 3. Assuming the balance of cash on January 1, 2021, equals $5,400, calculate the balance of cash on December 31, 2021.arrow_forward
- Prepare the following financial reports for the month of January 2020: a) Income Statement b) Balance Sheet c) Statement of Financial Position d) Statement of Cash Flows See the tabulation table.arrow_forwardMatch the words to the definitions. Solvency Accounts Receivable Balance Sheet Noncurrent Assets Income Statement Retained Earnings Noncurrent Liabilities. Liquidity Current Assets Cash Flow Statement ✓ [Choose ] A forecast of the amount and timing of future cash inflows and outflows over some period of time. A summary of the revenues and expenses of a business over a given period of time. When net worth is greater than zero, or assets are greater than liabilities on the balance sheet. The ability to meet the day-to-day cash needs of the firm. Profits that are not paid out in dividends but are reinvested in the firm itself. Summarizes a firm's financial position at a given point in time and lists the firm's assets, liabilities, and net worth. Debts that others owe the business, usually arising from previous credit sales. Something the firms owns or uses that will not turn into cash within the next accounting period. Either cash or an items that will become cash in the next accounting…arrow_forwardfor Morston, Inc. have assembled the following data for the year icon to view the current accounts.) (Click the icon to view the transaction data.) ston's statement of cash flows using the indirect method. Include an accompanying schedule of non-cash investing and financing activities. .. he statement one section at a time, beginning with the cash flows from operating activities. (Use a m ox empty, do not select a label or enter a zero.) Data table Morston, Inc. Statement of Cash Flows Year Ended December 31, 2024 lows from Operating Activities: come 70,500 stments to Reconcile Net Income to Net Cash vided by (Used for) Operating Activities: Depreciation Expense Gain on Sale of Building Decrease in Accounts Receivable Increase in Merchandise Inventory Incroaco in Accounts Payabla Data table et asi Net Hel O Transaction Data for 2024: Issuance of common stock for cash Depreciation expense Purchase of equipment with cash Acquisition of land by issuing long-term notes payable Book value…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License