Condensed comparative balance sheets of Garrett Company at December 31, Years 1 and 2, are as follows: Year 2 Year 1 Cash $90,000 $78,000 Accounts receivable (net) 78,000 85,000 Inventories 106,500 90,000 Equipment 410,000 370,000 Accumulated depreciation (150,000) (158,000) Total assets $534,500 $465,000 Accounts payable (merchandise creditors) $53,500 $55,000 Cash dividends payable 5,000 4,000 Common stock, $10 par 200,000 170,000 Paid-in capital in excess of par 62,000 60,000 Retained earnings 214,000 176,000 Total liabilities and stockholders' equity $534,500 $465,000 In addition, assume that equipment costing $125,000 was purchased for cash, and equipment costing $85,000 with accumulated depreciation of $65,000 was sold for $15,000; that the stock was issued for cash; and that the only entries in the retained earnings account were for net income of $56,000 and cash dividends declared of $18,000. Prepare a statement of cash flows for the year ended December 31, Year 2, using the indirect method. Use the minus sign to indicate cash out flows, cash payments, decreases in cash, or any negative adjustments.

Condensed comparative balance sheets of Garrett Company at December 31, Years 1 and 2, are as follows: Year 2 Year 1 Cash $90,000 $78,000 Accounts receivable (net) 78,000 85,000 Inventories 106,500 90,000 Equipment 410,000 370,000 Accumulated depreciation (150,000) (158,000) Total assets $534,500 $465,000 Accounts payable (merchandise creditors) $53,500 $55,000 Cash dividends payable 5,000 4,000 Common stock, $10 par 200,000 170,000 Paid-in capital in excess of par 62,000 60,000 Retained earnings 214,000 176,000 Total liabilities and stockholders' equity $534,500 $465,000 In addition, assume that equipment costing $125,000 was purchased for cash, and equipment costing $85,000 with accumulated depreciation of $65,000 was sold for $15,000; that the stock was issued for cash; and that the only entries in the retained earnings account were for net income of $56,000 and cash dividends declared of $18,000. Prepare a statement of cash flows for the year ended December 31, Year 2, using the indirect method. Use the minus sign to indicate cash out flows, cash payments, decreases in cash, or any negative adjustments.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter14: Statement Of Cash Flows (cashflow)

Section: Chapter Questions

Problem 1R: The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal...

See similar textbooks

Similar questions

