Premium Essay

Evaluation of Inventory Turnover Ratios

In:

Submitted By 405288859
Words 1477
Pages 6
Introduction
Inventory turnover, the ratio of a firm’s cost of goods sold to its average inventory level, is generally used to measure performance of inventory management, analyze short-term liquidity, and assess performance improvements over time. In general, a higher value of inventory turnover indicates better performance in controlling inventory levels. And a lower value may be an indication of over-stocking which may pose risk of obsolescence and increased inventory holding costs. Inventory Turnover=cost of good sold/average inventory
Average Inventory=(beginning inventory+ending inventory)/2 Gross profit percentage, the ratio of a firm’s gross profit to net sales, often used to judge operating profitability.The higher the gross profit percentage is, the healthier the business is. The gross profit percentage is a statement to measure how efficient the business is in making profit during the production process. Gross profit=revenue-cost of good sold
Gross profit percentage=gross profit/revenue*100% Industries with higher gross profit percentages tend to have lower inventory turnover, and those two figures are different for different industries. There are several factors affecting those two ratios in different industries. First, the products’ price.High prices lead to high gross profit percentage, on the other hand, high prices lower the demand and sales, thus decrease the inventory turnover. Second, length of products’ life cycle. Businesses which produce perishable goods usually have higher turnover compared to those dealing in durables. A shorter product life cycle implies rapid speeds of consuming as well as requirement of updating and changing products to better meet consumer needs, thus will result in high inventory turnover.
Hence a comparison would only be fair if it is made between companies of same industry. So we chose five

Similar Documents

Premium Essay

Beximco Co.

...Ratio Analysis of Financial Statements  | 14 |   |   |   |   |   |   |   |   |   | |   | | | | | | | |   |   | |   | |   | | |                                                Working Capital Working capital is the excess of current assets over the current liabilities. It is   calculated by deducting current liabilities from current assets. Working capital = Current assets - Current liabilities     2005 | 2006 | Current assets | Current liabilities | Current assets | Current liabilities | 672,355,277 | 384,140,329 | 979,254,859 | 658,881,691 | Working capital =288,214,948 | Working capital = 320,373,168 |         Current ratio The current ratio is a widely used measure for evaluating company’s liquidities & short-term debt- paying ability: Current ratio = Current assets Current liabilities   2005 | 2006 | Current assets | Current liabilities | Current assets | Current liabilities | 672,355,277 | 384,140,329 | 979,254,859 | 658,881,691 | Current ratio =1.75 | Current ratio = 1.49 |          Comment                           The ideal current ratio of an organization is 1.2 times. The current ratio of Renata Ltd. in 2005 is 1.75 times and in 2006 is 1.49 times, which is lower than the previous year 2005. So liquidity and short-term debt paying ability is worse than the previous year. But the Renata Ltd. has liquidity ability 1.49 to pay the short term debt for 1 which is higher from the probable ideal ratio. ...

Words: 2362 - Pages: 10

Premium Essay

Financial Ratio Analysis

...2006, 2007 and 2008 to analyze the ratios, and conduct a DuPont analysis to find the competitive position and the level of performance of both the organizations in respect to the calculated ratios. In addition we have done index analysis of both balance sheet and income statement to find the position of the organizations in respect of profitability. The organizations are pharmaceutical companies. The reason behind calculating the ratios of different years of a company gives us a complete view about company’s gradual improvement or decline. The chosen company has gained significant popularity in the market of Bangladesh and has been running the business for a considerable period. The report consists of five types of ratio analysis which are as follows: 1. Liquidity Ratio 2. Financial Leverage Ratios 3. Interest Coverage Ratio 4. Activity ratios 5. Profitability Ratios Under these primary categories there are several other sub categories. I calculated those ratios and provided interpretation of the results and also evaluated the company’s position in terms of their results. Last but not the least we did the index analysis of the balance sheet and income statement. We found some problems in the financial activities of the company and provided recommendations based on that. 2. Introduction Ratio analysis is a numerical attempt to analyze the performance and financial position of a business. By converting absolute numbers into ratios, we can compare between one firm and...

Words: 6669 - Pages: 27

Premium Essay

Performance Evaluation and Ratio Analysis of Pharmaceutical Company in Bangladesh

