The comparative balance sheet of Olson-Jones Industries Inc. for December 31, 20Y2 and 20Y1, is as follows: Dec. 31, 2OY2 Dec. 31, 20Y1 Assets Cash $183 $14 Accounts receivable (net) 55 49 Inventories 117 99 Land 250 330 Equipment 205 175 Accumulated depreciation-equipment (68) (42) Total assets $742 $625 Liabilities and Stockholders' Equity Accounts payable (merchandise creditors) $51 $37 Dividends payable Common stock, $1 par 125 80 Paid-in capital in excess of par-common stock 85 70 Retained earnings 476 438 Total liabilities and stockholders' equity $742 $625 The following additional information is taken from the records: a. Land was sold for $120. b. Equipment was acquired for cash. c. There were no disposals of equipment during the year. d. The common stock was issued for cash. e. There was a $62 credit to Retained Earnings for net income. f. There was a $24 debit to Retained Earnings for cash dividends declared. a. Prepare a statement of cash flows, using the indirect method of presenting Cash flows from operating activities. Use the minus sign to indicate cash out flows, cash payments, decreases in cash, or any negative adjustments.

The comparative balance sheet of Olson-Jones Industries Inc. for December 31, 20Y2 and 20Y1, is as follows: Dec. 31, 2OY2 Dec. 31, 20Y1 Assets Cash $183 $14 Accounts receivable (net) 55 49 Inventories 117 99 Land 250 330 Equipment 205 175 Accumulated depreciation-equipment (68) (42) Total assets $742 $625 Liabilities and Stockholders' Equity Accounts payable (merchandise creditors) $51 $37 Dividends payable Common stock, $1 par 125 80 Paid-in capital in excess of par-common stock 85 70 Retained earnings 476 438 Total liabilities and stockholders' equity $742 $625 The following additional information is taken from the records: a. Land was sold for $120. b. Equipment was acquired for cash. c. There were no disposals of equipment during the year. d. The common stock was issued for cash. e. There was a $62 credit to Retained Earnings for net income. f. There was a $24 debit to Retained Earnings for cash dividends declared. a. Prepare a statement of cash flows, using the indirect method of presenting Cash flows from operating activities. 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

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
Adjustment for depreciation The estimated amount of depredation on equipment for the current year is $133,000. a. How is the adjustment recorded? Indicate each account affected, whether the account is increased or decreased, and the amount of the increase or decrease. b. If the adjustment in (a) was omitted, which items would be erroneously stated on (1) the income statement for the year and (2) the balance sheet as of December 31?
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
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.
Refer to the information for Cox Inc. above. What amount would Cox record as depreciation expense at December 31, 2020, if the double-declining-balance method were used? a. $187,200 b. $192,000 c. $195,200 d. $312, 000
Unusual income statement items Assume that the amount of each of the following items is material to the financial statements. Classify each item as either normally recurring (NR) or unusual (U) items. If unusual item, then specify if it is a discontinued operations item (DO). a. Interest revenue on notes receivable. b. Gain on sale of segment of the company's operations that manufactures bottling equipment. c.Loss on sale of investments in stocks and bonds. d. Uncollectible accounts expense. e. Uninsured flood loss. (Hood insurance is unavailable because of periodic Hooding in the area.)
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 Return on total assets
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.
Using the following information, A. Make the December 31 adjusting journal entry for depreciation. B. Determine the net book value (NBV) of the asset on December 31. Cost of asset, $195,000 Accumulated depreciation, beginning of year, $26,000 Current year depreciation, $13,000
The comparative balance sheet of Merrick Equipment Co. for December 31, 20Y9 and 20Y8, is as follows:Dec 31 20Y9 Dec 31 20Y8ASSETSCash $ 70,720 $ 47,940Accounts Receivable 207,230 188,190Inventories 298,520 289,850Investments - 102,000Land 295,800 -Equipment 438,600 358,020Accumulated Depreciation-Equipment (99,110) (84,320)Total Assets $ 1,211,760 $ 901,680LIABILITIES AND STOCKHOLDERS' EQUITYAccounts Payable $ 205,700 $ 194,140Accrued Expenses Payable (operating expenses) 30,600 26,860Dividends Payable 25,500 20,400Common Stock, $1 par 202,000 102,000Paid-in Capital; Excess of issue price over par-common stock 354,000 204,000Retained Earnings 393,960 354,280Total Liabilities and Stockholders Equity: $ 1,211,760 $ 901,680Additional data obtained from an examination of the accounts in the ledger for 20Y9 are as follows:A. Equipment and land were acquired for cashB. There were no disposals of equipment during the year.C. The investments were sold for $91,800 cash.D. The common stock was…
The comparative balance sheet of Olson-Jones Industries Inc. for December 31, 20Y2 and 20Y1, is as follows: 1 Dec. 31, 20Y2 Dec. 31, 20Y1 2 Assets 3 Cash $489.00 $163.00 4 Accounts receivable (net) 283.00 205.00 5 Inventories 180.00 111.00 6 Land 396.00 449.00 7 Equipment 228.00 179.00 8 Accumulated depreciation-equipment (56.00) (31.00) 9 Total assets $1,520.00 $1,076.00 10 Liabilities and Stockholders’ Equity 11 Accounts payable (merchandise creditors) $171.00 $162.00 12 Dividends payable 30.00 13 Common stock, $1 par 105.00 48.00 14 Paid-in capital: Excess of issue price over par—common stock 248.00 127.00 15 Retained earnings 966.00 739.00 16 Total liabilities and stockholders’ equity $1,520.00 $1,076.00 The following additional information is taken from the records: 1. Land was sold for…
The comparative balance sheet of Hirayama Industries Inc. for December 31, 20Y2 and 20Y1, is as follows: 1 Dec. 31, 20Y2 Dec. 31, 20Y1 2 Assets 3 Cash $486.00 $158.00 4 Accounts receivable (net) 280.00 195.00 5 Inventories 172.00 110.00 6 Land 400.00 453.00 7 Equipment 223.00 172.00 8 Accumulated depreciation-equipment (60.00) (27.00) 9 Total assets $1,501.00 $1,061.00 10 Liabilities and Stockholders’ Equity 11 Accounts payable (merchandise creditors) $180.00 $161.00 12 Dividends payable 32.00 13 Common stock, $1 par 105.00 45.00 14 Excess of paid-in capital over par 247.00 121.00 15 Retained earnings 937.00 734.00 16 Total liabilities and stockholders’ equity $1,501.00 $1,061.00 1 Dec. 31, 20Y2 Dec. 31, 20Y1 2 Assets 3 Cash $486.00 $158.00 4 Accounts receivable (net) 280.00 195.00 5 Inventories 172.00 110.00 6 Land 400.00 453.00 7 Equipment 223.00 172.00 8 Accumulated…