Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Applied Regression Analysis And Other Multivariable Methods

Authors: David G. Kleinbaum, Lawrence L. Kupper, Azhar Nizam, Eli S. Rosenberg

5th Edition

1285051084, 978-1285963754, 128596375X, 978-1285051086

Students also viewed these Accounting questions