Return on assets The following data (in millions) were adapted from recent financial statements of Tootsie Roll Industries Inc. (TR): What is Tootsie Roll’s percent of the cost of sales to sales? Round to one decimal place.
The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. Open the file CASHFLOW from the website for this book at cengagebrain.com. First, enter the formulas. Then, complete the worksheet in the manner described next. According to the problem, cash increased from 39,600 to 67,210 during the year. This is a 27,610 increase. To record this increase on the worksheet, move to row 17. Since this is the first account you are analyzing, enter the letter a in column C. Then enter 27610 in column D (a debit since cash increased). This brings the year-end balance (column G) to 67,210, its proper balance. Now move to the bottom part of the statement where you see the categories Operating Activities, Investing Activities, and so on. The credit side of the entry has to be entered here. The proper space for this cash entry is on row 59. Enter the letter a in cell E59 and 27610 in cell F59. Notice the totals at the bottom of the page (row 60) now agree. The next account balance that changed is accounts receivable. It increased by 9,035. To enter this change on the worksheet, enter the letter b in cell C18 and 9035 in cell D18 (again, a debit since accounts receivable increased). This brings the year-end balance in column G to 121,250, its proper balance. The change in accounts receivable balance is an operating activity adjustment (as explained in your textbook). Enter the credit side of this entry in cells E34 and F34, and enter the explanation Increase in accounts receivable in cell A34. Note: Your textbook probably shows Net income as the first item under Operating Activities. We will get to that later. The sequence in which you enter items on this worksheet is not important. All other balance sheet accounts must be analyzed in the same manner, placing appropriate debit or credit entries in the top part of the worksheet to obtain the proper balances in column G, and then entering the second side of the entry in the appropriate row on the bottom part of the worksheet. You should use letter references to identify all entries. Also, you must enter a description of the entry in column A under the appropriate activity category. Although a sequence of analyzing the balance sheet from top to bottom is suggested here, this order is not necessary. As mentioned earlier, your textbook may specify a different sequence. Also, note that some accounts may have both debit and credit adjustments to them. The worksheet is not a substitute for a statement of cash flows, but it does provide you with all the numbers you need to properly prepare one. You will be done with your analysis when: a. The individual account balances at December 31, 2013, as shown on the worksheet (column G) equal those shown in the given problem data. b. The transaction column totals are equal (cells D60 and F60). c. The sum of the operating, investing, and financing activities (cell G59) equals the change in cash (cell D59 or F59). When you are finished, enter your name in cell A1. Save your completed file as CASHFLOW2. Print the worksheet when done. Also print your formulas. Check figure: Total credits at 12/31/2013 (cell G31), 860,460.
Statement of Cash Flows A list of Fischer Companys cash flow activities is presented here: a. Patent amortization expense, 3,500 b. Machinery was purchased for 39,500 c. At year-end, bonds payable with a face value of 20,000 were issued for 17,000 d. Net income, 47,200 k. Inventories increased by 15,400 e. Dividends paid, 16,000 f. Depreciation expense, 12,900 g. Preferred stock was issued for 13,600 h. Investments were acquired for 21,000 i. Accounts receivable increased by 4,300 j. Land was sold at cost, 11,000 k. Inventories increased by 15,400 l. Accounts payable increased by 2,700 m. Beginning cash balance, 19,400 Required: Prepare Fischers statement of cash flows.
The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. You have been asked to prepare a statement of cash flows for Prime Sports Gear for 2013. Review the worksheet called CASHFLOW that has been provided to assist you in preparing the statement. The worksheet has been designed so that as you make entries in columns D and F, column G will be automatically updated. For example, FORMULA1 should be entered as =B17+D17F17. Columns C and E are to be used to enter letter references for each of the debit and credit entries on the worksheet.
Return on assets The following data (in millions) were adapted from recent financial statements of Tootsie Roll Industries Inc. (TR): The percent a company adds to its cost of sales to determine selling price is called a markup. What is Tootsie Roll’s markup percent? Round to one decimal place.
Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Asset turnover
Partial Statement of Cash Flows Service Company had net income during the current year of $65,800. The following information was obtained from Services balance sheet: Accounts receivable $26,540 increase Inventory 32,180 increase Accounts payable 9,300 decrease Interest payable 2,120 increase Accumulated depreciation (Building) 14,590 increase Accumulated depreciation (Equipment) 32,350 increase Additional Information: 1. Equipment with accumulated depreciation of $18,000 was sold during the year. 2. Cash dividends of $29,625 were paid during the year. Required: 1. Prepare the net cash flows from operating activities using the indirect method. 2. CONCEPTUAL CONNECTION How would the cash proceeds from the sale of equipment he reported on the statement of cash flows? 3. CONCEPTUAL CONNECTION How would the cash dividends be reported on the statement of cash flows? 4. CONCEPTUAL CONNECTION What could the difference between net income and cash flow from operating activities signal to financial statement users?
Balance sheets for Brierwold Corporation follow: Additional transactions were as follows: a. Purchased equipment costing 50,000. b. Sold equipment costing 60,000, with a book value of 25,000, for 40,000. c. Retired preferred stock at a cost of 110,000. (The premium is debited to Retained Earnings.) d. Issued 10,000 shares of common stock (par value, 4) for 10 per share. e. Reported a loss of 15,000 for the year. f. Purchased land for 50,000. Required: Prepare a statement of cash flows using the worksheet approach. Use the indirect method to prepare the statement.
Balance sheets for Brierwold Corporation follow: Additional transactions were as follows: a. Purchased equipment costing 50,000. b. Sold equipment costing 60,000, with a book value of 25,000, for 40,000. c. Retired preferred stock at a cost of 110,000. (The premium is debited to Retained Earnings.) d. Issued 10,000 shares of common stock (par value, 4) for 10 per share. e. Reported a loss of 15,000 for the year. f. Purchased land for 50,000. Required: Prepare a statement of cash flows using the indirect method.
Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Ratio of fixed assets to long-term liabilities
Statement of Cash Flows The following are Mueller Companys cash flow activities: a. Net income, 68,000 b. Increase in accounts receivable, 4,400 c. Receipt from sale of common stock, 12,300 d. Depreciation expense, 11,300 e. Dividends paid, 24,500 f. Payment for purchase of building, 65,000 g. Bond discount amortization, 2,700 h. Receipt from sale of long-term investments at cost, 10,600 i. Payment for purchase of equipment, 8,000 j. Receipt from sale of preferred stock, 20,000 k. Increase in income taxes payable, 3,500 l. Payment for purchase of land, 9,700 m. Decrease in accounts payable, 2,900 n. Increase in inventories, 10,300 o. Beginning cash balance, 18,000 Required: Prepare Mueller Company's statement of cash flows.
Income Statement and Retained Earnings Huff Company presents the following items derived from its December 31, 2019, adjusted trial balance: The following information is also available for 2019 and is not reflected in the preceding accounts: 1. The common stock has been outstanding all year. A cash dividend of 1.28 per share was declared and paid. 2. Land was sold at a pretax gain of 6,300. 3. Division X (a major component of the company) was sold at a pretax gain of 4,700. It had incurred a 9,500 pretax operating loss during 2019. 4. A tornado, which is an unusual event in the area, caused a 5,400 pretax loss. 5. The income tax rate on all items of income is 30%. 6. The average shareholders equity is 90,000. Required: 1. Prepare a 2019 multiple-step income statement for Huff. 2. Prepare a 2019 retained earnings statement. 3. Compute the 2019 return on common equity (Net Income 4 Average Shareholders Equity).