Question

In: Finance

You are the financial analyst at SewMart, an arts and crafts retail store. Your boss has...

You are the financial analyst at SewMart, an arts and crafts retail store. Your boss has asked you to review the company's financial results for the past three years and to provide an analysis of your findings:

SewMart Ratios 20x9 20x8 20x7
Sales trend 16.7 22.1 25.1
Current ratio 0.78 1.90 2.20
Acid-test ratio 0.40 1.32 1.90
Accounts receivable turnover 41.29 33.20 10.60
Inventory turnover 3.58 6.25 7.80

1. Has your company performed worse, better, or about the same?

2. Should you be concerned about any ratio noted in your analysis?

3. What recommendations would you share with your boss on the financial health of the company?

Prepare a brief memo summarizing how your company is performing and recommendations. Use the questions as a guide.

Solutions

Expert Solution

1. The company performance has worsened from the last year, Sales Trend, Current ratio, Acid ratio all are declining.

2. The Sales Trend is declined from 22.1 in Year 20x8 to 16.7 in Year 20x9. It shows that our products are not pleasing the customers and we need to improve our product quality. There could be another possibility that products are overpriced, we should reduce the price if this is the case.

Current Ratio is also declining from 1.90 in Year 20x8 to 0.78 in Year 20x9. It shows that the company's current liabilities are more than current assets and in future company will be in trouble to repay the current liabilities. They may have to use assets other than current assets which can cause liquidity issues.

Lower Inventory Turnover ratio is also an concern area as it shows that inventory is not selling quickly like the previous year. It shows that there is decline in the demand of the product.

3. The top level management must consider current situation of the company as an area of concern and should analyse that why the sales are declining, they may consider to bring more creative arts and they have to consider that either there is change in the taste of customer's choice. They should focus on increasing the sales as this will bring more cash flow to the company which will help in improving the current ratio, acid ratio, inventory turnover ratio and sales trend. Through this company also earn more profits as of now.

I hope it will help you in the study.

Please give a Thumbsup if you like it.

Thank You!


Related Solutions

You are an analyst at Microsoft, and your boss has asked you to complete a ratio...
You are an analyst at Microsoft, and your boss has asked you to complete a ratio analysis for the firm’s competitors. Use the following information to write a complete ratio analysis for Microsoft’s competitors. Firm’s are identified by tickers below. Ratio MSFT IBM SAP AAPL Profit Margin ROE ROA Debt to Equity Current Ratio 28.31% 39.35% 9.44% 92.79% 3.12 10.97% 50.34% 6.64% 270.60% 1.29 16.53% 15.03% 8.36% 40.44% 1.59 22.72% 46.05% 10.89% 97.32% 1.30
This is your first week at a mutual fund as an analyst. Your boss asked you...
This is your first week at a mutual fund as an analyst. Your boss asked you to evaluate the price risk of two 30-year bonds – Bond A and Bond B. Bond A has a coupon rate of 4%, while Bond B has a coupon rate of 8%. Both bonds pay their coupons semi-annually . A) Construct an Excel spreadsheet showing the prices of each of these bonds for yields to maturity ranging from 1% to 15% at intervals of...
As a stock analyst, your boss, Jerry, has asked you to compile some information on stock...
As a stock analyst, your boss, Jerry, has asked you to compile some information on stock of Southern Infrastructure Corporation including a 95% confidence interval for the mean daily return that he needs to include in a report to senior management. He says that he is also not sure exactly what a 95% confidence interval means and would like you to add an explanation. You have been following the share price of Southern Infrastructure Corporation and have recorded the daily...
Imagine that you work for the U.S. Department of Justice as an economic analyst. Your boss...
Imagine that you work for the U.S. Department of Justice as an economic analyst. Your boss emails you and asks you to analyze the following scenarios for a market made up of two firms that compete by simultaneously setting quantities. Firm 1’s quantity is denoted by q1 and the cost of production in its factory is summarized by a cost function C(q1) = 20q1. Firm 2’s quantity is denoted by q2 and the cost of production in its factory is...
Imagine that you work for the U.S. Department of Justice as an economic analyst. Your boss...
Imagine that you work for the U.S. Department of Justice as an economic analyst. Your boss emails you and asks you to analyze the following scenarios for a market made up of two firms that compete by simultaneously setting quantities. Firm 1’s quantity is denoted by q1 and the cost of production in its factory is summarized by a cost function C(q1) = 20q1. Firm 2’s quantity is denoted by q2 and the cost of production in its factory is...
As a financial adviser to individual investors, your boss has asked you to write a memo...
As a financial adviser to individual investors, your boss has asked you to write a memo to him so that he can recommend a mortgage-backed bond to a client. The client has a particular corporate bond in mind, but your boss thinks that a pass-through mortgage-backed security would provide a better yield at the same risk level and maturity. The bond that the client is considering is a 7-year, AA-rated bond with a 6.75% coupon. When it matures, the proceeds will be...
As a financial adviser to individual investors, your boss has asked you to write a memo...
As a financial adviser to individual investors, your boss has asked you to write a memo to him so that he can recommend a mortgage-backed bond to a client. The client has a particular corporate bond in mind, but your boss thinks that a pass-through mortgage-backed security would provide a better yield at the same risk level and maturity. The bond that the client is considering is a 7-year, AA-rated bond with a 6.75% coupon. When it matures, the proceeds...
If you go to a crafts store and buy “glitter beads,” you get a little plastic...
If you go to a crafts store and buy “glitter beads,” you get a little plastic tube of tiny, metal covered glass or plastic beads. On a nice dry day, you can get a charge on the beads, and some of them will “hover” in the air inside the tube, maybe 4 mm apart from each other. It’s pretty cool. A. To make it even more cool, let’s estimate how much charge there is on a bead. For that, let’s...
Rafael, your newly appointed boss, has tasked you with evaluating the following financial data for Allied...
Rafael, your newly appointed boss, has tasked you with evaluating the following financial data for Allied Biscuit Co. to determine how Allied Biscuit’s value has changed over the past year. The investment firm for which you work will make a positive (or “buy”) recommendation to its investing clients if Allied Biscuit’s value has increased over the past year, a neutral (or “hold”) recommendation if the value has remained constant, or a negative (or “sell”) recommendation if the value has decreased....
Your boss, the chief financial officer (CFO) for Southern Textiles, has just handed you the estimated...
Your boss, the chief financial officer (CFO) for Southern Textiles, has just handed you the estimated cash flows for two proposed projects. Project L involves adding a new item to the firm’s fabric line. It would take some time to build up the market for this product, so the cash inflows would increase over time. Project S involves an add-on to an existing line, and its cash flows would decrease over time. Both projects have 3-year lives because Southern is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT