Need to research and calculate 2018 financial ratios for The Clorox Company and Colgate Palmolive, and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Need to research and calculate 2018 financial ratios for The Clorox Company and Colgate Palmolive, and compare/analyze those results • Need to use the www.SEC.gov website to find the current financial statements for both companies • Need to use Excel Need to use the same the financial ratios as the McGraw Hill Connect Financial Analysis Case, as follows: • Working capital • Current assets - Current liabilities • Current ratio • Current assets / Current liabilities • Acid-test ratio Cash (including temporary cash investments) + Accounts receivable / Current liabilities Margin • Net income / Sales • Gross profit ratio = Gross profit / Net sales • Gross Margin, another name for Gross Profit. • Turnover • Net sales / Average total assets • Return on Investment (ROI) • Net income / Average total assets • Average total assets during the year • Return on Equity (ROE) • Net income / Average stockholders' equity • Inventory turnover • Cost of goods sold / Average inventories • Number of days' sales in inventory (use ending inventory) Average day's cost of goods sold = Annual cost of goods sold / 365 Accounts receivable turnover Sales / Average accounts receivable Number of days' sales in accounts receivable • Days' sales in accounts receivable = Accounts receivable at year-end / Average day's sales Average day's sales = Annual sales / 365 Need to research and calculate 2018 financial ratios for The Clorox Company and Colgate Palmolive, and compare/analyze those results • Need to use the www.SEC.gov website to find the current financial statements for both companies • Need to use Excel Need to use the same the financial ratios as the McGraw Hill Connect Financial Analysis Case, as follows: • Working capital • Current assets - Current liabilities • Current ratio • Current assets / Current liabilities • Acid-test ratio Cash (including temporary cash investments) + Accounts receivable / Current liabilities Margin • Net income / Sales • Gross profit ratio = Gross profit / Net sales • Gross Margin, another name for Gross Profit. • Turnover • Net sales / Average total assets • Return on Investment (ROI) • Net income / Average total assets • Average total assets during the year • Return on Equity (ROE) • Net income / Average stockholders' equity • Inventory turnover • Cost of goods sold / Average inventories • Number of days' sales in inventory (use ending inventory) Average day's cost of goods sold = Annual cost of goods sold / 365 Accounts receivable turnover Sales / Average accounts receivable Number of days' sales in accounts receivable • Days' sales in accounts receivable = Accounts receivable at year-end / Average day's sales Average day's sales = Annual sales / 365
Expert Answer:
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these accounting questions
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Consider the following population regression model: y = Bo + Bx + Bx2 + 3x3 + u Suppose you want to test whether 0.532 = 83. The hypotheses are: Ho : 0.582 = 33 H : 0.532 #33 The correct expression...
-
Use Pareto analysis to investigate the following data collected on a printed-circuit-board assembly line: Number of Defect Defect Occurrences Components not adhering............ 143...
-
Giovanni died in 2013 with a gross estate of $6.9 million and debts of $30,000. He made post-1976 taxable gifts of $100,000, valued at $80,000 when Giovanni died. His estate paid state death taxes of...
-
What are the grounds for seeking an attachment?
-
What items should be included in the audit status report?
-
ABC Ltd. has two divisions. The Compound Division makes A2C2, an industrial compound, which is then transferred to the Processing Division. The Processing Division further processes the A2C2 and...
-
When the pump in Fig P3.130 draws 220 m3/h of water at 20°C from the reservoir, the total friction head loss is 5 m. The flow discharges through a nozzle to the atmosphere Estimate the pump power...
-
Wahl manufacturing is considering an investment in a numerically controlled machine to save on manufacturing costs. The cost of the machine can be fully depreciated without consideration of any...
-
For each question please identify the query you used that was successful and give the full citation of the cases or statutes you locate. One fine autumn day, Jim and Jean decide to drive to the...
-
Write a MATLAB function that evaluates a polynomial function f(x) = ax+aN_x1 + ...ax + ao of order N for a scalar value x. The function should take a 1 by N+1 array (index 1 to N+1 to be N+1 terms)...
-
Prepare a schedule of cash collections for January, February, and March and the quarter in total. (Round your answers to the nearest whole dollar.) Information Given: a. Actual sales in December were...
-
6. Convert C++ code snippet to LEGv8 assembly code. The following variables x, y, and z are associated with registers X19, X20, and X21, respectively, and base address of the array d is in X22....
-
You are a junior RMA at Quokka Migration. Quokka Migration is owned by Peter Yip, a registered agent. James Grubb, a client of the firm who you assisted in the past, was granted a subclass 482 visa...
-
regarding the indicators of spoilage and contamination of stock. What are the indicators of contamination of stock?
-
Rowland Textile Inc. manufactures two products: sweatshirts and T-shirts. The manufacturing process involves two activities: cutting and sewing. Expected overhead costs and cost drivers are as...
-
What three factors influence the dollar amount reported for liabilities?
-
Complete this case involving Adelphia Communications, available online in the Connect library. By completing the requirements of this case, which ask you to explain how accounting concepts apply to...
-
Bearings & Brakes Corporation (B& B) was incorporated as a private company. The companys accounts included the following at June 30: During the month of July, the company had the following...
-
Discuss the physical meaning of the small-signal circuit parameter \(r_{o}\).
-
Discuss, using the concept of a load line, how a simple common-source circuit can amplify a time-varying signal.
-
Sketch a simple source-follower amplifier circuit and discuss the general ac circuit characteristics (voltage gain and output resistance).
Study smarter with the SolutionInn App