Simeon Case Study

Improved Essays
Exercise 17-7
1.
Current ratio = Current asset Current liability

2008
($378,00+502,00+54,000+5,000 )/($51,250) = 2.87 : 1

2009 ($35,625+62,500+82,500+9,375)/($75,250) = 2.52 : 1

2010 ($31,800+89,500+112,500+10,700)/($129,900) = 1.88 : 1

The current ratio is declining from 2008 , 2.87 : 1 to 2010 ,1.88 : 1.Therefore, the short-term debt-paying ability for Simeon Company is decrease.

2.
Acid –test ratio = cash+ short-term investment+ Current receivable
Current liabilities

2008
$37,800+50,200 = 1.72 : 1
$51,250

2009
$35,625+62,500 = 1.30 : 1
$75,250

2010
$31,800+89,500 = 0.93 : 1
$129,900

The acid-test ratio is declining from 2008 ,1.72 : 1 to 2010 0.93 : 1. Therefore the immediate short-term
…show more content…
Therefore ,the liquidity of receivables for Simeon Company is decrease.

3
Inventory turnover =Cost of goods sold Average inventory

2009
$345,500/(($82,500+54,000)/2) = 5.06 times

2010
$411,225/(($112,500+82,500)/2) = 4.22 times

The inventory turnover is decrease from year 2009, 5.06 times to 2010, 4.22 times. Therefore , the efficiency of inventory management for Simeon Company is decrease.

4
Days’ sales in inventory =( Ending inventory)/(Cost of goods sold ) X 365

2009
$82,500/($345,500 ) X 365 = 87.16 days

2010
$112,500/($411,225 ) X 365 = 99.85 days

The days’ sales in inventory is increase from year 2009 , 87.16 days to 2010 ,99.85 days. Therefore ,the liquidity of inventory for Simeon Company is decrease.

5
Account payable turnover = Cost of goods sold Average account payable

2009
$345,500/(($75,250+51,250)/2)= 5.46 times

2010
$411,225/(($129,900+75,250)/2) = 4 times

The account payable turnover is decrease from year 2009 ,5.46 times to 2010 4 times. Therefore, the frequency of trade credit payments for Simeon Company is
…show more content…
Therefore, the efficiency of collection for Simeon Company is decrease.

2
Days’ sales uncollected = (Account receivable ,net )/(Net sale)X365

2009
$62,500/$532,000 X 365 = 42.88 days

2010
$89,500/($673,500 )X 365 = 48.50 days

The days’ sale uncollected is increase from year 2009, 42.88 days to 2010, 48.5 day. Therefore ,the liquidity of receivables for Simeon Company is decrease.

3
Inventory turnover =Cost of goods sold Average inventory

2009
$345,500/(($82,500+54,000)/2) = 5.06 times

2010
$411,225/(($112,500+82,500)/2) = 4.22 times

The inventory turnover is decrease from year 2009, 5.06 times to 2010, 4.22 times. Therefore , the efficiency of inventory management for Simeon Company is decrease.

4
Days’ sales in inventory =( Ending inventory)/(Cost of goods sold ) X 365

2009
$82,500/($345,500 ) X 365 = 87.16 days

2010
$112,500/($411,225 ) X 365 = 99.85 days

The days’ sales in inventory is increase from year 2009 , 87.16 days to 2010 ,99.85 days. Therefore ,the liquidity of inventory for Simeon Company is decrease.

5
Account payable turnover = Cost of goods sold Average account payable

