Horngren's Financial & Managerial Accounting, Student Value Edition (5th Edition)
5th Edition
ISBN: 9780133851267
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 14, Problem 14.38AP
To determine
Statement of cash flow – Spreadsheet method
Statement of cash flows: It is one of the financial statement that shows the cash and cash equivalents of a company for a particular period. It determines the net changes in cash through reporting the sources and uses of cash due to the operating, investing, and financing activities of a company.
Spreadsheet method:
- The statement of cash flows also can be prepared as a spreadsheet.
- The spreadsheet for the statement of cash flow starts with the beginning balance and ends with the ending balances of accounts of the balances sheet.
- The spread includes two extra columns between the ending and beginning balance columns. One column is for debit and other for credit balance.
To 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 14 Solutions
Horngren's Financial & Managerial Accounting, Student Value Edition (5th Edition)
Ch. 14 - The purposes of the statement of cash flows are to...Ch. 14 - The main categories of cash flow activities are a....Ch. 14 - Operating activities are most closely related to...Ch. 14 - Which item does not appear on a statement of cash...Ch. 14 - Leather Shop earned net income of 57,000 after...Ch. 14 - The Plant Assets account and Accumulated...Ch. 14 - Mountain Water Corp. issued common stock of 28,000...Ch. 14 - Prob. 8QCCh. 14 - Prob. 9AQCCh. 14 - If accrued liabilities increased during the year,...
Ch. 14 - Prob. 1RQCh. 14 - How does the statement of cash flows help users of...Ch. 14 - Describe the three basic types of cash flow...Ch. 14 - What types of transactions are reported in the...Ch. 14 - Prob. 5RQCh. 14 - Prob. 6RQCh. 14 - Explain why depreciation expense, depletion...Ch. 14 - Prob. 8RQCh. 14 - If current assets other than cash increase, what...Ch. 14 - If current liabilities increase, what is the...Ch. 14 - Prob. 11RQCh. 14 - Prob. 12RQCh. 14 - Prob. 13RQCh. 14 - Prob. 14RQCh. 14 - Prob. 15ARQCh. 14 - Prob. 16BRQCh. 14 - Describing the purposes of the statement of cash...Ch. 14 - Prob. 14.2SECh. 14 - Classifying items on the indirect statement of...Ch. 14 - Computing cash flows from operating...Ch. 14 - Prob. 14.5SECh. 14 - Prob. 14.6SECh. 14 - Prob. 14.7SECh. 14 - Prob. 14.8SECh. 14 - Prob. 14.9SECh. 14 - Prob. 14.10SECh. 14 - Preparing a statement of cash flows using the...Ch. 14 - Prob. 14.12SECh. 14 - Preparing the direct method statement of cash...Ch. 14 - Prob. 14.14SECh. 14 - Prob. 14.15SECh. 14 - Classifying cash flow items Consider the following...Ch. 14 - Prob. 14.17ECh. 14 - Prob. 14.18ECh. 14 - Prob. 14.19ECh. 14 - Prob. 14.20ECh. 14 - Prob. 14.21ECh. 14 - Prob. 14.22ECh. 14 - Prob. 14.23ECh. 14 - Prob. 14.24ECh. 14 - Prob. 14.25ECh. 14 - Prob. 14.26ECh. 14 - Prob. 14.27ECh. 14 - Prob. 14.28ECh. 14 - Prob. 14.29ECh. 14 - Prob. 14.30ECh. 14 - Using a spreadsheet to prepare the statement of...Ch. 14 - Prob. 14.32APCh. 14 - Prob. 14.33APCh. 14 - Prob. 14.34APCh. 14 - Prob. 14.35APCh. 14 - Preparing the statement of cash flows----direct...Ch. 14 - Prob. 14.37APCh. 14 - Prob. 14.38APCh. 14 - Prob. 14.39BPCh. 14 - Prob. 14.40BPCh. 14 - Prob. 14.41BPCh. 14 - Prob. 14.42BPCh. 14 - Prob. 14.43BPCh. 14 - Prob. 14.44BPCh. 14 - Using a spreadsheet to prepare the statement of...Ch. 14 - Prob. 14.46CPCh. 14 - Prob. 14.1CTDCCh. 14 - Moss Exports is having a bad year. Net income is...Ch. 14 - Details about a company's cash flows appear in a...
Knowledge Booster
Similar questions
- of 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_forwardUse the following information from Dubuque Company's financial statements to prepare the operating activities section of the statement of cash flows (indirect method) for the year 2018: 2018 Income Statement Balance Sheets Sales Cost of Goods Sold Operating Expenses, other than depreciation expense Depreciation Expense Gain on Sale of Plant Assets $ 299,000 (135,000) (27,000) (17,000) 16,500 136,500 Net Income Dec. 31, 2018 $45,300 1,600 22,500 900 Accounts Receivable Inventory Accounts Payable Accrued Liabilities Accounts Receivable Inventory Accounts Payable Accrued Liabilities Dec. 31, 2017 $43,400 1,800 21,250 1,150 PLEASE NOTE: Use the account and term names exactly, as shown above and the accounts will be listed in the same order as shown in the textbook examples. All dollar amounts will be rounded to whole dollars using "$" and commas as needed (i.e. $12,345) and decreases will be shown with parentheses - $(12,345).arrow_forward2. Use the following excerpts from Fromera Company's financial information to prepare the operating section of the statement of cash flows (indirect method) for the year 2018. https://opentextbc.ca 2018 Financial Statement 299,000 135,000 Sales Cost of goods sold Operating expenses, other than depreciation expense Depreciation expense Gain on sale of plant assets 27,000 17,000 16,500 136,500 Net Income Dec. 31, 2017 43,400 1,800 21,250 1,150 Dec. 31, 2018 45,300 1,600 22,500 900 Accounts receivable Inventory Accounts payable Accrued liabilities 3. Using the data in No. 2, compute the following: a. Current cash debt coverage ratio b. Free Cash Flowarrow_forward
- Using the Exhibit below, assume that the depreciation expense on the Income Statement for the year was $38,000. When preparing the Statement of Cash Flow using the indirect method for the current year, which of the following statements would describe the proper presentation of depreciation expense on the Cash flow from operating activities section? EXHIBIT Increase (Decrease) Net Income (loss) $XXX Adjustments to reconcile net income to net cash flow from operating activities: Depreciation of fixed assets XXX Losses on disposal of assets XXX Gains on disposal of assets (XXX) Changes in current operating assets and liabilities:…arrow_forwardCleopatra's Boutique Inc reported net income of $73,000 for 2022. Included in the income statement were depreciation expense of $7,000 and again on disposal of plant assets of $2,500 Cleopatra's comparative balance sheets whos the following bainaces 12/01/21 12/31/22 Accounts receivable $17,000 $21.000 Accounts payable 6,000 2.200 Calculate net cash provided by operating activities for Cleopatra's Boutique, incarrow_forwardThe net income for Adcock Co. for 2011 was $280000. For 2011, depreciation on plant asset was $70000, and the company incurred a loss on sale of plant asset of $12000. Compute net cash provided by operating activities under the indirect method?arrow_forward
- Cemptex Corporation prepares its statement of cash flows using the indirect method to report operating activities. Net income for the 2016 fiscal year was $624,000. Depreciation and amortization expense of $87,000 was included with operating expenses in the income statement. The following information describes the changes in current assets and liabilities other than cash: Required: Prepare the operating activities section of the 2016 statement of cash flows.arrow_forwardBroussard Company reported net income of $3.5 millionin 2017. Depreciation for the year was $520,000, accountsreceivable increased $500,000, and accounts payableincreased $300,000. Compute net cash flow from operatingactivities using the indirect method.arrow_forwardREQUIRED Study the statement of cash flows of Mantis Limited for the year ended 31 December 2021 and answer the following questions: Calculate the following for the year ended 31 December 2021: Depreciation Dividends paid Of what significance is this statement of cash flows to the shareholders of Mantis Limited? Comment on the following: Cash flows from operating activities (R181 800) 1.3.2. Increase in inventory (R808 000) Increase in receivables (R606 000) Interest paid (R80 800) Cash flows from investing activities (R2 343 200) INFORMATION MANTIS LIMITED STATEMENT OF CASH FLOWS FOR THE YEAR ENDED 31 DECEMBER 2021 R Cash flows from operating activities (181 800) Operating profit 979 700 Depreciation ? Profit before working capital changes ? Working capital changes (808 000) Increase in inventory (808 000) Increase in receivables…arrow_forward
- Use the information provided below to prepare the Cash Flow Statement of Alto Limited for the year ended 31 December 2022. INFORMATION The following amounts were obtained from the Statement of Comprehensive Income for the year ended 31 December 2022 and Statement of Financial Position of Alto Limited as at 31 December 2022 and 31 December 2021: Sales Cost of sales Depreciation Operating profit Interest expense Company tax for the year Property, plant and equipment (carrying value) Long-term investments Inventories Accounts receivable Prepaid expenses Cash and cash equivalents Ordinary share capital (All shares issued at R10 each) Retained earnings Non-current liabilities Accounts payable Accrued expenses Dividends payable Company tax payable 31 Dec 2022 R 11 000 000 6 500 000 750 000 1 650 000 450 000 400 000 6 250 000 350 000 2 150 000 1 700 000 200 000 500 000 3 100 000 3 000 000 3 600 000 1 100 000 100 000 200 000 50 000 31 Dec 2021 R Note: ■ Dividends paid and recommended during…arrow_forwardUsing the financial statements and additional information below, prepare a cash flow statement for Papa Ltd for the year ended 31st December 2018 using the indirect method of calculating operating cash flow and write a brief comment on the cash flow for the period. Papa Ltd Statement of Profit or Loss Account for the year ended 31st December 2018 GHC Revenue 540,000 Cost of sales (155,000) Gross profit 385,000 Investment income – interest received 15,000 Loss on disposal of equipment (18,000) Depreciation (94,000) Administrative and selling expenses (25,000) Operating profit before interest 263,000 Interest expense (10,000) Profit before taxation 253,000 Taxation (56,000) Profit after tax 197,000 Statement of financial position as at 31st December 2018 2017 GHC GHC Non-current assets Vehicle at cost 180,000 150,000 Accumulated depreciation (137,000)…arrow_forwardOn its January 1, 2016, balance sheet, Calvin Company reported equipment of $60,000 and accumulated depreciation of $20,000. During 2016, Calvin sold equipment with an original cost of $5,000. Selected information from Calvin's 2016 statement of cash flows follows: Net income $20,000 Depreciation expense on equipment 2,000 Gain on sale of equipment 600 Proceeds from sale of equipment 1,500 Purchase of equipment 18,000 Required:Compute the amount of equipment and accumulated depreciation that should appear on Calvin's December 31, 2016, balance sheet.arrow_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 LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher: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:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning