Concept explainers
Prepare a statement of cash flows; direct method
• LO21–3, LO21–8
The comparative balance sheets for 2018 and 2017 and the income statement for 2018 are given below for Arduous Company. Additional information from Arduous’s accounting records is provided also.
Additional information from the accounting records:
a. Investment revenue includes Arduous Company’s $6 million share of the net income of Demur Company, an equity method investee.
b. Treasury bills were sold during 2018 at a gain of $2 million. Arduous Company classifies its investments in Treasury bills as cash equivalents.
c. A machine originally costing $70 million that was one-half
d. Temporary differences between pretax accounting income and taxable income caused the
e. The
f. Land costing $46 million was acquired by issuing $23 million cash and a 15%, four-year, $23 million note payable to the seller.
g. The right to use a building was acquired with a 15-year lease agreement; present value of lease payments, $82 million. Annual lease payments of $7 million are paid at the beginning of each year starting January 1, 2018.
h. $60 million of bonds were retired at maturity.
i. In February, Arduous issued a 4% stock dividend (4 million shares). The market price of the $5 par value common stock was $7.50 per share at that time.
j. In April, 1 million shares of common stock were repurchased as
Required:
Prepare the statement of cash flows of Arduous Company for the year ended December 31, 2018. Present cash flows from operating activities by the direct method. (A reconciliation schedule is not required.)
Statement of cash flows: This statement reports all the cash transactions which are responsible for inflow and outflow of cash and result of these transactions is reported as ending balance of cash at the end of reported period.
To Prepare: The statement of cash flows of Company A.
Explanation of Solution
Spreadsheet: The spreadsheet is a supplementary device which helps to prepare the adjusting entries and the statement of cash flows easier. The spreadsheet is a working tool of the accountant but it is not a permanent accounting record.
The spreadsheet, for the statement of cash flow analysis, is shown below.
Company A | ||||
Spreadsheet for the Statement of Cash Flows | ||||
Amount in Millions | ||||
Particulars | December 31,2017 Amount ($) | Changes | December 31,2018 Amount ($) | |
Debit ($) | Credit ($) | |||
Assets | ||||
Current Assets | ||||
Cash | $81 | (21) $28 | $109 | |
Accounts receivable | $194 | (1) $4 | $190 | |
Investment revenue receivable | $4 | (2) $2 | $6 | |
Inventory | $200 | (4) $5 | $205 | |
Prepaid insurance | $8 | (8) $4 | $4 | |
Long-term investment | $125 | (2) $6 (13) $25 | $156 | |
Land | $150 | (14) $46* | $196 | |
Buildings and equipment | $400 | (15) $82* | (10) $70 | $412 |
Less: Depreciation | ($120) | (10) $35 | (6) $12 | ($97) |
Patent | $32 | (7) $2 | $30 | |
Total current assets | $1,074 | $1,211 | ||
Liabilities and Stockholders’ Equity | ||||
Liabilities | ||||
Accounts payable | $65 | (4) $15 | $50 | |
Salaries payable | $11 | (5) $5 | $6 | |
Bond interest payable | $4 | (9) $4 | $8 | |
Income tax payable | $14 | (11) $2 | $12 | |
Deferred tax liability | $8 | (11) $3 | $11 | |
Notes payable | $0 | (14) $23* | $23 | |
Lease liability | $0 | (15) $7 | (15) $82* | $75 |
Bonds payable | $275 | (16) $60 | $215 | |
Less: Discount | ($25) | (9) $3 | ($22) | |
Stockholders’ equity | ||||
Common Stock | $410 | (17) $20 | $430 | |
Paid-in capital—excess of par | $85 | (17) $10 | $95 | |
Preferred stock | $0 | (18) $75 | $75 | |
Retained Earnings | $227 | (17) $30/ (19) $22 | (12) $67 | $242 |
Less: Treasury Stock | $0 | (20) $9 | ($9) | |
Total liabilities and stockholders’ equity | $1,074 | $1,211 | ||
Income Statement | ||||
Revenues | ||||
Sales revenue | (1) $410 | $410 | ||
Investment revenue | (2) $11 | $11 | ||
Gain on sale of treasury bills | (3) $2 | $2 | ||
Expenses | ||||
Cost of goods sold | (4) $180 | ($180) | ||
Salaries expense | (5) $73 | ($73) | ||
Depreciation expense | (6) $12 | ($12) | ||
Patent amortization expense | (7) $2 | ($2) | ||
Insurance expense | (8) $7 | ($7) | ||
Bond interest expense | (9) $28 | ($28) | ||
Loss on machine damage | (10) $18 | ($18) | ||
Income tax expense | (11) $36 | ($36) | ||
Net income | (12) $67 | $67 | ||
Statement of Cash Flows | ||||
Operating activities: | ||||
Cash Inflows: | ||||
From customers | (1) $414 | |||
From investment revenue | (2) $3 | |||
From sale of cash equivalents | (3) $2 | |||
Cash Outflows: | ||||
To suppliers of goods | (4) $200 | |||
To employees | (5) $78 | |||
For insurance | (8) $3 | |||
For bond interest | (9) $21 | |||
For income taxes | (11) $35 | |||
Net cash flows | $82 | |||
Investing activities: | ||||
Sale of machine components | (10) $17 | |||
Purchase of Long Term investment | (13) $25 | |||
Purchase of land | (14) $23 | |||
Net cash flows | ($31) | |||
Financing activities: | ||||
Payment on lease liability | (15) $7 | |||
Retirement of bonds payable | (16) $60 | |||
Sale of preferred stock | (18) $75 | |||
Payment of cash dividends | (19) $22 | |||
Purchase of treasury stock | (20) $9 | |||
Net cash flows | ($23) | |||
Net decrease in cash | (21) $28 | $28 | ||
Total | $1,313 | $1,313 |
Table (1)
Operating activities: Operating activities refer to the normal activities of a company to carry out the business. The examples for operating activities are purchase of inventory, payment of salary, sales, and others.
Investing activities: Investing activities refer to the activities carried out by a company for acquisition of long term assets. The examples for investing activities are purchase of equipment, long term investment, sale of land, and others.
Financing activities: Financing activities refer to the activities carried out by a company to mobilize funds to carry out the business activities. The examples for financing activities are purchase of bonds, issuance of common shares, and others.
The spreadsheet of Company A shows the analysis of cash flows in the reporting year 2018.
Company A | ||
Statement of Cash Flows | ||
For year ended December 31, 2018 | ||
Amount in Millions | ||
Particulars | Amount ($) | Amount ($) |
Operating activities: | ||
Cash Inflows: | ||
From customers | $414 | |
From investment revenue | $3 | |
From sale of cash equivalents | $2 | |
Cash Outflows: | ||
To suppliers of goods | ($200) | |
To employees | ($78) | |
For insurance | ($3) | |
For bond interest | ($21) | |
For income taxes | ($35) | |
Net cash flows from operating activities | $82 | |
Investing activities: | ||
Sale of machine components | $17 | |
Purchase of Long Term investment | ($25) | |
Purchase of land | ($23) | |
Net cash flows from investing activities | ($31) | |
Financing activities: | ||
Payment on lease liability | ($7) | |
Retirement of bonds payable | ($60) | |
Sale of preferred stock | $75 | |
Payment of cash dividends | ($22) | |
Purchase of treasury stock | ($9) | |
Net cash flows from financing activities | ($23) | |
Net decrease in cash | $28 | |
Cash balance, January 1, 2018 | $81 | |
Cash balance, December 31, 2018 | $109 |
Table (2)
The statement of cash flows of Company A, shows opening balance of cash flows for the reporting year 2018 as $81 million and the closing balance of cash as $109 million.
Note:
*Non Cash investing activity and financing activity:
- Company A acquired a building on 15 year lease for $82 million.
- Company A acquired a land for $46 million, by:
- Paying Cash of $23 million;
- Issuing 4-year note for $23 million.
Want to see more full solutions like this?
Chapter 21 Solutions
SPICELAND GEN CMB LL INTRM ACCTG; CNCT
- (Appendix 21.1) Operating Cash Flows Refer to the information for Lamberson Company in P21-6. Required: 1. Using the direct method, prepare the operating activities section of the 2019 statement of cash flows for Lamberson. 2. (Optional). If you completed P21-6 earlier, prepare the remaining portion of the statement of cash flows. (A separate schedule reconciling net income to cash provided by operating activities is not necessary.)arrow_forwardStatement of cash flowsdirect method applied to PR 131B The comparative balance sheet of Merrick Equipment Co. for Dec. 31, 20Y9 and 20Y8, is: Dec. 31, 20Y9 Dec. 31, 20Y8 Assets Cash 70,720 47,940 Accounts receivable (net) 207,230 188,190 Inventories 298,520 289,850 Investments 0 102,000 Land 295,800 0 Equipment 438,600 358,020 Accumulated depreciationequipment (99,110) (84,320) Total assets 1,211,760 901,680 Liabilities and Stockholders' Equity Accounts payable (merchandise creditors).................. 205,700 194,140 Accrued expenses payable (operating expenses) 30,600 26,860 Dividends payable 25,500 20,400 Common stock. 1 par 202,000 102,000 Paid-in capital: Excess of issue price over parcommon stock 354,000 204,000 Retained earnings 393,960 354,280 Total liabilities and stockholders' equity 1,211,760 901,680 The income statement for the year ended December 31,20Y9, is as fallow s: Sales 2,023,898 Cost of goods sold 1,245,476 Gross profit 778,422 Operating expenses: Depreciation expense 14,790 Other operating expenses 517,299 Total operating expenses 532,089 Operating income 246,333 Other expenses: Loss on sale of investments (10,200) Income before income tax 236,133 Income tax expense 94,453 Net income 141,680 Additional data obtained from an examination of the- accounts in the ledger for 20Y9 are as follows: A. Equipment and land were acquired for cash. B. There were no disposals of equipment during the year. C. The investments were sold for 91,800 cash. D. The common stock was issued for cash. E. There was a 102,000 debit to Retained Earnings for cash dividends declared. Instructions Prepare a statement of cash flows, using the direct method of presenting cash flows from operating activities.arrow_forwardRequired information Exercise 21-13 (Static) Identifying cash flows from investing activities and financing activities [LO21-5, 21-6] [The following information applies to the questions displayed below.] In preparation for developing its statement of cash flows for the year ended December 31, 2024, Rapid Pac, Incorporated, collected the following information: ($ in millions) Fair value of shares issued in a stock dividend $ 65 Payment for the early extinguishment of long-term bonds (book value: $97 million) 102 Proceeds from the sale of treasury stock (cost: $17 million) 22 Gain on sale of land 4 Proceeds from sale of land 12 Purchase of Microsoft common stock 160 Declaration of cash dividends 44 Distribution of cash dividends declared in 2023 40 Exercise 21-13 (Static) Part 1 Required: 1. In Rapid Pac’s statement of cash flows, what were net cash inflows (or outflows) from investing activities for 2024? Note: Cash outflows should be indicated with a…arrow_forward
- Problem 21-4 (Algo) Statement of cash flows; direct method [LO21-3, 21-8] The comparative balance sheets for 2021 and 2020 and the statement of income for 2021 are given below for Dux Company. Additional information from Dux's accounting records is provided also. DUX COMPANYComparative Balance SheetsDecember 31, 2021 and 2020($ in thousands) 2021 2020 Assets Cash $ 49 $ 24 Accounts receivable 46 53 Less: Allowance for uncollectible accounts (3 ) (2 ) Dividends receivable 3 2 Inventory 65 60 Long-term investment 21 18 Land 85 60 Buildings and equipment 273 290 Less: Accumulated depreciation (70 ) (90 ) $ 469 $ 415 Liabilities Accounts payable $ 35 $ 43 Salaries payable 3 7 Interest payable 7 2 Income tax payable 8 9 Notes payable 25 0 Bonds payable…arrow_forwardProblem 21-17 (Algo) Statement of cash flows; indirect method [LO21-4, 21-8] Comparative balance sheets for 2021 and 2020 and a statement of income for 2021 are given below for Metagrobolize Industries. Additional information from the accounting records of Metagrobolize also is provided. METAGROBOLIZE INDUSTRIESComparative Balance SheetsDecember 31, 2021 and 2020($ in thousands) 2021 2020 Assets Cash $ 405 $ 245 Accounts receivable 350 190 Inventory 500 275 Land 500 450 Building 900 900 Less: Accumulated depreciation (200 ) (180 ) Equipment 2,500 2,150 Less: Accumulated depreciation (325 ) (300 ) Patent 1,000 1,150 $ 5,630 $ 4,880 Liabilities Accounts payable $ 600 $ 400 Accrued liabilities 150 130 Lease liability—land 130 0 Shareholders' Equity Common stock…arrow_forwardExercise 21-27 (Algo) Statement of cash flows; direct method [LO21-3, 21-5, 21-6, 21-8] Comparative balance sheets for 2024 and 2023, a statement of income for 2024, and additional information from the accounting records of Red, Incorporated, are provided below: RED, INCORPORATED Comparative Balance Sheets December 31, 2024 and 2023 ($ in millions) 2024 2023 Assets Cash $ 26 $ 114 Accounts receivable 203 134 Prepaid insurance 11 6 Inventory 289 177 Buildings and equipment 384 352 Less: Accumulated depreciation (121) (242) $ 792 $ 541 Liabilities Accounts payable $ 90 $ 104 Accrued liabilities 10 15 Notes payable 52 0 Bonds payable 161 0 Shareholders’ Equity Common stock 402 402 Retained earnings 77 20 $ 792 $ 541 RED, INCORPORATED Statement of Income For Year Ended December 31, 2024 ($ in millions) Revenues Sales revenue $ 2,010 Expenses Cost of goods sold $ 1,439 Depreciation expense 41…arrow_forward
- #202 Which of the following is true concerning the statement of cash flows? Question 202 options: a When pension expense exceeds cash funding, the difference is deducted from investing activities on the statement of cash flows. b Under GAAP, the purchase of land by issuing stock will be shown as a cash outflow under investing activities and a cash inflow under financing activities. c The FASB requires companies to classify all income taxes paid as operating cash outflows. d All of these are true concerning the statement of cash flows.arrow_forwardAppendix 2PR 13-4B Statement of cash flows—direct method The comparative balance sheet of Martinez Inc. for December 31, 20Y4 and 20Y3, is as follows:Dec. 31, 20Y4Dec. 31, 20Y3AssetsCash .....................................................$ 661,920$ 683,100Accounts receivable (net) .................................. 992,640 914,400Inventories ...............................................1,394,4001,363,800Investments ..............................................0432,000Land ..................................................... 960,0000Equipment................................................1,224,000 984,000Accumulated depreciation—equipment ....................(481,500)(368,400)Total assets ...............................................$4,751,460$4,008,900Liabilities and Stockholders’ EquityAccounts payable (merchandise creditors) ..................$1,080,000$ 966,600Accrued expenses payable (operating expenses) ............67,80079,200Dividends…arrow_forwardQuestion 21 In preparing Titan Inc.'s statement of cash flows for the year ended December 31, 2021, the following amounts were available: Collect note receivable $615,000 Issue bonds payable 639,000 Purchase treasury stock 300,000 What amount should be reported on Titan, Inc.'s statement of cash flows for investing activities? $339,000 $315,000 $615,000 $1,254,000arrow_forward
- Exercise 12-12 (Algo) Indirect: Preparing statement of cash flows LO P2, P3, A1 Skip to question [The following information applies to the questions displayed below.] The following financial statements and additional information are reported. IKIBAN INCORPORATED Comparative Balance Sheets At June 30 2021 2020 Assets Cash $ 97,900 $ 60,000 Accounts receivable, net 89,000 67,000 Inventory 79,800 110,500 Prepaid expenses 6,000 8,600 Total current assets 272,700 246,100 Equipment 140,000 131,000 Accumulated depreciation—Equipment (35,000) (17,000) Total assets $ 377,700 $ 360,100 Liabilities and Equity Accounts payable $ 41,000 $ 54,000 Wages payable 7,600 18,200 Income taxes payable 5,000 7,000 Total current liabilities 53,600 79,200 Notes payable (long term) 46,000 76,000 Total liabilities 99,600 155,200 Equity Common stock, $5 par value 252,000 176,000 Retained earnings 26,100 28,900 Total liabilities and equity $ 377,700 $…arrow_forwardPB12. LO 16.5 The following shows excerpts from financial infomation relating to Stanwell Company and Thodes Company. Stanwell Thodes Net cash flows operating activities 138,000 115,000 total assets 272,000 35,0000 net income 35,000 32,000 sales revenue 385,000 250,000 capital expenditures 28,000 60,000 dividend payments 17,000 13,000 compute the following for both companies. compare your results. A. free cash flow B. Cash flows to sales ratio C. Cash flows to assets ratioarrow_forwardProblem 11-4A Prepare a statement of cash flows—indirect method (LO11-2, 11-3, 11-4, 11-5) The income statement, balance sheets, and additional information for Video Phones, Inc., are provided. VIDEO PHONES, INC. Income Statement For the Year Ended December 31, 2021 Net sales $ 2,636,000 Expenses: Cost of goods sold $ 1,600,000 Operating expenses 788,000 Depreciation expense 20,000 Loss on sale of land 7,300 Interest expense 11,500 Income tax expense 41,000 Total expenses 2,467,800 Net income $ 168,200 VIDEO PHONES, INC. Balance Sheets December 31 2021 2020 Assets Current assets: Cash $ 159,180 $ 85,940 Accounts receivable 73,300 53,000 Inventory 105,000 128,000 Prepaid rent 9,120 4,560 Long-term assets: Investments 98,000…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Corporate Financial AccountingAccountingISBN:9781305653535Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- Corporate Financial AccountingAccountingISBN:9781337398169Author:Carl Warren, Jeff JonesPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning