C27 1 2 3 4 5 6 7 8 9 10 11 12 13 14 50...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
C27 1 2 3 4 5 6 7 8 9 10 11 12 13 14 50 23 30 31 32 33 Current assets: Cash 47 48 K 4 Accounts receivable Inventory Prepaid expenses Current liabilities: Calibri (Body) The following information is for FloorCo, Inc. for the year just ended: Xfx Accounts payable Accrued liabiities Income taxes payable Net income Accumulated depreciation total credits 24 25 26 27 Net income 28 Adjustments to convert net income to a cash basis: 29 Depreciation Increase in accounts receivable Increase in inventory Decrease in prepaid expenses Decrease in accounts payable Decrease in accrued liabilities Increase in income taxes payable Net cash provided by operating activities A > 15 16 17 18 FloorCo did not record any gains or losses during the year. 19 20 Required: 21 Prepare a schedule of net cash provided by operating activites. 22 E 11 AA BI U ab DE AE B Workbook Statistics End of year Graded Worksheet $75,000 158,000 285,000 11,000 284,000 9,500 27,000 FloorCo, Inc. Operating Activities Section of the Statement of Cash Flows C Beginning of year (Use cells B6 to C16 from the given information to complete this question. Negative amounts or amounts to be deducted should be input and displayed as negative values.) $90,000 140,000 246,000 16,000 34 35 36 37 38 39 40 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 41 Nothing in this area will be graded, but it will be submitted with your assignment. 42 43 44 45 46 302,000 11,200 24,000 $94,500 $45,000 D G C27 1 2 3 4 5 6 7 8 9 10 11 12 13 14 50 23 30 31 32 33 Current assets: Cash 47 48 K 4 Accounts receivable Inventory Prepaid expenses Current liabilities: Calibri (Body) The following information is for FloorCo, Inc. for the year just ended: Xfx Accounts payable Accrued liabiities Income taxes payable Net income Accumulated depreciation total credits 24 25 26 27 Net income 28 Adjustments to convert net income to a cash basis: 29 Depreciation Increase in accounts receivable Increase in inventory Decrease in prepaid expenses Decrease in accounts payable Decrease in accrued liabilities Increase in income taxes payable Net cash provided by operating activities A > 15 16 17 18 FloorCo did not record any gains or losses during the year. 19 20 Required: 21 Prepare a schedule of net cash provided by operating activites. 22 E 11 AA BI U ab DE AE B Workbook Statistics End of year Graded Worksheet $75,000 158,000 285,000 11,000 284,000 9,500 27,000 FloorCo, Inc. Operating Activities Section of the Statement of Cash Flows C Beginning of year (Use cells B6 to C16 from the given information to complete this question. Negative amounts or amounts to be deducted should be input and displayed as negative values.) $90,000 140,000 246,000 16,000 34 35 36 37 38 39 40 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 41 Nothing in this area will be graded, but it will be submitted with your assignment. 42 43 44 45 46 302,000 11,200 24,000 $94,500 $45,000 D G
Expert Answer:
Answer rating: 100% (QA)
Youve shared a screenshot of a spreadsheet with financial information used to prepare the Operating Activities Section of the Statement of Cash Flows ... View the full answer
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Posted Date:
Students also viewed these accounting questions
-
Determine the transfer function from U(s) to Y(s) for the following block diagram. Provided are some recommended steps to take: a. Label each signal (line with arrow) b. Write the equation for each...
-
Find the maximum of f(x,y) = x + y - x - y - xy
-
What personal skills do you need to keep your financial backers feeling confident in your new business? Which skills are most useful when you're dealing with more informal sources, such as family and...
-
Give the slopeintercept form of the equation of the line. H LO -5 y 5
-
As a gambling facility, MGM Desert Inn, Inc., regularly holds and executes negotiable instruments. During a period of two months, patron William E. Shack Jr. entered MGM and delivered eight checks to...
-
The Horsheim Company is a furniture manufacturer with two departments: molding and finishing. The company uses the weighted-average method of process costing. In August, the following data were...
-
Business Firms have to experience various types of costs in producing their products or in providing their services. Explain the basis of costs classification as "Direct-Indirect" and...
-
Does political advertising manipulate public opinion about issues and candidates? Is this any different from advertising a consumer product? If political attitudes are the result of manipulation,...
-
One way that exporters analyze conditions in emerging markets is through the use of macroeconomic indicators. The Market Potential Index (MPI) is a yearly study conducted by Michigan State...
-
A. T. Kearney publishes an annual study to help retailers prioritize their global development strategies by ranking the retail expansion attractiveness of emerging countries based on a particular set...
-
In 1990, Jamba Juice started in San Luis Obispo, California. The company, which sells smoothie drinks, got off to a good start, opened two more cafs in 1993, and now has hundreds of outlets all the...
-
Your company has assigned you the task of investigating the various trade blocs in Africa to see if your company can benefit from these trade agreements while expanding into African markets. The...
-
Advertising is an important part of marketing, but mass advertising, which is generally despised by many people around the world, is more and more becoming an ancient way of doing business. Today,...
-
dc is a marginal-cost function and fixed costs are indicated in braces. dq Find the total cost for the indicated value of q when dc = 0.12q-150q + 5.60 {9000}; q= 20 dq The total cost for q= 20 is S...
-
Suppose that the laptop of Prob. 2.16 is placed in an insulating briefcase with a fully charged battery, but it does not go into sleep mode, and the battery discharges as if the laptop were in use....
-
The Monday demand for almond croissants is normally distributed with a mean of 100 and a standard deviation of 25. It costs $1.00 to produce a croissant, which sells for $4.00. Leftover croissants...
-
The current price of copper is 95 cents per pound. The annual volatility for copper prices is 20 percent, and the risk-free rate is 5 percent. In one year, you have the option (if you want it) to...
-
The file named Problem19data.xlsx shows each US temperature during each month from 1895 through 2015. For this time period, calculate the average temperature during each month of the year.
-
Modem databases require a high level of skill and knowledge to be adequately supported. See if you can interview the database administrators in three or four local organizations which nse...
-
What is at common misconception about databases?
-
CASE tools, such as system Architect, are used for database development and support. Search on the Web and in trade journals for some of the popular CASE tools currently in use. a. What CASE tools...
Study smarter with the SolutionInn App