Friday, November 15, 2019

Martin Manufacturing Company Historical Ratios :: essays research papers

Martin Manufacturing Company Historical Ratios RATIOS  Ã‚  Ã‚  Ã‚  Ã‚  ACTUAL 2001  Ã‚  Ã‚  Ã‚  Ã‚  ACTUAL 2002  Ã‚  Ã‚  Ã‚  Ã‚  ACTUAL 2003  Ã‚  Ã‚  Ã‚  Ã‚  INCREASE (DECREASE)  Ã‚  Ã‚  Ã‚  Ã‚  INDUSTRY AVERAGE   Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚  Ã‚   Current ratio  Ã‚  Ã‚  Ã‚  Ã‚  1.7  Ã‚  Ã‚  Ã‚  Ã‚  1.8  Ã‚  Ã‚  Ã‚  Ã‚  2.5  Ã‚  Ã‚  Ã‚  Ã‚  0.7  Ã‚  Ã‚  Ã‚  Ã‚  1.5 Quick Ratio  Ã‚  Ã‚  Ã‚  Ã‚  1.0  Ã‚  Ã‚  Ã‚  Ã‚  0.9  Ã‚  Ã‚  Ã‚  Ã‚  1.3  Ã‚  Ã‚  Ã‚  Ã‚  0.4  Ã‚  Ã‚  Ã‚  Ã‚  1.2 Inventory turnover (times)  Ã‚  Ã‚  Ã‚  Ã‚  5.2  Ã‚  Ã‚  Ã‚  Ã‚  5.0  Ã‚  Ã‚  Ã‚  Ã‚  5.3  Ã‚  Ã‚  Ã‚  Ã‚  0.3  Ã‚  Ã‚  Ã‚  Ã‚  10.2 Average collection period (days)  Ã‚  Ã‚  Ã‚  Ã‚  50.0  Ã‚  Ã‚  Ã‚  Ã‚  55.0  Ã‚  Ã‚  Ã‚  Ã‚  58.0  Ã‚  Ã‚  Ã‚  Ã‚  3.0  Ã‚  Ã‚  Ã‚  Ã‚  46.0 Total asset turnover (times)  Ã‚  Ã‚  Ã‚  Ã‚  1.5  Ã‚  Ã‚  Ã‚  Ã‚  1.5  Ã‚  Ã‚  Ã‚  Ã‚  1.6  Ã‚  Ã‚  Ã‚  Ã‚  0.1  Ã‚  Ã‚  Ã‚  Ã‚  2.0 Debt Ratio (%)  Ã‚  Ã‚  Ã‚  Ã‚  45.8  Ã‚  Ã‚  Ã‚  Ã‚  54.3  Ã‚  Ã‚  Ã‚  Ã‚  57.0  Ã‚  Ã‚  Ã‚  Ã‚  2.7  Ã‚  Ã‚  Ã‚  Ã‚  24.5 Times interest earned ratio  Ã‚  Ã‚  Ã‚  Ã‚  2.2  Ã‚  Ã‚  Ã‚  Ã‚  1.9  Ã‚  Ã‚  Ã‚  Ã‚  1.6  Ã‚  Ã‚  Ã‚  Ã‚  (0.3)  Ã‚  Ã‚  Ã‚  Ã‚  2.5 Gross profit margin (%)  Ã‚  Ã‚  Ã‚  Ã‚  27.5  Ã‚  Ã‚  Ã‚  Ã‚  28.0  Ã‚  Ã‚  Ã‚  Ã‚  27.0  Ã‚  Ã‚  Ã‚  Ã‚  (1.0)  Ã‚  Ã‚  Ã‚  Ã‚  26.0 Net profit margin (%)  Ã‚  Ã‚  Ã‚  Ã‚  1.1  Ã‚  Ã‚  Ã‚  Ã‚  1.0  Ã‚  Ã‚  Ã‚  Ã‚  0.7  Ã‚  Ã‚  Ã‚  Ã‚  (0.4)  Ã‚  Ã‚  Ã‚  Ã‚  1.2 Return on total assets (ROA %)  Ã‚  Ã‚  Ã‚  Ã‚  1.7  Ã‚  Ã‚  Ã‚  Ã‚  1.5  Ã‚  Ã‚  Ã‚  Ã‚  1.1  Ã‚  Ã‚  Ã‚  Ã‚  (0.4)  Ã‚  Ã‚  Ã‚  Ã‚  2.4 Return on common equity (ROE %)  Ã‚  Ã‚  Ã‚  Ã‚  3.1  Ã‚  Ã‚  Ã‚  Ã‚  3.3  Ã‚  Ã‚  Ã‚  Ã‚  2.5  Ã‚  Ã‚  Ã‚  Ã‚  (0.8)  Ã‚  Ã‚  Ã‚  Ã‚  3.2 Price / earning (P/E) ratio  Ã‚  Ã‚  Ã‚  Ã‚  33.5  Ã‚  Ã‚  Ã‚  Ã‚  38.7  Ã‚  Ã‚  Ã‚  Ã‚  34.5  Ã‚  Ã‚  Ã‚  Ã‚  (4.2)  Ã‚  Ã‚  Ã‚  Ã‚  43.4 Market/ book (M/B) ratio  Ã‚  Ã‚  Ã‚  Ã‚  1.0  Ã‚  Ã‚  Ã‚  Ã‚  1.1  Ã‚  Ã‚  Ã‚  Ã‚  0.9  Ã‚  Ã‚  Ã‚  Ã‚  (0.2)  Ã‚  Ã‚  Ã‚  Ã‚  1.2 Analysis Liquidity: The current ratio and quick ratios for the year 2003 are at 2.5 and 1.3, which are both higher than the industry average. The company has enough to cover short term bills and expenses. Both the current and quick ratios are showing an upward trend compared to 2001 and 2002. The current assets decreased by $ 20,264 to $ 1,531,181 and the current liabilities also decreased considerably by $255,402 to $616,000, a 29.3% decline, thus making the current ratio jump to a 2.5. The biggest decline was seen is accounts payable which decreased by $170,500 to $230,000, a decline of 42.6 %. Activity:   Ã‚  Ã‚  Ã‚  Ã‚  The inventory turnover is almost half compared to the industry average, although it managed to increase by 0.3 compared to 2002. The company needs to maintain a constant cost of goods sold and at the same time manage inventory more efficiently to maintain market competitiveness. The average collection period also increased slightly to 58 days, three days increase compared to 2002. The company needs to negotiate or persuade on efficient payment methods to customers to decrease the collection period down to industry average. The total asset turnover increased 0.1 to 1.6 but still failing to meet the industry standard of 2.0. Martin Manufacturing needs to boost sales while maintaining a constant asset value to meet or exceed industry standards. Debt:   Ã‚  Ã‚  Ã‚  Ã‚  The debt ratios increased by 2.7% to 57% more than double the industry standard of 24.5%. The long term debt increased from $700,000 to $ 1,165,250 an increment of 66.5% in the year 2002. The company is currently highly leveraged thus it needs to work on reducing long term debts and continue to increase assets. The times interest earned ratio dropped by 0.3 to 1.6 in the year 2003. The company could face difficulties making interest payments in case of a sales slump. Profitability: The gross profit margin is at 27% which is a percent higher than industry standards. The company is performing good and meeting industry standards in terms of cost of goods sold and sales volume. The net income margin decreased to 0.7% in 2003 a decrease of 0.3% compared to 2002.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.