Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
6th Edition
ISBN: 9780134486857
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter C, Problem 45BP
To determine
Prepare statement of cash flows using the spreadsheet in indirect method.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Using a spreadsheet to prepare the statement of cash flows—indirect method
The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value in 2018.
Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for $0. The cost and accumulated depreciation of the disposed asset was $13,600. There were no sales of land, no retirement of common stock, and no treasury stock transactions. Assume plant asset and land acquisitions were for cash.
Using a spreadsheet to prepare the statement of cash flows—indirect method
The 2018 comparative balance sheet and income statement of Appleton Group, Inc. follow. Appleton disposed of a plant asset at book value during 2018.
Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for $0. The cost and accumulated depredation of the disposed asset was $11,600. There were no sales of land, no retirement of common stock, and no treasury stock transactions. Assume plant asset and land acquisitions were for cash.
Use the information provided below to prepare the Cash Flow Statement of Chelsea Limited for the year ended 31 December 2021 using the answer template provided (see images)
Additional information: (See images)¦ Selling and administrative expenses include depreciation as follows:Depreciation on buildings R96 000Depreciation on plant and machinery R160 000¦ There were purchases but no disposals of property, plant and equipment for the financial year ended 31 December2021.¦ Total dividends for the year ended 31 December 2021 and 31 December 2020 amounted toR288 000 and R388 000 respectively.¦ Inventories on 31 December 2019 amounted to R560 000.¦ All purchases and sales of inventories were on credit.¦ The number of shares in issue was 400 000.¦ Credit terms from creditors are 90 days.
Chapter C Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Ch. C - Identify each item as operating (O), investing...Ch. C - Identify each item as operating (O), investing...Ch. C - Identify each item as operating (O), investing...Ch. C - Identify each item as operating (O), investing...Ch. C - Identify each item as operating (O), investing...Ch. C - Prob. 6TICh. C - Prob. 7TICh. C - Prob. 8TICh. C - Muench Inc.s accountant has partially completed...Ch. C - Prob. 1QC
Ch. C - Prob. 2QCCh. C - Prob. 3QCCh. C - Prob. 4QCCh. C - Prob. 5QCCh. C - Prob. 6QCCh. C - Prob. 7QCCh. C - Prob. 8QCCh. C - Prob. 9QCCh. C - Prob. 10QCCh. C - Prob. 1RQCh. C - Prob. 2RQCh. C - Prob. 3RQCh. C - Prob. 4RQCh. C - Prob. 5RQCh. C - Prob. 6RQCh. C - Prob. 7RQCh. C - If a company experienced a loss on disposal of...Ch. C - Prob. 9RQCh. C - Prob. 10RQCh. C - Prob. 11RQCh. C - Prob. 12RQCh. C - Prob. 13RQCh. C - Prob. 14RQCh. C - How does the direct method differ from the...Ch. C - Prob. 16RQCh. C - Prob. 1SECh. C - Prob. 2SECh. C - Prob. 3SECh. C - DVR Equipment, Inc. reported the following data...Ch. C - Prob. 5SECh. C - Prob. 6SECh. C - Prob. 7SECh. C - Prob. 8SECh. C - Prob. 9SECh. C - Julie Lopez Company expects the following for...Ch. C - Prob. 11SECh. C - Prob. 12SECh. C - Prob. 13SECh. C - Prob. 14SECh. C - Prob. 15SECh. C - Prob. 16ECh. C - Prob. 17ECh. C - Prob. 18ECh. C - Prob. 19ECh. C - Prob. 20ECh. C - The income statement of Boost Plus, Inc. follows:...Ch. C - Prob. 22ECh. C - Rouse Exercise Equipment, Inc. reported the...Ch. C - Use the Rouse Exercise Equipment data in Exercise...Ch. C - Prob. 25ECh. C - Prob. 26ECh. C - Prob. 27ECh. C - Prob. 28ECh. C - Prob. 29ECh. C - Prob. 30ECh. C - Prob. 31ECh. C - American Rare Coins (ARC) was formed on January 1,...Ch. C - Prob. 33APCh. C - Prob. 34APCh. C - Prob. 35APCh. C - Boundary Rare Coins (BRC) was formed on January 1,...Ch. C - Use the Rolling Hills, Inc. data from Problem...Ch. C - Prob. 38APCh. C - Classic Rare Coins (CRC) was formed on January 1,...Ch. C - Accountants for Benson, Inc. have assembled the...Ch. C - Prob. 41BPCh. C - Prob. 42BPCh. C - Prob. 43BPCh. C - Use the Sweet Valley data from Problem P14-41B....Ch. C - Prob. 45BPCh. C - Prob. 47PCh. C - Before you begin this assignment, review the Tying...Ch. C - Prob. 1DCCh. C - Prob. 1EICh. C - Details about a companys cash flows appear in a...
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
- Prepare the spreadsheet for the 2024 statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for $0. The cost of accumulated depreciation of the disposed as it was $12,600. There were no sales of land no retirement of common stock and no treasury stock transactions. Assume plant assets and land acquisitions were for cash. arrow_forwardThe net income for Sunland Co. for 2022 was $282,900. For 2022, depreciation on plant assets was $68,300, and the company incurred a loss on disposal of plant assets of $27,600.Compute net cash provided by operating activities under the indirect method, assuming there were no other changes in the company’s accounts.arrow_forwardThe net income for Crane Co. for 2022 was $305,000. For 2022, depreciation on plant assets was $65,200, and the company incurred a loss on disposal of plant assets of $27,600. Compute net cash provided by operating activities under the indirect method, assuming there were no other changes in the company's accounts. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).) Cash Flows from Operating Activities Net Income Crane Co. Statement of Cash Flows-Indirect Method For the Year Ended December 31, 2022 Adjustments to reconcile net income to Depreciation Expense Loss on Disposal of Plant Assets v $ 65200 27,600 $ $ 305000 397800arrow_forward
- The net income for Swifty Corporation for 2022 was $260,100. For 2022, depreciation on plant assets was $67,800, and the company incurred a loss on disposal of plant assets of $27,100. Compute net cash provided by operating activities under the indirect method, assuming there were no other changes in the company's accounts. (Show amounts that decrease cash flow with either a-sign eg.-15,000 or in parenthesis e.g. (15,000)) Ⓒarrow_forwardThe net income for Mongan Co. for 2022 was $280,000. For 2022, depreciation on plant assets was $70,000, and the company incurred a loss on disposal of plant assets of $28,000. Compute net cash provided by operating activities under the indirect method, assuming there were no other changes in the company's accounts. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).) Mongan Co. Statement of Cash Flows-Indirect Method Adjustments to reconcile net income to $ $ $arrow_forwardof Take me to the text Squash Incorporated had net income for 2023 of $382,000. Included on the income statement was a loss on sale of equipment of $4,900, a gain on sale of investments of $16,300, depreciation of $7,300, loss on retirement of debt of $10,600, and interest of $3,200. Calculate the net cash provided (used) by operating activities using the indirect method Assume that the balances of current assets (except cash) and current liabilities remain the same as last year. Do not enter dollar signs or commas in the input boxes. Use the negative sign for a decrease in cash. Net cash provided (used) by operating activities $-385400 Check *arrow_forward
- Each of the following items must be considered in preparing a statement of cash flows (indirect method) for Turbulent Indigo Inc. for the year ended December 31, 2025. State where each item is to be shown in the statement of cash flows, if at all. a. Plant assets that had cost $20,000 6 years before and were being depreciated on a straight-line basis over 10 years with no estimated scrap value were sold for $5,300. b. C. d. e. f. g. h. Items During the year, 10,000 shares of common stock with a stated value of $10 a share were issued for $43 a share. Uncollectible accounts receivable in the amount of $27,000 were written off against Allowance for Doubtful Accounts. The company sustained a net loss for the year of $50,000. Depreciation amounted to $22,000, and a gain of $9,000 was realized on the sale of land for $39,000 cash. A 3-month U.S. Treasury bill was purchased for $100,000. The company uses a cash and cash equivalent basis for its cash flow statement. Patent amortization for…arrow_forwardPreparing the statement of cash flows—indirect method with non-cash transactions The 2018 income statement and comparative balance sheet of Sweet Valley Inc follow: Additionally, Sweet Valley purchased land of $20,900 by financing it 100% with long-term notes payable during 2018. During the year, there were no sales of land, no retirements of stock, and no treasury stock transactions. A plant asset was disposed of for $0. The cost and the accumulated depreciation of the disposed asset was $13,240. Plant asset was acquired for cash. Requirements Prepare the 2018 statement of cash flows, formatting operating activities by the indirect method. How will what you learned in this problem help you evaluate an investment?arrow_forwardPrepare the company's statement of cash flows indirect method for the year ended December 31, 2024. Assume investments are purchased with cash. (Use a minus sign or parentheses for amounts that result in a decrease in cash. It a box is not used in the statement leave the box empty; do not select a label or enter a zero.) More info Superior calculated the following amounts for 2024: • Acquisition value of plant assets, $89,000. • Payment of dividends, $102,000. • Payment of long-term notes payable, $3,000. • Cash receipt from issuance of common stock. $15.000. Superior Exercise disposed of plant assets at book value. The cost and accumulated depreciation of the disposed asset was $43 500. No cash was received upon disposalarrow_forward
- Fearless Flying Squirrels Company collected the following data in its accounting records in 2022: From the income statement: Depreciation expense $1,100 Loss on sale of equipment 3,100 From the comparative balance sheet: Beginning balance, equipment $12,500 Ending balance, equipment 7,900 Beginning balance, accumulated depreciation 1,900 Ending balance, accumulated depreciation 2,300 No new equipment was purchased during the year. Required: What was the cash in-flow from the sale of equipment in 2022?arrow_forwardOn July 15, 2021, M.W. Morgan Distribution sold land for $45.5 million that it had purchased in 2016 for $35.0 million.Required: What would be the amount(s) related to the sale that Morgan would report in its statement of cash flows for the year ended December 31, 2021, using the direct method? The indirect method?arrow_forwardCondensed financial data of Nash Company for 2020 and 2019 are presented below. NASH COMPANY COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2020 AND 2019 2020 2019 Cash $1,780 $1,130 Receivables 1,740 1,290 Inventory 1,610 1,870 Plant assets 1,930 1,710 Accumulated depreciation (1,210 ) (1,150 ) Long-term investments (held-to-maturity) 1,290 1,440 $7.140 $6.290 $900 Accounts payable Accrued liabilities $1,180 190 240 Bonds payable 1,410 1,590 Common stock 1,920 1,690 Retained earnings 2,440 1,870 $7.140 $6,290 NASH COMPANY INCOMESTATEMENT FOR THE YEAR ENDED DECEMBER 31, 2020 Sales revenue $6,880 Cost of goods sold 4,650 Gross margin 2,230 Selling and administrative expenses 940 Income from operations 1,290 Other revenues and gains Gain on sale of investments 80 Income before tax 1,370 Income tax expense 540 Net income 830 Cash dividends 260 Income retained in business $570arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License