Question: This is an Excel question. Please include formulas. Thank you! The following table shows key financial data for three firms that compete in the consumer
The following table shows key financial data for three firms that compete in the consumer products market. Proctor \\& Gamble, Colgate-Palmolive, and Clorox. All dollar values are in thousands. a. Calculate each of the following ratios for all three companies: current ratio, quick ratio, inventory turnover, average collection period, total asset turnover. b. Which company is in the position of having the greatest liquidity? c. Would you say that the three exhibit similar performance or quite different performance in term of collection receivables? Why do you think that might be? d. Which company has the most rapid inventory turnover? Are your answers to those questions a little surprising? If a company is best at inventory turnover and worst at total asset turnover, what do you think that means
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