...Performance evaluation and ratio analysis of Pharmaceutical Company in Bangladesh Faruk Hossan Md Ahsan Habib Supervisor: José Ferraz Nunes Examiner: Bengt Kjellén Master‟s thesis in international Business 15 ECTS Department of Economic and Informatics University West Spring term 2010 0 ABSTRACT The thesis applies performance evaluation of pharmaceutical company in Bangladesh. It means evaluate how well the company performs. The main aim is achieved through ratio analysis of two pharmaceutical (Beximco and Square pharmaceutical) companies in Bangladesh. The main data collection from the annual financial reports on Beximco and square pharmaceutical companies in 2007 to 2008.Different financial ratio are evaluated such liquidity ratios, asset management ratios, profitability ratios, market value ratios, debt management ratios and finally measure the best performance between two companies. The mathematical calculation was establish for ratio analysis between two companies from 2007-2008.It is most important factors for performance evaluation. The graphical analysis and comparisons are applies between two companies for measurement of all types of financial ratio analysis. Liquidity ratio is conveying the ability to repay short-term creditors and it total cash. It determines perform of short term creditor of both pharmaceutical companies under the three categories such as current ratio, quick ratio and cash ratio. Asset management ratio is measurement how to effectively...

Words: 12881 - Pages: 52

Premium Essay

Finance

...Performance evaluation and ratio analysis of Pharmaceutical Company in Bangladesh Faruk Hossan Md Ahsan Habib Supervisor: José Ferraz Nunes Examiner: Bengt Kjellén Master‟s thesis in international Business 15 ECTS Department of Economic and Informatics University West Spring term 2010 0 ABSTRACT The thesis applies performance evaluation of pharmaceutical company in Bangladesh. It means evaluate how well the company performs. The main aim is achieved through ratio analysis of two pharmaceutical (Beximco and Square pharmaceutical) companies in Bangladesh. The main data collection from the annual financial reports on Beximco and square pharmaceutical companies in 2007 to 2008.Different financial ratio are evaluated such liquidity ratios, asset management ratios, profitability ratios, market value ratios, debt management ratios and finally measure the best performance between two companies. The mathematical calculation was establish for ratio analysis between two companies from 2007-2008.It is most important factors for performance evaluation. The graphical analysis and comparisons are applies between two companies for measurement of all types of financial ratio analysis. Liquidity ratio is conveying the ability to repay short-term creditors and it total cash. It determines perform of short term creditor of both pharmaceutical companies under the three categories such as current ratio, quick ratio and cash ratio. Asset management ratio is measurement how to effectively...

Words: 12872 - Pages: 52

Premium Essay

Ratio Analysis

...Performance evaluation and ratio analysis of Pharmaceutical Company in Bangladesh Faruk Hossan Md Ahsan Habib Supervisor: José Ferraz Nunes Examiner: Bengt Kjellén Master‟s thesis in international Business 15 ECTS Department of Economic and Informatics University West Spring term 2010 0 ABSTRACT The thesis applies performance evaluation of pharmaceutical company in Bangladesh. It means evaluate how well the company performs. The main aim is achieved through ratio analysis of two pharmaceutical (Beximco and Square pharmaceutical) companies in Bangladesh. The main data collection from the annual financial reports on Beximco and square pharmaceutical companies in 2007 to 2008.Different financial ratio are evaluated such liquidity ratios, asset management ratios, profitability ratios, market value ratios, debt management ratios and finally measure the best performance between two companies. The mathematical calculation was establish for ratio analysis between two companies from 2007-2008.It is most important factors for performance evaluation. The graphical analysis and comparisons are applies between two companies for measurement of all types of financial ratio analysis. Liquidity ratio is conveying the ability to repay short-term creditors and it total cash. It determines perform of short term creditor of both pharmaceutical companies under the three categories such as current ratio, quick ratio and cash ratio. Asset management ratio is measurement how to effectively...

Words: 12872 - Pages: 52

Premium Essay

Fnt1

