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
Textbook Question
Chapter 11, Problem 59PSB
Using a Spreadsheet to Prepare a Statement of
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.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Instructions: 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).…
. 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.
The company uses the indirect method to prepare the statement of cash flows and it is expected that this should be able to provide the needed clarity required by the owners.
The owners have asked each student from your accounting course to assist with the needed clarification and have put forward the following financial information
Maple Group Ltd
Comparative Balance Sheet
December 31, 2020 and 2019
2020
2019
Increase/(Decrease)
Assets
Cash and cash equivalent
?
?
?
Accounts Receivable
87,550
?
1,550
Inventories
93,900
98,540
?
Fixed Assets, net
160,400
?
49,900
Total Assets
373,350
316,890
56,460
Liabilities
Accounts payable
?
?
950
Accrued liabilities
22,850
24,940
?…
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
- Using a Spreadsheet to Prepare a Statement of Cash Flows Jane Bahr, a controller of Endicott & Thurston, prepared the following balance sheets at the end of 2019 and 2018: 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.arrow_forwardThe company uses the indirect method to prepare the statement of cash flows and it is expected that this should be able to provide the needed clarity required by the owners. The owners have asked each student from your accounting course to assist with the needed clarification and have put forward the following financial information Maple Group Ltd Comparative Balance Sheet December 31, 2020 and 2019 2020 2019 Increase/(Decrease) Assets Cash and cash equivalent ? ? ? Accounts Receivable 87,550 ? 1,550 Inventories 93,900 98,540 ? Fixed Assets, net 160,400 ? 49,900 Total Assets 373,350 316,890 56,460 Liabilities Accounts payable ? ? 950 Accrued liabilities 22,850 24,940 ?…arrow_forwardRequirements: How can the owners use the cash flow information or what can the statement of cash flows helps the owners to do? Reconstruct the company’s comparative balance sheet for 2019/2020 using the above information 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 2020 using the indirect method using the information above.arrow_forward
- The company uses the indirect method to prepare the statement of cash flows and it is expected that this should be able to provide the needed clarity required by the owners. The owners have asked each student from your accounting course to assist with the needed clarification and have put forward the following financial information Maple Group Ltd Comparative Balance Sheet December 31, 2020 and 2019 2020 2019 Increase/(Decrease) Assets Cash and cash equivalent ? ? ? Accounts Receivable 87,550 ? 1,550 Inventories 93,900 98,540 ? Fixed Assets, net 160,400 ? 49,900 Total Assets 373,350 316,890 56,460 Liabilities Accounts payable ? ? 950 Accrued liabilities 22,850 24,940 ?…arrow_forwardAsk expert: Answer the following financial reports for the month of January 2020 while referring to the attached pictures and using tabulation table: a) Income Statement b) Balance Sheet c) Statement of Financial Position d) Statement of Cash Flowarrow_forwarda) Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Please show all dollar amount to thousands of dollars. b) On another sheet, create a statement of cash flows for 2019. Do not enter any numbers directly on this sheet. All formulas should be linked directly to the source on previous worksheets.arrow_forward
- Prepare Cash Flow from Operating Activities for the year ended 30 June 2022 for using the direct method (Hint: Please list the cashflow related to receipt from customers, payment to suppliers of inventory, and payment to suppliers of service/labor. You shall also remove depreciation expense from operation expenses in your calculation).arrow_forwardUse the following excerpts from Algona Companys financial statements to determine cash received from customers in 2018.arrow_forwardUse 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_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_forwardPlease answer all of the following questions and kindly type it out if possible so I can easily understand. I have attached two pictures with the information to complete the questions. Thank You :) As part of your analysis, you are required to investigate WITCO’s cash flows. (a)Using the financial statements and additional notes provided, calculate the following for 2020: iv. Cash Flow from assets v. Cash Flow to creditors vi. Cash Flow to stockholders (b) Prepare WITCO’s Statement of Cash Flow for the year ended December 31, 2020. (c)What is the purpose and importanceof the Cash Flow Statement?arrow_forwardProblem 11-2A (Algo) Classify items and prepare the statement of cash flows (LO11-1, 11-3, 11-4, 11-5) Seth Erkenbeck, a recent college graduate, has just completed the basic format to be used in preparing the statement of cash flows (indirect method) for ATM Software Developers. All amounts are in thousands (000s). ATM SOFTWARE DEVELOPERS Statement of Cash Flows For the Year Ended December 31, 2024 Cash Flows from Operating Activities Net income Adjustments to reconcile net income to net cash flows from operating activities: Net cash flows from operating activities Cash Flows from Investing Activities Net cash flows from investing activities Cash Flows from Financing Activities Net cash flows from financing activities Net increase (decrease) in cash Cash at the beginning of the period Cash at the end of the period Listed below in random order are line items to be included in the statement of cash flows. Cash received from the sale of land (no gain or loss) Issuance of common stock…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 LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License