FloorCo, Inc. has provided data from its previous year of operations. The Controller has asked you...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
FloorCo, Inc. has provided data from its previous year of operations. The Controller has asked you to prepare the Operating Activities Section of the Statement of Cash Flows. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=C6" was entered, the formula would output the result from cell C6, or 75,000 in this example. • Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add). - (minus sign to subtract). * (asterisk sign to multiply), and / (forward slash to divide). From the Excel Simulation below, if in a blank cell "=D13+D14" was entered, the formula would add the values from those cells and output the result, or 35,200 in this example. If using the other math symbols the result would output an appropriate answer for its function. • SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this function. From the Excel Simulation below, if in a blank cell "-SUM(D7, D8,D9)" was entered, the formula would output the result of adding those three separate cells, or 402,000 in this example. Similarly, if in a blank cell "-SUM(D7:D9)" was entered, the formula would output the same result of adding those cells, except they are expressed as a range in the formula, and the result would be 402,000 in this example. 1 The following information is for FloorCo, Inc. for the year just ended: 2 3 4 Beginning of year End of year 5 Current assets: 6 Cash $ 90,000 7 Accounts receivable 140,000 8 Inventory 246,000 9 Prepaid expenses 16,000 10 11 Current liabilities 12 Accounts payable 302,000 13 Accrued liabiities 11,200 14 Income taxes payable 24,000 15 16 Net income 94,500 17 75,000 $ 158,000 285,000 11,000 284,000 9,500 27,000 $ 18 Accumulated depreciation 19 total credits $ 45,000 20 21 Floor Company did not record any gains or losses during the year. 22 23 Prepare a schedule of net cash provided by operating activities. 24 25 FloorCo, Inc. 26 Operating Activities Section of the Statement of Cash Flows 27 28 Net income 29 Adjustments to convert net income to a cash basis: 30 Depreciation 31 Increase in accounts receivable 32 Increase in inventory 33 Decrease in prepaid expenses 34 Decrease in accounts payable 35 Decrease in accrued liabilities 36 Increase in income taxes payable 37 Net cash provided by operating activities 38 FloorCo, Inc. has provided data from its previous year of operations. The Controller has asked you to prepare the Operating Activities Section of the Statement of Cash Flows. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=C6" was entered, the formula would output the result from cell C6, or 75,000 in this example. • Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add). - (minus sign to subtract). * (asterisk sign to multiply), and / (forward slash to divide). From the Excel Simulation below, if in a blank cell "=D13+D14" was entered, the formula would add the values from those cells and output the result, or 35,200 in this example. If using the other math symbols the result would output an appropriate answer for its function. • SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this function. From the Excel Simulation below, if in a blank cell "-SUM(D7, D8,D9)" was entered, the formula would output the result of adding those three separate cells, or 402,000 in this example. Similarly, if in a blank cell "-SUM(D7:D9)" was entered, the formula would output the same result of adding those cells, except they are expressed as a range in the formula, and the result would be 402,000 in this example. 1 The following information is for FloorCo, Inc. for the year just ended: 2 3 4 Beginning of year End of year 5 Current assets: 6 Cash $ 90,000 7 Accounts receivable 140,000 8 Inventory 246,000 9 Prepaid expenses 16,000 10 11 Current liabilities 12 Accounts payable 302,000 13 Accrued liabiities 11,200 14 Income taxes payable 24,000 15 16 Net income 94,500 17 75,000 $ 158,000 285,000 11,000 284,000 9,500 27,000 $ 18 Accumulated depreciation 19 total credits $ 45,000 20 21 Floor Company did not record any gains or losses during the year. 22 23 Prepare a schedule of net cash provided by operating activities. 24 25 FloorCo, Inc. 26 Operating Activities Section of the Statement of Cash Flows 27 28 Net income 29 Adjustments to convert net income to a cash basis: 30 Depreciation 31 Increase in accounts receivable 32 Increase in inventory 33 Decrease in prepaid expenses 34 Decrease in accounts payable 35 Decrease in accrued liabilities 36 Increase in income taxes payable 37 Net cash provided by operating activities 38
Expert Answer:
Answer rating: 100% (QA)
Operating activities Section of the statement of cash flow Net income 94500 Adju... View the full answer
Related Book For
Financial Accounting
ISBN: 978-1259103285
5th Canadian edition
Authors: Robert Libby, Patricia Libby, Daniel Short, George Kanaan, M
Posted Date:
Students also viewed these accounting questions
-
S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments...
-
Reading Readiness, Inc. has provided you its list of accounts and balances as of January 31. The Controller has asked you to prepare an Income Statement for the month ended January 31. Use the...
-
Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Use the information included in the Excel...
-
Communication: What are the characteristics of effective communication relevant to your team project submission? Relate to theory. Provide a minimum of 4. ( 8 ) Assess your communication...
-
Rafy Furcal believes that both the beginning and ending balances in retained earnings are shown in the stockholders equity section. Is Rafy correct? Discuss.
-
1. An arrow is shot horizontally with a speed of 20. m/s from the top of a tower 60. m high. The time to reach the ground will be a) 8.9 s. b) 7.1s. c) 3.5 s. d) 2.6 s. e) 1.0 s. 2. A projectile is...
-
What is the critical test for any accounting system? Does this test rely on syntactic, semantic or pragmatic perspectives?
-
A surge tank system is to be installed as part of a pilot plant facility. The initial proposal calls for the configuration shown in figure. 4.3. Each tank is 5 ft high and 3 ft in diameter. The...
-
Buildstuff Ltd. is a construction company which in the past had a large market capitalisation and turnover, but, after the great recession of the late 2000's and the recent pandemic, finds itself...
-
Pacifico Company, a U.S.-based Importer of beer and wine, purchased 1,500 cases of Oktoberfest-style beer from a German supplier for 375,000 euros. Relevant U.S. dollar exchange rates for the euro...
-
How do transnational processes, such as migration, globalization, and diaspora, complicate traditional understandings of race and ethnicity, and what implications do they have for notions of...
-
Oxfams purpose is to help create lasting solutions to the injustice of poverty. As stated in its Memorandum of Association, the objects for which Oxfam is established for the public benefit are: to...
-
The management of Could Do Better has asked you to explain the concept of weighted average cost of capital. In particular, they are confused that you are encouraging the use of debt capital to fund...
-
How does Figure 20.2 support the following statement: "Looking at how countries of different income at any point in time supply environmental quality (the environmental Kuznets curve) does not...
-
In the hybrid fee-subsidy scheme described in Figure 15.7, suppose there are two additional marginal savings functions, one even higher than \(\mathrm{MS}_{\mathrm{H}}\) and one lower than \(M...
-
The Chicago Mercantile Exchange houses the fed funds futures market as well as a number of other interest rate options and futures. Go to http://www.cmegroup.com/...
-
Given the cash flows below for two mutually exclusive projects, what is the B/C ratio and which project should you select if the MARR is 6%? Project A: Cash flows for years 0-6: (-$2000), $500, $500,...
-
Write a program that initializes an array. It inputs a value from the user and searches the number in the array.
-
The following events occurred for Mitka Ltd.: a. Received investment of $ 32,000 cash by organizers. b. Purchased land for $ 18,000 in land; paid $ 6,000 in cash and signed a mortgage note with a...
-
Refer to the financial statements of Canadian Tire Corporation (Appendix A) and RONA Inc. (on Connect), and the Industry Ratio Report (Appendix B on Connect). Required: 1. What was the cost of sales...
-
Differentiate between cumulative and non-cumulative preferred shares.
-
Skim PMIs latest version of OPM3. Summarize key information in this document and your opinion of it in a one-to-two-page paper.
-
What are the new features of Project Professional 2016?
-
Organizations can measure performance against their own past; against peers; and, even better, against __________. A. profits B. potential C. revenues D. the future
Study smarter with the SolutionInn App