...done an evaluation of the company G financials, comparing Fiscal year 11and Fiscal year 12. I have chosen to evaluate the financials through thirteen (13) key financial Ratios. Below, you will find all thirteen (13) Ratios along with an explanation of those ratios, an evaluation and justification of all thirteen (13) ratios as a strength, weakness or satisfactory condition, and I will compare (where possible) these ratios to available information from other companies within the home center industry. Any and all financial information of Home Depot, Lowes and Orchard Supply Hardware Stores was retrieved from either www.nasdaq.com, or www.morningstar.com and I did use data sets from their fiscal year 2012 numbers. The evaluation of all thirteen (13) ratios is as follows.  Current Ratio: For fiscal year 12 the current ratio is 1.77, and in year 11 it was 1.86. In my opinion, this ratio is a weakness, and should be watched as it shows a downward trend from the previous fiscal year. While any ratio over one represents that the company could repay their debt if required to, it is not as stringent of an indicator as the acid test ratio. It does take into account inventory which is up approximately 32 percent, and even with the increase in inventory and an increase in net sales, gross profit and Net Earnings, the current ratio shows a decrease year over year. In comparison with comparable companies such as Home Depot and Lowes, Company G shows a slightly higher Current Ratio which is...

Words: 1667 - Pages: 7

Premium Essay

Report

...PREMIER UNIVERSITY ASSIGNMENT ON Financial Statements Analysis: Quantitative and Qualities Analysis Submitted To: Ms. Nilufar Sultana Lecturer Faculty of Business Studies Premier University Submitted By: 1. Shahida Khanam (0714111839) 2. Indrani Das (0714111862) 3. Supriya Singha (0714111874) 4. Tumpa Barua (0714111873) 5. Musfika Hossain Nammie (0714111870) 8th Semester (Finance) Section- A Date of Submission: 15th January, 2012 Preface As an institute of third world country we learn only theoretical knowledge. But as a student of Business Administration we need more realistic knowledge. After gathering realistic knowledge from any educational institution every student has to face practical work, because, a student cannot be a well learner by bookish knowledge. If the theoretical knowledge is not supported by the realistic knowledge, the knowledge will remain incomplete. As a student of Business Administration we think realistic knowledge is must for developing career. This assignment gives us the opportunity to get more realistic knowledge. Acknowledgement We have the immense pleasure and satisfaction in presenting this assignment, which is termination of our work. The gains of this assignment depend on the contribution of few people...

Words: 6340 - Pages: 26

Premium Essay

Assessing a Company’s Future Financial Health

...This financial evaluation will cover the period from 2005 through December 31, 2008. The evaluation will include a review of the profitability, use of assets, and financial leverage metrics. This company appears to be financially healthy and has shown improvement in many of the metrics reviewed. The company has little long term debt, and adequate cash and owners’ equity balances. However, there are also some metrics that reveal that without some additional adjustments, the growth experienced in the past may not be sustainable. This evaluation will answer the following questions as well. * What is the assessment of the performance of SciTronics during the 2005-2008 period? * Has the financial strength and its access to external sources of finance improved or weakened? * What are the 2-3 most important questions you would ask management as a result of the analysis To evaluate the company’s performance the following evaluation criteria will be used. * Has the overall profitability increased or decreased during the period? * How well does the company deploy its assets? * How sound is the company financing? Profitability How profitable is the company? The company profit continues to grow; the Return on Sales has improved by 2.3% over the 2005 period and there was sales growth of 21% in 2008. Another important metric the EBIAT (earnings before interest but after taxes) has increased by a healthy 281%, this ratio can be used...

Words: 1687 - Pages: 7

Premium Essay

Ratio Analysis

...Liquidity ratio: Current ratio: ACI | Ind. Avg. | 1.13 | 1.43 | Interpretation: In the year 2008 the ACI’s current asset is 1.13 times higher than its current liabilities. In 2008 the company’s current ratio is low than its Industry average. But it’s not very low. So we can say that the company doesn’t keep an excess current asset in hand. So we can say that the current liquidity position of the company is not very bad. Quick ratio: ACI | Ind.avg | .72 | .63 | Interpretation: In the year 2008 the company’s current asset excluding inventory is .72 times higher than its current liabilities. The company’s quick ratio is higher than the industry average. In 2008 the industry average is .63 times whereas ACI have a quick ratio of .72 times. So we can say that the liquidity position of the company is good. Working capital: = current asset- current liabilities =4989161667-4400784166=588377501 ACI had a working capital of $588377501 in 2008. Evaluation: Looking at the above ratios we are certain the company had enough liquid asset to cover up its short term liabilities in 2008, however it is also visible that the company was holding up lot of liquid asset such as cash rather than investing it. Asset management Ratio: Inventory turnover: ACI | Ind . avg. | 2.18 | 3.67 | Interpretation: In the year 2009 the company had sold out and restocked its inventory 2.18 times. ACI’s inventory turnover ratio is lower than the industry average. This indicates...

