Robbins Ltd. is a wholesale distributor of professional equipment and supplies. The company’s sales have averaged about $900,000 annually for the three-year period from 2021 to 2023. The firm’s total assets at the end of 2020 amounted to $850,000. The president of Robbins has asked the controller to prepare a report that summarizes the financial aspects of the company’s operations for the past three 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 that can help with identifying and interpreting trends. At the request of the controller, the accounting staff has calculated the following ratios for the 2021 to 2023 period:

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 three-year period.

Instructions

a. The current ratio is increasing while the acid-test (quick) ratio is decreasing. Using the ratios provided, 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 company’s use of financial leverage during the 2021 to 2023 period?

c. Using the ratios provided, what conclusion(s) can be drawn regarding the company’s net investment in plant and equipment?

d. Using the activity ratios provided for inventory and accounts receivable, comment on the effectiveness of working capital management.

Transcribed Image Text:

Current ratio Acid-test (quick) ratio Accounts receivable turnover Inventory turnover Debt to total assets Long-term debt to total assets Sales to fixed assets (fixed asset turnover) Sales as a percent of 2021 sales Gross margin percentage Net income to sales (profit margin) Return on total assets Return on equity 2021 1.80 1.04 8.75 4.91 51.0% 31.0% 1.58 1.00 36.0% 6.9% 7.7% 13.6% 2022 1.89 0.99 7.71 4.32 46.0% 27.0% 1.69 1.03 35.1% 7.0% 7.7% 13.1% 2023 1.96 0.87 6.42 3.72 41.0% 24.0% 1.79 1.05 34.6% 7.2% 7.8% 12.7%