Related Documents

  • Decent Essays

    The asset turnover ratio is computed by dividing net sales by the average total assets. Yellow Leaf Fashion Inc. determines their asset turnover by taking their net sales of $2,919,800 divided by their average total assets of $2,569,180 which determines their asset turnover is 1.1365. This indicates that for every dollar of assets Yellow Leaf Fashion Inc. has it generates a profit of an average of $1.14 for this period. In conclusion, Yellow Leaf Fashion Inc. efficiently manages their assets to create revenue higher than their…

    • 1233 Words
    • 5 Pages
    Decent Essays
  • Improved Essays

    Kohl's Dupont Analysis

    • 705 Words
    • 3 Pages

    Kohl’s Corporation has a market cap of $ 12,150,841,350 billion, and it is one of the successful store chains in the United States. It offers a variety and exclusive merchandise to customers in an exciting and friendly environment (www.kohlscorporation.com). Also, Kohl’s keeps low retail prices through a low-cost, limited staffing, structure and continuing management information systems, as well as advertising. I use the DuPont analysis for Kohl’s Corporation in order to determine where the company is strong or weak such as the inventory, margins or debt structure. As the results of the DuPont analysis, Kohl’s has a higher ROE for 2010 and 2011 compare to JC Penney; for this reason, Kohl’s earns on shareholder equity for both years.…

    • 705 Words
    • 3 Pages
    Improved Essays
  • Decent Essays

    The company has a receivable turnover ratio of 15. This means that in 1 year period, the company turned its accounts receivables to cash 15 times, or the company had collected the receivables from their patients every 24 days. Its receivables of 9,687 are part of the company's revenues of $139,367 which the company generates from prescription drugs, cosmetics and various merchandise. It also generate revenues from its healthcare services through their medical clinics which are mostly located in the CVS store. Based on the effeciency ratio, the company is effecient in collecting their recievables.…

    • 106 Words
    • 1 Pages
    Decent Essays
  • Great Essays

    As we are dealing and focusing on retail businesses, understanding this ratio is paramount to the industry, as this is the heart of the business. The inventory turnover is calculated by taking the cost of goods sold divided by the average inventory for the year. This ratio measures the efficiency of a company's inventory management and should be compared against industry averages. A low turnover implies poor sales and therefore, excess inventory. A high ratio implies either strong sales or ineffective buying.…

    • 3708 Words
    • 15 Pages
    Great Essays
  • Decent Essays

    Kudler Fine Foods showed a profit for 2003, upon closer examination, our team believes that Kudler will continue to grow and profits will increase in the future. According to the current ratio, for every dollar of liability, there is close to $17 of assets to cover it, this implies that the short term debts will be easily paid if necessary. The Acid Test Ratio indicates the same healthy relationship between the liabilities and the assets, showing that the company can convert their assets quickly to create a quick conversion to cash. Inventory turnover indicates that the company does not tie up their cash for a long period of time; there is a quick change over rate.…

    • 275 Words
    • 2 Pages
    Decent Essays
  • Improved Essays

    Consolidated Electric Case Study: Report Discussion Question 1: Design an inventory control system for this business Consolidated Electric is a whole sale distributor of electrical equipment’s and supplies to electronic contractor owned by Joe Henry with an average sale of 20,000 line items. The current inventory method supported is a manual Cardex System which is outdated and not a cost effective way to manage the company inventory system. It is an Independent demand system which is directly proportional to the market condition in its current state. Henry sets a target earn turn ratio each year for the business which determines the estimated costs of operations and return on investment goal for the company, but has been ineffective to fulfill the actual demand supply for the business in an effective centralized way.…

    • 894 Words
    • 4 Pages
    Improved Essays
  • Decent Essays

    Liquidity ratios reflect the company’s ability to pay its bills, debts and commitments. The more liquid the company is, the more cash it has to finance its operations. By analyzing the financial reports and looking at the liquidity of the company we can determine if the company can meet its short-term commitments by liquidating the short-term assets, which is really important to creditors and investors. One of the first ratios used to determine and analyze Wendy’s liquidity and compare it against Sonic Drive-…

    • 286 Words
    • 2 Pages
    Decent Essays
  • Great Essays

    Swot Analysis Of Capsim

    • 4542 Words
    • 19 Pages

    Dividends Paid | | Sales of Common Stock | 13,700 | Purchase of Common Stock | | Cash from long term debt | 18994 | Retirement of long term debt | | Change in current debt (net) | 20341 | | Net change in cash position | 24600 | | Starting cash position | 3,434 |…

    • 4542 Words
    • 19 Pages
    Great Essays
  • Great Essays

    BSG Lessons Learned How did the key theories and concepts in the course relate to the simulation? The Business Strategy Game (BSG) was the practice of strategic management that offers virtual executive experience. The assigned team could analyze the market, set the direction, and make strategy for company’s growth in BSG.…

    • 1159 Words
    • 5 Pages
    Great Essays
  • Improved Essays

    Dynashears Case Analysis

    • 1281 Words
    • 5 Pages

    The excess inventories they have been unable to sell make up a significant proportion of Dynashears assets. Their current quick ratio, which is a measure of a businesses ability to meet current obligation through the use of its liquid assets, is at decent, but less strong 1.95 (appendix 5). Also, their quick ratio is not exhibiting the same consistent positive trend the current ratio is (excel sheet). This suggests that the current ratio is overestimating the company’s ability to meet their obligations, because it counts inventories as assets. If the firm is not able to sell the inventories, then the existence of those inventories does not illustrate their ability to pay their debts.…

    • 1281 Words
    • 5 Pages
    Improved Essays
  • Improved Essays

    1) Cartwright Lumber has had steady YOY growth of 19% and 34% in 2002 and 2003 respectively. However, the first quarter of 2004 demonstrates slow growth to only 7%. This slowdown in growth is cause for question as to the projected continued growth of the business. Further analysis into the financial statements will reveal additional risk. Cartwright has had a steady decrease in cash, and an increase in AR and inventory which means more sales to customers but these sales are on credit.…

    • 716 Words
    • 3 Pages
    Improved Essays
  • Superior Essays

    Question 1. Aggregate inventory data suggest that while overall average inventory levels are declining, the relative percentage being held by manufacturers is increasing. Explain why you think this observation is either true or false. Describe how such a shift could benefit the operations of the entire channel and how manufacturers could take advantage of the shift.…

    • 1166 Words
    • 5 Pages
    Superior Essays
  • Great Essays

    Introduction This report is prepared for Shalom, who is considering purchasing shares in a company, ‘The Warehouse Group’. This report is aimed to provide Shalom with an analysis of the company and the viability of the investment in shares in ‘The Warehouse Group’. The Warehouse Group consists of four major segments which are: • The Warehouse (Red Sheds) • Torpedo 7 • Noel Lemmings • Warehouse…

    • 2423 Words
    • 10 Pages
    Great Essays
  • Improved Essays

    About the Company The Company primarily operates in the automotive segment. The company's automotive operations are further subdivided into Tata and other brand vehicles like Jaguar Land Rover which has enabled the company to enter the premium car market in developed markets such as the United Kingdom, the United States, Europe and China as well as several emerging markets such as Russia, Brazil and South Africa amongst others. Company produces wide range of products like Passenger Cars, Utility Vehicles, Light Commercial Vehicles, Medium and Heavy Commercial Vehicles. Automotive sector had an eventful fiscal 2017 due to ban on diesel cars, sale and registration of BSIII vehicles, and demonetization.…

    • 774 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    With the holidays around the corner and the biggest shopping night of the year companies need to plan what they want to sell on their shelves months ahead. By having excellent inventory management these companies in so many industries are able to become more successful. I agree with the statement, inventory management is the heart of the supply chain which has been said by many business experts. Without proper inventory management issues can and will occur upstream and downstream of the supply chain. Companies have been able to reduce costs by properly managing their inventory, “Hewlett Packard achieved more than $130 million in total inventory savings” (supplychain) Companies that properly use an enterprise resource planning (ERP) system are able to have visibility of what inventory they have throughout their company.…

    • 1142 Words
    • 5 Pages
    Improved Essays