Words: 1477 - Pages: 6

Premium Essay

Financial Management

...Statements – 2009, 2010, 2011 4 Balance Sheets – 2009, 2010, 2011 5 Financial Ratios 7 Liquidity Ratios 7 Asset Management Ratios 7 Solvency ratios 9 Profitability ratios 9 Stock data & Du Pont Analysis 10 Recommendations 12 References: 13 List of Figures Figure 1 Graphical View of Net Income for SPRINT for the years 2009, 2010, 2011 4 Figure 2 SPRINT Nextel Shareholder’s Equity for the years 2009, 2010, 2011 6 Figure 3 SPRINT Nextel Earnings per share for the years 2009, 2010, 2011 10 Executive Summary SPRINT Nextel is a publicly-traded company (the New York Stock Exchange symbol is “S”) Sprint Nextel offers a comprehensive range of communications services bringing mobility to consumer, business and government customers. Sprint Nextel is widely recognized for developing, engineering and deploying innovative technologies, including two robust wireless networks offering industry leading mobile data services; instant national and international walkie-talkie capabilities; and an award-winning and global Tier 1 Internet backbone.(“S: SPRINT Nextel,” 2012, Market Watch Inc.). This report will present an evaluation of the following information for SPRINT Nextel: 1. Financial performance for the years, 2009, 2010, and 2011 2. An evaluation of SPRINT Nextel’s Du Pont Analysis for the years, 2009, 2010, and 2011 3. A specific...

Words: 1941 - Pages: 8

Premium Essay

Wesfarmers Financial Analysis

...analysis and evaluation of Wesfarmers Limited’s 2010 and 2011 fiscal year. The analysis of Wesfarmers performance is based on the 2011 Annual Report. To determine the financial standing of the company at the end of the year, data obtained from their Income Statement, Balance Sheet and Cash Flow Statement, the financial analysis ratios: Liquidity ratios, efficiency ratios, profitability ratios, financing ratios, and market-based investments and other ratios, are all calculated. A comparison of these ratios reveals that Wesfarmers Limited is a company with a stable financial system, capable of overcoming different unavoidable circumstances, and has a goodwill that enables them to gain the trust of shareholders and the market. This is an indication of why Wesfarmers has been able to build a stable business with efficient performance, and a significant assets portfolio from the value end of retail to its involvement in the resource sector. Wesfarmers is capable of establishing new businesses and working efficiently with the changing business and natural environment. TABLE OF CONTENTS EXECUTIVE SUMMARY ii A. LIST OF TABLES iv INTRODUCTION 1 RATIOS 2 EVALUATION 3 1.0 Short-Term Solvency or Liquidity Ratios 3 2.0 Efficiency Ratios 3 3.0 Profitability Ratios 4 4.0 Financing Ratios or Long-Term Solvency 4 5.0 Market-Based Investment Ratios and other Ratios 5 CONCLUSION 7 REFERENCES 8 A. LIST OF TABLES Table 0-1: Liquidity Ratios 2 Table 0-2: Efficiency Ratios 2 Table...

Words: 1960 - Pages: 8

Premium Essay

Solar Corporation Performance Evaluation

...consortium of industries and utilities in partnership with the United States Department of Energy and thereafter in February 1997 began the regular production of electricity. The primary aspect of the evaluation of the performance process involves the financial analysis and the low-electricity analysis. The Solar Two is a 10 mega Watt electricity molten salt central receiver. Here, a field of the sun`s energy is reflected onto the mounted cylindrical receivers on top of the tower by sun tracking mirrors called heliostats. The objective is to discover how the performance evaluation helps organization and employees towards achieving personal and organizational goals. The analysis of the corporate`s financial performance all year round will assist the organization to locate its internal strength and weaknesses and the steps to increase its productivity. The aspect of financial evaluation serves as a foundation of aligning the company` s financial performance with the goals and objectives of the company. Financial performance evaluation is a major function of the finance officer who assists the company to discover the points that needs improvement to increase the company`s competence and productivity. The scope of this analysis extends to the observation of the extent of evaluation results to assist in improving the performance in more efficient manner. Financial Management This is the organizing, planning, controlling, and directing the financial activities such as utilization...

