he net income reported on the income statement for the current year was $73,600. Depreciation recorded on store equipment for the year amounted to $27,400. Balances of the current asset and urrent liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $23,500 $18,700 Accounts receivable (net) 56,000 48,000 Merchandise inventory 35,500 40,000 Prepaid expenses 4,750 7,000 Accounts payable (merchandise creditors) 21,800 16,800 Wages payable 4,900 5,800 a. Prepare the Cash Flows from Operating Activities section of the statement of cash flows, using the indirect method. Use the minus sign to indicate cash outflows, cash payments, decreases in cash, or any negative adjustments.

he net income reported on the income statement for the current year was $73,600. Depreciation recorded on store equipment for the year amounted to $27,400. Balances of the current asset and urrent liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $23,500 $18,700 Accounts receivable (net) 56,000 48,000 Merchandise inventory 35,500 40,000 Prepaid expenses 4,750 7,000 Accounts payable (merchandise creditors) 21,800 16,800 Wages payable 4,900 5,800 a. Prepare the Cash Flows from Operating Activities section of the statement of cash flows, using the indirect method. Use the minus sign to indicate cash outflows, 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

Shaquille Corporation began the current year with inventory of 50,000. During the year, its purchases totaled 110,000. Shaquille paid freight charges of 8,500 for those purchases. At the end of the year, Shaquille had inventory of 47,800. Prepare a schedule to determine Shaquille's cost of goods sold for the current year.
Consider the following situations and determine (1) which type of liability should be recognized (specific account), and (2) how much should be recognized in the current period (year). A. A business depreciates a building with a book value of $12,000, using straight-line depreciation, no salvage value, and a remaining useful life of six years. B. An organization has a line of credit with a supplier. The company purchases $35,500 worth of inventory on credit. Terms of purchase are 3/20, n/60. C. An employee earns $1,000 in pay and the employer withholds $46 for federal income tax. D. A customer pays $4,000 in advance for legal services. The lawyer has previously recognized 30% of the services as revenue. The remainder is outstanding.
Jada Company had the following transactions during the year: Purchased a machine for $500,000 using a long-term note to finance it Paid $500 for ordinary repair Purchased a patent for $45,000 cash Paid $200,000 cash for addition to an existing building Paid $60,000 for monthly salaries Paid $250 for routine maintenance on equipment Paid $10,000 for major repairs Depreciation expense recorded for the year is $25,000 If all transactions were recorded properly, what is the amount of increase to the Property, Plant, and Equipment section of Jadas balance sheet resulting from this years transactions? What amount did Jada report on the income statement for expenses for the year?
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.
On December 31, Pitts Manufacturing Company reports the following assets: What is the total amount of Pitts inventory at year-end?
Steele Corp. purchases equipment for $25,000. Regarding the purchase, Steele recorded the following transactions: Paid shipping of $1,000 Paid installation fees of $2,000 Pays annual maintenance cost of $200 Received a 5% discount on $25,000 sales price Determine the acquisition cost of the equipment.
The following accounts appear in the ledger of Celso and Company as of June 30, the end of this fiscal year. The data needed for the adjustments on June 30 are as follows: ab.Merchandise inventory, June 30, 54,600. c.Insurance expired for the year, 475. d.Depreciation for the year, 4,380. e.Accrued wages on June 30, 1,492. f.Supplies on hand at the end of the year, 100. Required 1. Prepare a work sheet for the fiscal year ended June 30. Ignore this step if using CLGL. 2. Prepare an income statement. 3. Prepare a statement of owners equity. No additional investments were made during the year. 4. Prepare a balance sheet. 5. Journalize the adjusting entries. 6. Journalize the closing entries. 7. Journalize the reversing entry as of July 1, for the wages that were accrued in the June adjusting entry. Check Figure Net income, 14,066
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.
The accounts and their balances in the ledger of Markeys Mountain Shop as of December 31, the end of its fiscal year, are as follows: Data for the adjustments are as follows. Assume that Markeys Mountain Shop uses the perpetual inventory system. a. Merchandise Inventory at December 31, 140,357. b. Store supplies inventory (on hand) at December 31, 540. c. Depreciation of building, 3,400. d. Depreciation of store equipment, 3,800. e. Salaries accrued at December 31, 1,250. f. Insurance expired during the year, 1,480. Required 1. Complete the work sheet after entering the account names and balances onto the work sheet. Ignore this step if using CLGL. 2. Journalize the adjusting entries. If using manual working papers, record adjusting entries on journal page 63.