Question
E24-5 (Analysis of Given Ratios) Picasso Company is a wholesale distributor of professional equipment and supplies. The companys sales have averaged about $900,000 annually for
E24-5 (Analysis of Given Ratios) Picasso Company is a wholesale distributor of professional equipment and supplies. The companys sales have averaged about $900,000 annually for the 3-year period 20122014. The firms total assets at the end of 2014 amounted to $850,000. The president of Picasso Company has asked the controller to prepare a report that summarizes the financial aspects of the companys operations for the past 3 years. This report will be presented to the board of directors at their next meeting. In addition to comparative financial statements, the controller has decided to present a number of relevant financial ratios which can assist in the identification and interpretation of trends. At the request of the controller, the accounting staff has calculated the following ratios for the 3-year period 20122014. Current ratio Acid-test (quick) ratio Accounts receivable turnover Inventory turnover Debt to assets Long-term debt to assets Sales to fixed assets (fixed asset turnover) Sales as a percent of 2012 sales Gross margin percentage Net income to sales Return on assets Return on common stock equity 201220132014 1.801.891.96 1.040.990.87 8.757.716.42 4.914.323.42 51.0%46.0%41.0% 31.0%27.0%24.0% 1.581.691.79 1.001.031.07 36.0%35.1%34.6% 6.9%7.0%7.2% 7.7%7.7%7.8% 13.6%13.1%12.7% In preparation of the report, the controller has decided first to examine the financial ratios independent of any other data to determine if the ratios themselves reveal any significant trends over the 3-year period. Instructions (a) The current ratio is increasing while the acid-test (quick) ratio is decreasing. Using the ratios pro- vided, identify and explain the contributing factor(s) for this apparently divergent trend. (b) In terms of the ratios provided, what conclusion(s) can be drawn regarding the companys use of financial leverage during the 20122014 period? (c) Using the ratios provided, what
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started