Words: 4550 - Pages: 19

Premium Essay

Auditing Questions

...11 ANALYTICAL PROCEDURES—RATIO ANALYSIS FORM The auditor can use this form to document the performance and evaluation of ratio analysis in connection with analytical procedures performed in an audit. The form is only a guide and is not a substitute for professional judgment. The form may be modified by adding or omitting certain ratio analysis. CLIENT NAME: | | DATE OF FINANCIAL STATEMENTS: | | LIQUIDITY RATIOS 20__ | 20__ | 19__ | 19__ | 1. Current ratio = | | | | | Current Assets | | | | | Current Liabilities | _____ | _____ | _____ | _____ | Comments: | | | 20__ | 20__ | 19__ | 19__ | 2. Quick or acid test ratio = | | | | | Current Assets - Inventory | | | | | Current Liabilities | _____ | _____ | _____ | _____ | Comments: | | | PROFITABILITY RATIOS 20__ | 20__ | 19__ | 19__ | 1. Gross profit ratio = | | | | | Net Sales - Cost of Goods Sold | | | | | Net Sales | _____ | _____ | _____ | _____ | Comments: | | | 20__ | 20__ | 19__ | 19__ | 2. Operating margin ratio = | | | | | Income before Income Taxes and Interest | | | | | Net Sales | _____ | _____ | _____ | _____ | Comments: | | | 20__ | 20__ | 19__ | 19__ | 3. Net income ratio (or profit margin ratio) = | | | | | Net...

Words: 365 - Pages: 2

Premium Essay

Urban Outfitters

...Free People division. It designs, develops and markets young women's contemporary casual apparel. Urban Outfitters was founded by Richard A. Hayne and Scott A. Belair in 1970 and is headquartered at Philadelphia, PA. Financial Ratio Analysis Firms release financials at their fiscal year end which includes an Income Statement, Balance Sheet, and Statement of Cash Flows. Financial ration analysis and forecasting is performed based on the numbers from these financial statements. Financial ratio analysis consists of a series of ratios that measures a firm’s liquidity, profitability, and capital structure. These ratios illustrate how effective and efficient a firm’s operations are. Urban Outfitters Inc. has experienced an increase of sales volume with an average sales growth of 22.4% per year. As far as their competition, Urban Outfitters Inc has outperformed their nearest competitor’s sales growth. However, this must be kept in perspective since URBN has experience such significant gains due to the amateur status of added stores and wholesale lines. One of the important stages in the firm valuation process involves computing and analyzing a set of financial ratios for these components: liquidity, profitability, and capital structure. These ratios will establish a benchmark for the given industry and allow the firm a clearer perspective as to how effective and efficient their operations, past and present, are and have been. Financial...

Words: 3802 - Pages: 16

Premium Essay

Financial Analysis

...and Ratio analysis: HORIZONTAL AND VERTICAL ANALYSIS WORKING CAPITAL ANALYSIS BALANCE SHEET: GOLDEN LAWS 1. Non-current assets should be financed by equity Equity – Non-current assets = … 2. Non-current assets should be financed bay equity + long-term liabilities Equity + long-term liabilities – non-current assets = … 3. Current assets should be financed by current liabilities Current liabilities – Current assets = … INVESTMENT RATIOS Earning per ordinary share 1. EPOS= Net income – dividends for privileged shares/number of ordinary shares Dividends per ordinary share 2. DPOS= dividends for ordinary shares / number of ordinary shares Price to earnings, x times –how much shareholders are ready to pay for 1 unit of company’s net profit; how fast shareholders can have return on their shares 3. P/E = Stock price / EPOS … LIQUIDITY RATIOS (times) 1. Current Ratio = Current assets/ current liabilities 2. Quick Ratio = (Current assets – Inventory)/ current liabilities 3. Absolute Ratio = (current assets – Inventory – accounts receivable)/ current liabilities ACTIVITY RATIOS, OPERATION CYCLE EVALUATION 1. Inventory turnover, X times, 365 days a year = COGS/ Average Inventory Average days’ inventory on hand = 365/ Inventory Turnover 2. Average Collection Period ACP = Account receivable/ average daily sales Average daily sales = Sales/ 365 3. Total assets turnover, X times ...

Words: 426 - Pages: 2